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 1 hour 58 minutes ago

See the comments in http://blogs.technet.com/b/configurationmgr/archive/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server.aspx