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 !
- Edited by Pappagussepi Wednesday, July 29, 2015 5:51 AM