SQL Server Certificate creation fails during installation

Asked By Patrick S Garcia 0 points N/A Posted on - 01/02/2014

Hi Everyone,

I received the following error when trying to install System Centre Configuration Manager 2012. The SQL Server certificates are not being created and due to this the installation could not be completed. I tried giving full permissions on the cert folder to different accounts like local account, domain admin account, network service account etc. But this did nothing to improve the situation. I attempted running SQL under all those accounts and none of them succeeded in creating the SQL certificate. What else can I try to fix this issue? Please give me some ideas to solve this. Thanking you.

Fail to create SQL Server Certificate, ConfigMgr installation cannot be completed. Click the View Log button for more information.

• Status: Open
• Question Views: 1909
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Tim Lahaye 10 points N/A #179601

SQL Server Certificate creation fails during installation

Many times it is seen that this is due to the account in the site server machine that is not in the SQL machine or this doesn't have the write permissions to the registry on the remote SQL server. Check that you are running your SQL Server on Windows Server 2008 or Windows Server 2008 R2. Or, ensure that the following is configured properly. The computer account of SCCM2012 and also the account used for the installation must be the members of the local admins group on your SCCM2012 and also need sysadmin rights in SQL. Configure your SQL services so that it runs under a domain user account rather than as local system or network service. Or, try to delete the registry key which generated during installation of SCCM i.e. (HKLMSOFTWAREMicrosoftSMS). Run the setup again.

About Tim Lahaye

Questions
3

Answers
256

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 04/05/2014
• Question Category: MySQL Server