Your company's ad could live here and reach over 50,000 people a month!

Share This Post

SCCM 2012 Install: Failed to create SQL Server Certificate

I received the following error during a System Center Configuration Manager 2012 install.

image

I checked out the log using CMTrace.exe and discovered these errors:

  • Cannot write CertBootStrap\SMS_SQL_SERVER\ registry key on server SQL.DOMAIN.com. The operating system reported error 4        Configuration Manager Setup        4/01/2012 1:18:55 AM        1376 (0×0560)
  • ERROR: Failed to write certificate configuration to registry on server SQL.DOMAIN.com        Configuration Manager Setup        4/01/2012 1:18:55 AM        1376 (0×0560)
  • ERROR: Failed to create SQL Server [SQL.DOMAIN.com] certificate remotely.        Configuration Manager Setup        4/01/2012 1:18:55 AM        1376 (0×0560)

To resolve this make sure the account you are installing with (logged in as when installing) has

  • local administrative rights on the SQL server
  • sysadmin role in SQL security

and

  • this key does not already exist in the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS .

After you ensure the following try re-running your SCCM 2012 setup.

NOTE: CMTrace.exe can be found here: [SCCM2012InstallMedia]\Tools\CMTrace.exe

Share This Post

My name is Steve Buchanan and I’ve been in Information Technology for 11 years. I have been attending the Minnesota System Center User Group meetings for about 6 months. I have been working with System Center products for the past 3 years specifically Microsoft Data Protection manager and System Center Essentials. I run a blog about Microsoft and Open Source technology at www.buchatech.com. I plan to share posts from my blog here that discuss System Center topics.

2 Comments

  1. Hi Steve,
    Same error here. I tried your solution but unfortunately, it didn’t correct my problem.
    In my lab, I use SQL Server 2012. Which version of SQL did you use?
    Thanks, cheers

  2. Hi Radolpe,

    I was on SQL 2008 in this instance. Try “Creating a SSL certificate and assign it to the SQL Network properties.” like in this post.

    http://www.configurationmanager2012.com/Configuration-Manager-02.html

Leave a Reply