none
Prerequisit check fails on installing DPM 2012 RRS feed

  • Question

  • When trying to install DPM 2012 in a SQL Server 2012 Database instance the prerequisute check always fails claiming that the reporting services is not configured correctly.

    The Install Log says:

    [28.04.2013 18:07:55] Information : Getting the reporting secure connection level for MYSERVER/MSSQL_EXP_1
    [28.04.2013 18:07:55] Information : Querying WMI Namespace: \\MYSERVER\root\Microsoft\SqlServer\ReportServer\RS_MSSQL_EXP_1\v11\admin for query: SELECT * FROM MSReportServer_ConfigurationSetting WHERE InstanceName='MSSQL_EXP_1'
    [28.04.2013 18:07:55] * Exception :  => System.Management.ManagementException: Invalid namespace
       at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
       at System.Management.ManagementScope.InitializeGuts(Object o)
       at System.Management.ManagementScope.Initialize()
       at System.Management.ManagementObjectSearcher.Initialize()
       at System.Management.ManagementObjectSearcher.Get()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.GetWmiObjectCollection(String wmiNamespace, String wmiQuery, ConnectionOptions wmiConnectionOptions)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.GetReportingSecureConnectionLevel(String sqlMachineName, String sqlInstanceName, ConnectionOptions connectionOptions, String rosettaNamespace)
    [28.04.2013 18:07:55] * Exception : Failed to perform the check => System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: exception ---> System.Management.ManagementException: Invalid namespace
       at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
       at System.Management.ManagementScope.InitializeGuts(Object o)
       at System.Management.ManagementScope.Initialize()
    ....

    If you try to to execute the select directly via wbemtest, you will figure out, that the namespace as spelled in the log file does in deed not exist.

    The reason is, that (as documented by Microsoft), the namespace of the ReportServer database is built in WMI using the ENCODED instance name. The encoding works in a way that underscore (_) is replaced by (_5f).

    Therefore the query in the prereq checker MUST fail, if the name of the DB instance contains underscores !!!!

    Seems to be a bug in the prereq checker.

    Am I right?

    Is there a way to get around without deleting the DB instance and creating a new one with a name without underscores?

    Sunday, April 28, 2013 6:47 PM

Answers

  • Hi,

    Yes, DPM currently does not support an underscore in the instance name.  You must use a different instance.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, May 9, 2013 11:21 PM
    Moderator