Bootstrap operation failed: Failed to create machine self-signed certificate for site role [SMS_SQL_SERVER]. RRS feed

  • Question

  • The title says all...

    I've got a SQL 2008 R2 running on a Server 2008 R2. On this SQL Server are 2 SQL instances, one for the CAS, and one instance for a primary Site. There are no errors in Site Status and Component Status, everthing is working as expected.
    But: Every 30 Minutes, it creates two folders on the drive which got most free disk space. In both Folders, it contains the same content:
    srvboot.exe, srvboot.ini and srvboot.log

    Here the content of srvboot.log:
    ******************************************************************************** SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    SMS_SERVER_BOOTSTRAP_CASServerName.domainname.TLD_SMS_SQL_SERVER started. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Microsoft System Center 2012 Configuration Manager v5.00 (Build 7711) SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Copyright (C) 2011 Microsoft Corp. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Command line: "SMS_SERVER_BOOTSTRAP_CASServerName.domainname.TLD_SMS_SQL_SERVER S03 D:\SMS_CASServerName.domainname.TLD_SMS_SQL_SERVER11 /createcertificate SOFTWARE\MicrosoftCertBootStrap\ SMS_SQL_SERVER". SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Set current directory to D:\SMS_CASServerName.domainname.TLD_SMS_SQL_SERVER11. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Site server: CASServerName.domainname.TLD_SMS_SQL_SERVER. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Creating machine self-signed certificate for site role [SMS_SQL_SERVER] on Server [CTRVSC007]... SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Failed to retrieve SQL Server service account. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Failed to grant permission to certificate. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Bootstrap operation failed: Failed to create machine self-signed certificate for site role [SMS_SQL_SERVER]. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    Disconnecting from Site Server. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    SMS_SERVER_BOOTSTRAP_CASServerName.domainname.TLD_SMS_SQL_SERVER stopped. SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)
    ******************************************************************************** SMS_BOOTSTRAP 13.09.2012 13:25:25 11 (0x000B)

    In the logfile, I changed the original servername and Domainname to CASServerName.domainname.TLD (search/replaced).

    Obviously only the CAS Server is generating this Folder, or tries to create the certificate. There are no hint, that the primary Server is doing the same. I searched a lot, and the only thing, that I didn't tried is to call Microsoft, as this customer was doing:

    As you can imaging, I checked SPN, local Admin rights, System rights on DB, i think just everthing what is mentioned to check. But I still looking for a solution. If someone could point me in the correct direction to search, I would be very happy :)

    Otherwise I will make a call too

    Thursday, September 13, 2012 1:28 PM


  • I just moved the Database to another SQL Server, the error isn't appearing anymore. Now i've got two SQL Servers.
    Wednesday, January 9, 2013 11:56 AM