systemcentercommunity
Your community resource for Microsoft's System Center family of products

Installing Ops Mgr 2007 Reporting

Latest post 02-21-2008 4:21 PM by hokiejimbo. 13 replies.
  • 05-07-2007 10:35 AM

    • Adeel
    • Top 500 Contributor
    • Joined on 04-17-2007
    • Posts 9

    Installing Ops Mgr 2007 Reporting

    Just wondering if anyone has run into this and knows how to fix it.  When I try to install Operations Manager 2007 Reporting I get the following error after I go through the installation wizard:

    SRS Server Validation error.  Setup was unable to validate SQL Reporting Services.  Please use the Reporting Services Configuration tool which is installed with SQL Server to validate your SQL Reporting Services Configuration.


    When I run the tool everything has a green checkmark except 'Initialization' -- it has a checkmark but the colour is gray.

  • 05-28-2007 8:47 AM In reply to

    • ijross
    • Not Ranked
    • Joined on 04-25-2007
    • Posts 2

    Re: Installing Ops Mgr 2007 Reporting

    Hi,

    I have had the same issue and have tried to re-apply SP2 for SQL 2005, but to no avail!

     

    Any one with ideas?

  • 05-29-2007 8:59 PM In reply to

    • ibrook
    • Top 500 Contributor
    • Joined on 03-14-2006
    • Posts 4

    Re: Installing Ops Mgr 2007 Reporting

     I just had the same issue and fixed/worked around it by...

     Uninstalling SQL and IIS.

    Reinstalling IIS and SQL with SP1 + hotfixes this time (not SP2).

    Configuring the options in "Configure Report Server" console (not encryption or email). The least intuitive option was the 'Database Connection' setting which required the 'Connect', 'New' and 'Upgrade' options choosen in sequence.

     install SCOM reporting server

  • 05-30-2007 1:03 AM In reply to

    • ibrook
    • Top 500 Contributor
    • Joined on 03-14-2006
    • Posts 4

    Re: Installing Ops Mgr 2007 Reporting

    I have now verified the install with SQL SP2.

    My main suspicions point to the "Configure Report Server" settings. I must have not completed this successfully in the first instance.

  • 05-31-2007 4:18 AM In reply to

    • ijross
    • Not Ranked
    • Joined on 04-25-2007
    • Posts 2

    Re: Installing Ops Mgr 2007 Reporting

    Hi, Unfortunately, I have another app on this server that needs IIS and SQL. I did find this:

     (If it works I will let you know).

    http://opsmgr.wordpress.com/2007/05/10/srs-server-validation-error/

    If you receive the error: SRS Server Validation Error while installing SCOM Reporting, dont forget you need to Configure Reporting Server first.

    To do this you need to go START -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporing Services Configuration. Then on each of the Items that have a Red X or Yellow ! select them and configure them accordingly.

    If you see any grey items this means that they cant be validated and even though you have configured another item it could be incorrect. The most common is the Initialisation option, if this is grey then you probably authentication

  • 05-31-2007 10:35 AM In reply to

    • davstc
    • Top 10 Contributor
    • Joined on 02-25-2005
    • Seattle, Wa
    • Posts 163

    Re: Installing Ops Mgr 2007 Reporting

     Make sure this is the only SRS application on the server, SCOM07 will remove the SRS interface and permissions in order to use the new SCOM07 reporting interface and permissions. This is very different than the last version of MOM reporting.

     

    David 

    David St.Clair Infront Consulting For great, technical information on Operations Manager 2007 and other System Center technologies, check out our training offerings at http://www.infrontconsulting.com/events.htm.
  • 11-14-2007 10:05 AM In reply to

    Re: Installing Ops Mgr 2007 Reporting

    Im having the same issue as above; i have sql 2005 sp2 and im getting the same error what the hell is going on?

  • 11-14-2007 11:30 AM In reply to

    Re: Installing Ops Mgr 2007 Reporting

    duster:

    Im having the same issue as above; i have sql 2005 sp2 and im getting the same error what the hell is going on? should the initialization on the configure report page be green currently its greyed out?

     

    Im also getting the error in IIS when i attempt to browse the report web page.

     

    Server Error in '/ReportServer' Application.

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: Could not load type 'Microsoft.EnterpriseManagement.OperationsManager.WebConsole.RequestManager'. (E:\Program Files\System Center Operations Manager 2007\Web Console\web.config line 53)

    Source Error:

    Line 51:     </httpHandlers>
    Line 52: <httpModules>
    Line 53: <add name="RequestManager" type="Microsoft.EnterpriseManagement.OperationsManager.WebConsole.RequestManager" />
    Line 54: </httpModules>
    Line 55: <!--

    Source File: E:\Program Files\System Center Operations Manager 2007\Web Console\web.config    Line: 53


    Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
     

  • 11-19-2007 6:21 AM In reply to

    • Aquila
    • Top 25 Contributor
    • Joined on 10-11-2007
    • Northampton, UK
    • Posts 150

    Re: Installing Ops Mgr 2007 Reporting

    I have experienced most of the problems with installing reporting in my Test environment and every time it is down to a problem with the SQL SRS configuration.  Just because everything is showing as green ticks doesn't actually mean it is correct and it'll work.  Permission issues with the accounts used to set up SRS were the problem every time for me, particularly the Report Server Window service account.

    David Allen

    http://www.aquilaweb.com
    MCSE: Security - MCITP: Enterprise Administrator
    WMUG Community Leader http://www.wmug.co.uk

  • 12-14-2007 8:18 AM In reply to

    • Walfa
    • Not Ranked
    • Joined on 12-14-2007
    • Posts 1

    Re: Installing Ops Mgr 2007 Reporting

    i have had the same issue when installing SCOM 2007.

    I had to reset the Reporting services config with the following actions:

    1. COPY the ResetSRS.exe file in SupportTool folder of OM 2007 to C:\. (Ofcourse, you can run this file in OM folder.)2. Then open the COMMAND PROMP and change your path to C:\.3. Type "ResetSRS.exe  MSSQLSERVER" where MSSQLSERVER is yourSQLINSTANCENAME.4. Then open Reporting Services Configuration Console in your Program Menuand select Web Service Identity and on the right side click Apply.5. Finally, reinstall your reporting service by running OMSetup.exe again.

    Regards, Walter.

  • 12-14-2007 3:10 PM In reply to

    • Grussell
    • Not Ranked
    • Joined on 12-14-2007
    • Dover, DE
    • Posts 1

    Re: Installing Ops Mgr 2007 Reporting

    Thanks Walt!

     

    This worked for me.

    Gil Russell Server manager Delaware State University
  • 01-02-2008 6:08 PM In reply to

    • shales
    • Not Ranked
    • Joined on 01-02-2008
    • Posts 1

    Re: Installing Ops Mgr 2007 Reporting

    thanks very much for the help. your solution worked for me also.

    Susan

     

  • 01-30-2008 4:29 PM In reply to

    Re: Installing Ops Mgr 2007 Reporting

    didn´t worked for me. But this helped (all i test enviroment)

    Actually first I Had not installede ASP (Windows components)

    saw I event view the network service and aspnet user didn´t have write access to "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files". So it worked (Still greay out i "Reporting Service Configuration Manager"

  • 02-21-2008 4:21 PM In reply to

    Re: Installing Ops Mgr 2007 Reporting

    I thought I had ASP installed right (and know I did b/c SQL Reporting doesn't install without this) but at some point these settings were changed.  I followed these instructions (link below):

     ASP.NET 2.0, 64-bit version
    To run the 64-bit version of ASP.NET 2.0, follow these steps:

    1. Click Start, click Run, type cmd, and then click OK.
    2. Type the following command to disable the 32-bit mode:

    cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0
    3. Type the following command to install the version of ASP.NET 2.0 and to install the script maps at the IIS root and under:

    %SYSTEMROOT%\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
    4. Make sure that the status of ASP.NET version 2.0.50727 is set to Allowed in the Web service extension list in Internet Information Services Manager.

    http://www.expta.com/2007/11/installing-or-switching-aspnet-versions.html 

Page 1 of 1 (14 items) | RSS
Copyright @ 2008 Silect Software Inc.
Powered by Community Server (Commercial Edition), by Telligent Systems