Forum Discussion

Bruce_Cranksh1's avatar
Bruce_Cranksh1
Level 6
13 years ago

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?

   

Enterprise Vault
Information Governance
  • Bruce_Cranksh1's avatar
    Bruce_Cranksh1
    13 years ago

    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

  • Bruce_Cranksh1's avatar
    Bruce_Cranksh1
    Level 6
    13 years ago

    Hi Rahul

    This has been disabled and anti-virus.

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

  • Ameen's avatar
    Ameen
    Level 6
    13 years ago

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

  • Bruce_Cranksh1's avatar
    Bruce_Cranksh1
    Level 6
    13 years ago

    @ 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

     

     

  • Bruce_Cranksh1's avatar
    Bruce_Cranksh1
    Level 6
    13 years ago

    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

     

     

     

     

     

  • Ameen's avatar
    Ameen
    Level 6
    13 years ago

    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?