Blog de Florent Appointaire

Blog sur les technologies Microsoft (Windows Server, System Center, Azure, Windows Azure Pack/Azure Stack, etc;)
    • 18/11/2014

    [DPM 2012 R2] Erreur SQL Server Reporting Services au moment de l’installation

    SCDPM

    En essayant d’installer DPM 2012 R2, j’ai reçu un message d’erreur comme quoi le service de reporting n’est pas installé sur le serveur SQL, avec plein de vérification à faire. le message d’erreur est le suivant:

    DPM Setup is unable to connect to the specified instance of SQL Server Reporting Service.Verify that the specified computer and the instance of SQL Server Reporting Service meets the following requirements:
    1)The computer is accessible over the network.
    2)A firewall is not blocking requests from the DPM computer. For steps to configure the firewall on the SQL Server, follow the steps described here:
    http://go.microsoft.com/fwlink/?LinkId=94001.
    3)The specified user belongs to the Administrator group on the computer running the SQL Server instance and the sysadmin role on the SQL Server instance.
    4)The SQL Browser service is running on the SQL server.
    5)TCP/IP protocol is enabled for the specified instance of the SQL server

    Toutes les vérifications étaient bonne de mon côté.

    Je suis allé voir du côté des logs d’installation dans C:\Program Files\Microsoft System Center 2012 R2\DPM\DPMLogs\DPMSetup.log et j’ai trouvé le log suivant:

    [11/18/2014 12:34:35 PM] Information : Microsoft System Center 2012 R2 Data Protection Manager setup started.
    [11/18/2014 12:34:35 PM] Data : Mode of setup = User interface
    [11/18/2014 12:34:35 PM] Data : OSVersion = Microsoft Windows NT 6.2.9200.0
    [11/18/2014 12:34:35 PM] Information : Check if the media is removable
    [11/18/2014 12:34:35 PM] Data : Folder Path = C:\Program Files\Microsoft System Center 2012 R2\DPM
    [11/18/2014 12:34:35 PM] Data : Drive Name = C:\
    [11/18/2014 12:34:35 PM] Data : Drive Type = 3
    [11/18/2014 12:34:35 PM] Information : Check attributes of the directory
    [11/18/2014 12:34:35 PM] Data : Folder Path = C:\Program Files\Microsoft System Center 2012 R2\DPM
    [11/18/2014 12:34:35 PM] Data : File Attributes = Directory
    [11/18/2014 12:34:35 PM] Information : Check if the media is removable
    [11/18/2014 12:34:35 PM] Data : Folder Path = C:\Program Files\Microsoft Data Protection Manager
    [11/18/2014 12:34:35 PM] Data : Drive Name = C:\
    [11/18/2014 12:34:35 PM] Data : Drive Type = 3
    [11/18/2014 12:34:35 PM] Information : Check attributes of the directory
    [11/18/2014 12:34:35 PM] Data : Folder Path = C:\Program Files\Microsoft Data Protection Manager
    [11/18/2014 12:34:35 PM] Data : File Attributes = Directory
    [11/18/2014 12:34:35 PM] Information : Check if the media is removable
    [11/18/2014 12:34:35 PM] Data : Folder Path = C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\DPMDB
    [11/18/2014 12:34:35 PM] Data : Drive Name = C:\
    [11/18/2014 12:34:35 PM] Data : Drive Type = 3
    [11/18/2014 12:34:35 PM] Information : Check attributes of the directory
    [11/18/2014 12:34:35 PM] Data : Folder Path = C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\DPMDB
    [11/18/2014 12:34:35 PM] Data : File Attributes = Directory
    [11/18/2014 12:34:36 PM] Information : The setup wizard is initialized.
    [11/18/2014 12:34:36 PM] Information : Starting the setup wizard.
    [11/18/2014 12:34:37 PM] Information : <<< Dialog >>> Welcome Page : Entering
    [11/18/2014 12:35:04 PM] Information : <<< Dialog >>> Welcome Page : Leaving
    [11/18/2014 12:35:04 PM] Information : <<< Dialog >>> Inspect Page : Entering
    [11/18/2014 12:35:27 PM] Information : Query WMI provider for path of configuration file for SQL Server 2008 Reporting Services.
    [11/18/2014 12:35:27 PM] Information : Querying WMI Namespace: \\DEVO-SQL01\root\Microsoft\SqlServer\ReportServer\RS_INST_SCDPM\v11\admin for query: SELECT * FROM MSReportServer_ConfigurationSetting WHERE InstanceName='INST_SCDPM'
    [11/18/2014 12:35:27 PM] * 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.GetRosettaConfigFilePath(String sqlServerMachineName, String sqlInstanceName, ConnectionOptions connectionOptions, String rosettaNamespace)
    [11/18/2014 12:35:27 PM] * Exception :  => DPM Setup is unable to connect to the specified instance of SQL Server Reporting Service.Verify that the specified computer and the instance of SQL Server Reporting Service meets the following requirements:
    1)The computer is accessible over the network.
    2)A firewall is not blocking requests from the DPM computer. For steps to configure the firewall on the SQL Server, follow the steps described here:
    http://go.microsoft.com/fwlink/?LinkId=94001.
    3)The specified user belongs to the Administrator group on the computer running the SQL Server instance and the sysadmin role on the SQL Server instance.
    4)The SQL Browser service is running on the SQL server.
    5)TCP/IP protocol is enabled for the specified instance of the SQL server.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: exception ---> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportServerNotInstalledException: Report server is not installed ---> 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.GetRosettaConfigFilePath(String sqlServerMachineName, String sqlInstanceName, ConnectionOptions connectionOptions, String rosettaNamespace)
        --- End of inner exception stack trace ---
        at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.GetRosettaConfigFilePath(String sqlServerMachineName, String sqlInstanceName, ConnectionOptions connectionOptions, String rosettaNamespace)
        at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.InspectPage.ValidateReportingInputs(String machineName, String instanceName)
        --- End of inner exception stack trace ---
        at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.InspectPage.ValidateReportingInputs(String machineName, String instanceName)
        at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.InspectPage.InspectThreadEntry()
    *** Mojito error was: RemoteReportingConnectionFailed; 0; None
    [11/18/2014 1:25:42 PM] Information : The setup was cancelled by user.
    [11/18/2014 1:25:42 PM] Information : Microsoft System Center 2012 R2 Data Protection Manager setup over.

    On peut voir que le problème est l’accès en WMI au serveur SQL:

    [11/18/2014 12:35:27 PM] Information : Querying WMI Namespace: \\DEVO-SQL01\root\Microsoft\SqlServer\ReportServer\RS_INST_SCDPM\v11\admin for query: SELECT * FROM MSReportServer_ConfigurationSetting WHERE InstanceName='INST_SCDPM'

    Le problème est le _ dans le nom de l’instance. DPM ne supporte pas de _ dans le nom de l’instance.

    J’ai recréé l’instance avec un nom sans _, et la, les prérequis sont passés sans problème.

    Bon courage