none
System Center Data Protection Manager 2012 - Problem with creating roles for self service recovery for a protected SQL cluster RRS feed

  • Question

  • I recently upgraded to System Center DPM 2012 from 2010 and so far it is working great. I wanted to set up self-service recovery and see that there is a new feature to set up role based access for this functionality. However, when creating a new role to recovery data for a clustered SQL server, I am not able to add the SQL instance properly. I have a sql cluster called SQLCLUSTERTEST which can be properly addressed within SQL Management Studio and it is even in a protection group in DPM already. However, if I try to create a role and add SQLCLUSTERTEST as the SQL instance, I get the following error:

    The specified SQL instance SQLCLUSTERTEST is either invalid or cannot be found (ID: 32608). If a SQL instance exists with the specified name, use Get-DataSource -ProductionServer <ProductionServer> -Inquire cmdlet to refresh the information.

    If I try to run that cmdlet from the DPM powershell console, I get the following error:

    PS C:\Program Files\Microsoft DPM\DPM\bin> get-datasource -productionserver sqlclustertest
    Get-DPMDatasource : Cannot bind parameter 'ProductionServer'. Cannot convert th
    e "sqlclustertest" value of type "System.String" to type "Microsoft.Internal.En
    terpriseStorage.Dls.UI.ObjectModel.OMCommon.ProductionServer".
    At line:1 char:33
    + get-datasource -productionserver <<<<  sqlclustertest
        + CategoryInfo          : InvalidArgument: (:) [Get-DPMDatasource], Parame
       terBindingException
        + FullyQualifiedErrorId : CannotConvertArgumentNoMessage,Microsoft.Interna

       l.EnterpriseStorage.Dls.UI.Cmdlet.Common.GetDatasource

    I have tried different combinations as suggested by the following post: http://scdpm.blogspot.com/2011/11/self-service-recovery-for-sql-cluster.html but when I try adding (MSSQLSERVER).WINCLUSTERTEST.DOMAIN.COM (domain name has been changed), then I get the following:

    The server (MSSQLSERVER).WINCLUSTERTEST.DOMAIN.com could not be found in Active Directory (ID: 31144). Ping this server to verify that it is accessible and then retry the operation.

    Any clues on how to add a cluster resource into a role? BTW, I am able to successfully add standalone SQL instances for roles and as I have said previously, I am able to set up protection groups for the SQL cluster, just not set up a role for the self-service recovery.


    Kuong Chaing

    Wednesday, May 16, 2012 6:41 PM

Answers

  • Hi Kuong,

    Here is how you setup the instance name for SQL Clustered resources:

    You need to give use the Cluster Network Name + ServerName\InstanceName

    As example here is my Clustered SQL Protection.

    In Self Service Recovery I enter the following SQL Instance Information

    BRUKE.WILSON-FAILOVER.WSOUZA.LOCAL\WILSON-SQL2K8R2\BRUKE

    Let me know if this works for you


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights

    Thursday, May 24, 2012 6:16 AM
    Moderator

All replies

  • Hi Kuong,

    Here is how you setup the instance name for SQL Clustered resources:

    You need to give use the Cluster Network Name + ServerName\InstanceName

    As example here is my Clustered SQL Protection.

    In Self Service Recovery I enter the following SQL Instance Information

    BRUKE.WILSON-FAILOVER.WSOUZA.LOCAL\WILSON-SQL2K8R2\BRUKE

    Let me know if this works for you


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights

    Thursday, May 24, 2012 6:16 AM
    Moderator
  • Hi Wilson,

    This did the trick. The issue that I was having is that for some reason, my cluster network name has spaces in it and I thought this was an FQDN which cant have spaces. Do you know how this information is populated/calculated?

    Here is what my protection group shows and what I had to enter in the self-recovery wizard:


    Kuong Chaing

    Friday, June 8, 2012 2:59 PM