SCCM Computer Account and permissions to SQL Server
I am trying to install SCCM 2007 SP1 on a Windows 2008 server and connect to a non-clustered Windows 2003 box running SQL 2005. Here is a rundown of the systems and what has happened thus far: SCCM box (site server and management point) - Server 2008 SQL box - Server 2003, SQL 2005Both boxes are on same domain, SCCM box shows up as a computer account in ADUC Open the Local Users and Group on the SQL server box - add SCCM computer name in the Administrators groupPrereq checker runs and says all is okay Start to install and get following error: The site server computer's machine account does not have Administrator's privileges on the SQL Server selected for site database installation. To install a Configuration Manager site, all servers must be in an Active Directory domain and the site server's machine account must have Administrator's privileges on the SQL Server. Any ideas as to what could cause this? Like I said, computer account is already listed in the local admin group. Is there anything in the SQL Server software itself that needs permissions setup? Thanks. P
November 18th, 2008 6:05pm

Hi, Make sure to usea domain account for the setup but also make sure the domain account is a member of the local administrators group on the site server and SQL Server.
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2008 1:21am

Jannes, Thanks for the reply. The domain accountI am using is a member of a group which is included in the local admins group on both boxes. In the SQL server management studio, IfI look under Security | Logins, I see BuiltIn\Administrators. If I view its roles, it has sysadmin checked. ("Public" is the only other role that is checked.) Thanks. P
November 19th, 2008 5:11pm

In testing with another SQL box, I was able to add the account name to the local admins group and the installation got past the problem point. So, there is something quirky on the SQL first server. Any ideas what might cause the SQL server to not grant the computer account admins privileges? Account in local admin group Local admin group listed in SQL server under Roles | SysAdmin Thanks. P
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2008 10:59pm

It could be a SPN (http://technet.microsoft.com/en-us/library/bb735885.aspx) or Kerberos issue.
November 19th, 2008 11:20pm

Torsten,That was it. There was a conflict with the SPN. Thanks for your help. P
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2008 4:51pm

If after adding SCCM Site server to local administrators group on SQL Server and configuring SPN service account - you stil have error message "The site server computer's machine account does not have Administrator's Privileges......." - try disable UAC (User Account Control) on SQL Server.
June 28th, 2011 8:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics