Strange error while installing ConfigMgr 2012

Hi guys, 
Wanted to share with you a strange error I received during the installation of the new Configuration Manager 2012 (RC Version).
While running a regular installation, the following step fails:

Opening the installation log file I’ve noticed an stranger error:
‘Failed to get SID for User ‘DOMAIN\User’
I was working on this with a friend of mine – Elad Hayun, which is by far better expert than me 🙂
We’ve tried solving this issue using various ways, but finally came up with a single solution.
We’ve change the service account that the SQL services are running with to the ‘Local System’ account and ran the setup again. This time it finished with no errors.
The reason the installation failed every time, is that during the installation process the account that the SQL is running with is used to issue a certificate from the local store (that is used by the SCCM to communicate with the SQL), but the account we were running with did not have sufficient rights to issue the certificate.
I saw many blogs about how to create a new Certificate Template on the central CA and to issue a certificate using this template, but in fact the SCCM uses a Self-Issued certificate.

Once the installation finnished, we change the service account back to the user the SQL was running with and rebooted the server – just to make sure 🙂

Good Luck!

18 Comments

  1. Amazing…. Solved the same exact problem for me. Really weird that this happens but hopefully it’ll be fixed in the final version. I think that encryption between the SQL server and the SCCM server needs to be optional, especially if they’re on the same machine!

  2. Guys you have no idea how much i am gratful for your solution it worked like a charm.

  3. You’re great! It solved my problem with SCCM 2012 with SQL2012 …..
    Thank you
    Michael

  4. Thanks so much, been have the same problem With SCCM 2012 with SQL Server 2012 on Windows 2008 R2.

  5. how can you can you change that can you please explain. step by step. thank you in advanced.

    • You can use the built-in Services Management Console (services.msc) to accomplish that.
      You can also use the tools that come with the SQL install – SQL configureation tools.

Leave a Reply to Nagaraj Cancel reply