cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Issue with EV Sql Reporting Config

Hi All

I have a customer on EV 9.0 sp2

 

They have installed SQL Reporting Services 2008 32 bit on Windows 2008, we  can bring up the default Reports Webpage but when we try to run the EV Reporting Config it sits on the Checking if IIS is running and doesn't progress so we cannot complete the EV SQL Reporting Config. The IIS 6 Management Compatilbility is installed, any ideas what would cause this not to complete the Config?

   

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Hi Ameen and others   The

Hi Ameen and others

 

The customer decided just to install SQL 2005 reporting services and that is now working.

Thanks for the help and assistance

View solution in original post

16 Replies
Highlighted

Do you have UAC enabled on

Do you have UAC enabled on the SQL server?

Highlighted

Hi RahulThis has been

Hi Rahul

This has been disabled and anti-virus.

AV has caused issues at this customer so I wanted to be sure

Highlighted

Did you confirm that the EV

Did you confirm that the EV service account has local admin access on the SQL server?

Highlighted

Is there anything in the

Is there anything in the installation log?

Highlighted

@ Ameen Yes the Service

@ Ameen

Yes the Service  account is in the local admins

@ AVMorris

Just to clarify, what installation  log are you referring to. Do you mean the EVDeployReports.Log

I haven't reviewed that yet

 

 

Highlighted

Yes!  Is there anything of

Yes!  Is there anything of interest?

Highlighted

Hi AWMorris   I'll check that

Hi AWMorris

 

I'll check that today when I'm onsite and give feedback

Thanks

Highlighted

The last lines of

The last lines of the  EVDeployReports.Log say the following, in my opinion not really helpful because I already know that the Config Program isn't communicating with IIS on the server

 

 

[2012/05/11 08:56:45:055] Leaving UIHelper::LoadXMLDocument()

[2012/05/11 08:56:45:055] XPath Query used to find the help file: /EVReportingFiles/EVReportHelp/File[@NeutralLocale='en']

[2012/05/11 08:56:45:060] Finding help file for UI culture: en-US

[2012/05/11 08:56:45:060] Entered UIHelper::GetCurrentFilePath

[2012/05/11 08:56:45:060] Leaving UIHelper::GetCurrentFilePath

[2012/05/11 08:56:45:060] Help File Complete Path: C:\Program Files (x86)\Enterprise Vault\\Documentation\en\Admin_Console_Help.chm

[2012/05/11 08:56:45:060] Leaving ReportDeployForm::ReportsDeployForm_Load

[2012/05/11 08:56:49:217] Leaving UIHelper::GetSQLServersList

[2012/05/11 08:56:49:220] Entered ReportDeployForm::GetSQLServersCallback

[2012/05/11 08:56:49:290] Entered Configuration::Configuration()

[2012/05/11 08:56:49:291] Entered RsHelper2005::RsHelper2005()

[2012/05/11 08:56:49:291] Leaving RsHelper2005::RsHelper2005()

[2012/05/11 08:56:49:291] Leaving Configuration::Configuration()

[2012/05/11 08:56:49:291] Entered Configuration::11:24 AM 2012/05/11

[2012/05/11 08:56:49:294] Entered RsHelper::ListReportServerItems()

[2012/05/11 08:56:49:299] Waiting for web response, RetryCount = 1

[2012/05/11 08:57:19:299] Waiting for web response, RetryCount = 2

[2012/05/11 08:57:49:301] Waiting for web response, RetryCount = 3

[2012/05/11 08:58:19:359] Waiting for web response, RetryCount = 4

[2012/05/11 08:58:49:365] Waiting for web response, RetryCount = 5

 

 

 

 

 

Highlighted

Port?

Is SQL/IIS running on the default ports?

Regards. Gertjan
Highlighted

I did try to test it in my

I did try to test it in my Lab and found its true that the configuration sits at checking IIS!!

Below are the server details,

SQL - SQL 2008 R2 64 bit

Windows - Windows 2008 R2

EV - EV 9.0.2

 

Anybody have experience in running reporting on Windows 2008 system?

Highlighted

I could find some time to

I could find some time to work on my lab and could find that ASP was not installed on my server and once I install the same it started working.

 

Also find an article which help for troubleshooting Reporting, you can download the guide  'Troubleshooting enterprise vault reporting' by following the below link, trust me it helps Smiley Happy

http://www.symantec.com/business/support/index?page=content&id=TECH51288

 

Highlighted

Hi Ameen Thanks for putting

Hi Ameen

Thanks for putting in the effort to simulate this issue, I'll look into that possible ASP config.

 

Oh and those updated guides are very useful. I was using them but not the updated ones Smiley Happy

Highlighted

I've also seen Windows

I've also seen Windows Firewall cause some issues when it comes to the reporting server if the ASP suggestion fails to resolve the issue.

Highlighted

One question I forget to ask

One question I forget to ask you, whether your customer is trying to migrate the old reporting database/reporting to new server? If that is the case then encriptiong key part you have to look.

Highlighted
Accepted Solution!

Hi Ameen and others   The

Hi Ameen and others

 

The customer decided just to install SQL 2005 reporting services and that is now working.

Thanks for the help and assistance

View solution in original post

Highlighted

Had the same issue today. In

Had the same issue today. In order for me to get it to work.

I removed the proxy settings within Internet Explorer and created an ODBC connection to the reporting database and directory database and the reports deployed succesfully.