SCCM Setup Check Fails - Steve Gould

I trying to setup a new sccm with remote SQL.  I having the error of "Site
server computer account administrative rights".

The ConfigMgrPrereq.log shows:
Checking Access Permissions.....
Rule Name: SQL Server sysadmin rights
Result: Passed
Rule Name Site server computer account administrattive rights
Result: Error
Configuration manager Setup requires that site server computer possess
administrative rights on SQL server and management point computers. The
machine account doesn't have admin rights to the SQL server
The site server computer's machine account does not have administrator
privileges....


I have added the site server machine account to the SQL server's local
administors group. I added the site server to SQL server and even gave it
the sysadmin role. Everything appears to be correct. The account I am
installing SCCM with has admin rights on the SQL server.



Suggestions anyone?

SCCM Setup Check Fails - Steve Thompson

Have you rebooted the server running SQL Server, since you added the site
server computer account to local admins?

Steve

SCCM Setup Check Fails - Steve Gould

I wish it were that easy. Yes, both the sccm site server and SQL server have
been rebooted. I have read others post the same issue, but have not seen any
fixes.

SCCM Setup Check Fails - Steve Thompson

Does SQL Server have the default security set? IOW, does the local
administrators group have sysadmin permissions on SQL Server?

SCCM Setup Check Fails - Steve Gould

Yes, the local administrators group has sysadmin permissions.

Resolved - Steve Gould

I got so frustrated with this project that I went back to basics. I am
working with existing servers in a test forest. I found issues with DNS,
WINS, and lots of IP settings on the servers. After correcting the issues I
am now able to run the checks. I think it was DNS related.

Steve

Resolution Part 2 - Steve Gould

My previous discovery didn't make enough difference. I was still unable to
install because the SMS Provider would fail.





My external SQL server runs under a domain service account. SPN's must be
set. The online references say to use the following:



setspn -A MSSQLSvc/<SQL Server computer name>:1433 <Domain\Account>.



setspn -A MSSQLSvc/<SQL Server computer name.domainname>:1433





These were incorrect. "MSSQLSvc" needs to be your actual SQL Server service
name. In my case "MSSQLSERVER". As soon as I altered the SPN's (using
ADSIEdit) I was able to complete the installation on the first server.