Skip to content

Setup Error During SQL Cert.

Featured Replies

Hallo everyone,

 

i try to setup the RC2.

The Prerequisite Check went OK, but if i click on begin install the setup breaks after 19 Seconds during:

 

Generating puplic key and SQL Server certificate

 

In the ConfigMgrSetup.log are 2 errors:

ERROR: Failed to get the buffer size for LookupAccountName. Error = 1722

ERROR: Failed to get SID for user (DOMAIN\sqladmin)

 

Can someone help me?

 

Best wishes

Johannes

  • Author

SQL: 2008 Ent with SP2 and CU7 (guess rc2 needs it). It was setup like in your rc1/sql tutorial. http://www.windows-noob.com/forums/index.php?/topic/486-how-can-i-install-sql-server-2008-in-windows-server-2008/

 

 

Art first i had the wrong Collation with:

setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword> SQLCOLLATION=<NewSystemCollation>

 

All went well with the collation change.

But sccm setup still not working

  • Author

Yes it is an VM. And SQL is installed from scotch with the right collation.

Maybe it base something todo with your multi domain Setup. I try to setup with user from the forest domain. The scam host is part of a subdomain.

I got it working for the beta 1,2 und the rc1. But rc2 still not works.

  • 2 months later...

Hey guys,

 

Did you ever resolve this one? Did you get it resolved by simply using an installer account from the forest the servers are sitting in? I've got a few variables I'm looking at including: SQL Server Service account is in a different forest (Trusted) and the Installer account is in another forest (Trusted).

 

My technical knowledge tells me this process should work regardless of the forests, but the certificate generation process is SQL is a little unknown/undocumented, so any experience on what you ended up doing would be great.

 

I've installed configmgr 2012 several times without any issues -but the company site I'm at now has lots of best practices around SQL and account management I'm working with. Before I tell them to start making accounts for this work in the Development forest, I'd love to know how you solved it.

 

Thanks!

  • 8 months later...

I fixed this problem using http://smsimpossible.blogspot.it/2012/04/sccm-2012-install-error.html "After much googling found this link from Yuri that suggests temporarily changing SQL to run under local system instead of the NT Service\MSSQLSERVER account. Worked great!"

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.