locked
How do I create the certificate for SCCM to be able to connect to SQL 2012 Cluster RRS feed

  • Question

  • I have recently moved my 2012 SCCM database across from one SQL cluster to another.

    When SCCM was installed to the original cluster it created a self signed certificate on my first SQL server allowing the connection to take place (as far as I know)

    How do I create a self signed certificate for SCCM to use to connect to the Cluster address instead of one of the nodes in my cluster ?

    otherwise I get the below errors upon installation

    Permissions are set on the SQL server for all the accounts and servers in question, access s available through our firewall. I just cannot create the self signed certificate for the SQL cluster address

    To explain further 

    Cluster address: no certificate

    Node 1: has self signed certificate

    Node 2: has self signed certificate

    The name i am trying to connect to through the configuration manager sql database is the cluster name which i am guessing is why the error "principal name is incorrect"

    *** Failed to connect to the SQL Server, connection type: SMS ACCESS. Configuration Manager Setup 7/29/2015 3:45:37 PM 5864 (0x16E8)
    INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure Configuration Manager Setup 7/29/2015 3:45:37 PM 5864 (0x16E8)
    *** [08001][-2146893022][Microsoft][SQL Server Native Client 11.0]SSL Provider: The target principal name is incorrect. Configuration Manager Setup 7/29/2015 3:45:40 PM 5864 (0x16E8)
    *** [08001][-2146893022][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection Configuration Manager Setup 7/29/2015 3:45:40 PM 5864 (0x16E8)
    *** Failed to connect to the SQL Server, connection type: SMS ACCESS. Configuration Manager Setup 7/29/2015 3:45:40 PM 5864 (0x16E8)
    INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure Configuration Manager Setup 7/29/2015 3:45:40 PM 5864 (0x16E8)

    Thanks in advance !

    Wednesday, July 29, 2015 5:48 AM

All replies