cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with EV Sql Reporting Config

Bruce_Cranksh1
Level 6
Partner Accredited

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 ACCEPTED SOLUTION

Accepted Solutions

Bruce_Cranksh1
Level 6
Partner Accredited

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 16

RahulG
Level 6
Employee

Do you have UAC enabled on the SQL server?

Bruce_Cranksh1
Level 6
Partner Accredited

Hi Rahul

This has been disabled and anti-virus.

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

Ameen
Level 6

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

AWMorris
Level 4
Partner Accredited Certified

Is there anything in the installation log?

Bruce_Cranksh1
Level 6
Partner Accredited

@ 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

 

 

AWMorris
Level 4
Partner Accredited Certified

Yes!  Is there anything of interest?

Bruce_Cranksh1
Level 6
Partner Accredited

Hi AWMorris

 

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

Thanks

Bruce_Cranksh1
Level 6
Partner Accredited

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

 

 

 

 

 

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

Is SQL/IIS running on the default ports?

Regards. Gertjan

Ameen
Level 6

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?

Ameen
Level 6

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 :)

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

 

Bruce_Cranksh1
Level 6
Partner Accredited

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 :)

Chris_Alleman
Level 4
Employee Accredited Certified

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.

Ameen
Level 6

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.

Bruce_Cranksh1
Level 6
Partner Accredited

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

Tmarques
Level 4
Partner Accredited

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.