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?
Solved! Go to Solution.
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
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?
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 :)
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 :)
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.