OpsMgr 2007 Reporting does not support a SQL SRS Instance name with an underscore character in it


InformationHere’s a quick note on an issue I saw recently.  When you are trying to install Reporting for System Center Operations Manager 2007 (SCOM 2007), the installation wizard may hang after you select the SQL SRS Instance and click the Next button if the SQL SRS Instance name has an underscore ( _ ) character in the name.  You will probably also see entries like those below in the setup log:

CAPACK: Binding to CLR version v2.0.50727
Calling custom action ReportingCAManaged!Microsoft.Reporting.Setup.ReportingManagedCAs.SetSRSPropertiesCA
MSI (s) (00!3C) [11:03:06:833]: PROPERTY CHANGE: Adding SRSPropertiesFailed property. Its value is ‘0’.
2010-09-21T11:03:06.9957990-04:00 Debug:

*** Trace Started ***

2010-09-21T11:03:07.0124012-04:00 Debug: SetSRSPropertiesCA: Rosetta Server is: <someName>.
2010-09-21T11:03:07.0153310-04:00 Debug: SetSRSPropertiesCA: SRS Instance is: <name_Name2>
2010-09-21T11:03:07.0446290-04:00 Debug: SetSRSPropertiesCA:  Actual SRS reg location is: SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10.S1_W8USSFJVS93\Setup
MSI (s) (00!3C) [11:03:07:048]: PROPERTY CHANGE: Adding SRS_INSTANCE_REGISTRY_LOCATION property. Its value is ‘<name>’.
2010-09-21T11:03:07.0514652-04:00 Debug: SetSRSPropertiesCA: SRS Instance is: <name_Name2>
2010-09-21T11:03:07.1881892-04:00 Error: SetSRSPropertiesCA error: Invalid namespace .
MSI (s) (00!3C) [11:03:07:191]: PROPERTY CHANGE: Modifying SRSPropertiesFailed property. Its current value is ‘0’. Its new value: ‘1’.
2010-09-21T11:03:07.1950254-04:00 Error: StackTrace:    at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at Microsoft.SystemCenter.Setup.SQLUtils.GetSRSWMIScope(String computerName, Boolean bIsSql2005, String instanceName, String srsWMINamespace, String srsClass)
   at Microsoft.SystemCenter.Setup.SQLUtils.GetSRSWMIInstance(String sqlSRSServer, String srsServerVersion, String srsClass)
   at Microsoft.Reporting.Setup.ReportingManagedCAs.SetSRSPropertiesCA(Session session)
MSI (s) (00:4C) [11:03:07:653]: NOTE: custom action _SetSRSProperties.9B663534_CD9B_41CC_9D93_4E84D3C5E165 unexpectedly closed the hInstall handle (type MSIHANDLE) provided to it. The custom action should be fixed to not close that handle.
Action ended 11:03:07: _SetSRSProperties.9B663534_CD9B_41CC_9D93_4E84D3C5E165. Return value 3.
Action ended 11:03:07: INSTALL. Return value 3.

The underscore character is not supported so if you run into this your only recourse is to uninstall the SQL SRS installation and reinstall SQL SRS using an instance name without an underscore character in it.

Hope this helps,

Milan Jajal | System Center Support Engineer

The App-V Team blog: http://blogs.technet.com/appv/
The WSUS Support Team blog: http://blogs.technet.com/sus/
The SCMDM Support Team blog: http://blogs.technet.com/mdm/
The ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
The OpsMgr Support Team blog: http://blogs.technet.com/operationsmgr/
The SCVMM Team blog: http://blogs.technet.com/scvmm/
The MED-V Team blog: http://blogs.technet.com/medv/
The DPM Team blog: http://blogs.technet.com/dpm/
The OOB Support Team blog: http://blogs.technet.com/oob/
The Opalis Team blog: http://blogs.technet.com/opalis

clip_image001 clip_image002

Comments (5)

  1. Zulqarnain Ali says:

    I am having an issue in installing SCOM R2.

    error:  Setup cannot locate the SC Database

    I have 3 servers

    1 DC (Domain Controller, Win 2008 Ent x64)

    1 DB (Database with SQL 2008 SP2, Win 2008 Ent x86)

    1 SCOM (Win 2008 Ent x64)

    I have opened port 1433 on DB, I have checked the TCP/IP and named Pipes settings on SQL, Every thing is in order, But still i am getting this error again and again.

    Please help me out in this regard.

  2. Ashok says:

    Do we have any solution for this kind of problem ???

  3. Ashok says:

    I resolved it by uninstall the SQL reporting services

  4. gautam says:

    Thanks a LOT.

  5. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    http://showboxandroids.com/showbox-apk/
    http://showboxappandroid.com/
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    http://showboxappk.com/showbox-for-ipad-download/
    http://showboxappk.com/showbox-for-iphone/
    Showbox for PC articles:
    http://showboxandroids.com/showbox-for-pc/
    http://showboxappandroid.com/showbox-for-pc-download/
    http://showboxforpcs.com/
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings.
    http://www.showboxforipad.org/showbox-apk/ Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    http://www.showboxforipad.org/
    http://movieboxappdownloads.com/moviebox-apk-android/
    http://movieboxappdownloads.com/download-moviebox-pc/
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    http://showboxforiphone.org/
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    http://ymaillogintips.com/
    Sign Up & Do registration for latest movies on Showbox application