Problems with SCCM 2012 installation

[wessberg]

Windows 2008 r2

SQL Server 2008r2 SP1 Cu4 (local on the SCCM server).

 

I have followed all the steps in this guide http://www.windows-n...1-installation/

I have followed all of the steps, but get some errors when I try to install (see below).

 

 

<04-05-2012 17:15:31> sccm.local; SQL Server service running account; Error; The logon account for the SQL Server service cannot be a local user account or LOCAL SERVICE. You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.

<04-05-2012 17:15:39> ERROR: Site server does not have create child permission on AD 'System Management'

<04-05-2012 17:15:39> WARN: Site server does not have delete child permission on AD 'System Management'

<04-05-2012 17:15:41> sccm.local; Verify site server permissions to publish to Active Directory.; Warning; The site server might be unable to publish to Active Directory. The computer account for the site server must have Full Control permissions to the System Management container in its Active Directory domain. You can ignore this warning if you have manually verified these permissions. For more information about your options to configure required permissions, see http://go.microsoft..../?LinkId=233190.

<04-05-2012 17:17:43> ERROR: Failed to get SQL Server connection for sccm.local (master)

<04-05-2012 17:17:43> ERROR: Failed to connected to SQL Server, cannot verify required collation

<04-05-2012 17:17:43> sccm.local; Required SQL Server Collation; Error; Configuration Manager requires that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_AS collation, unless you are using a Chinese operating system and require GB18030 support. For information about changing your SQL Server instance and database collations, see http://go.microsoft..../?LinkID=234541. For information about enabling GB18030 support, see http://go.microsoft..../?LinkId=234542.

[Peter van der Woude]

The most errors seem pretty clear... What did you try to prevent them from happening?

[Nasir600]

Hi Wessberg,

You got couple of things going wrong in the installation.

1) Use a domain account for running sql service

2) Do not use the defualt collation, use SQL_Latin1_General_CP1_CI_AS

3) Double check the ADSIedit.msc configuration for the "system management". Clearly permissions are missing

 

 

Note: Quickest way to change the schema is to re-install sql server. I found it buggy to change schema after patching up to newer service level.

 

I hope this helps you.

 

Thanks

[Nasir600]

Hi Wessberg,

You got couple of things going wrong in the installation.

1) Use a domain account for running sql service

2) Do not use the defualt collation, use SQL_Latin1_General_CP1_CI_AS

3) Double check the ADSIedit.msc configuration for the "system management". Clearly permissions are missing

 

 

Note: Quickest way to change the schema is to re-install sql server. I found it buggy to change schema after patching up to newer service level.

 

I hope this helps you.

 

Thanks

[Nasir600]

Has the issuw been resolved?