SCCM Setup Check Fails - Steve Gould

13-Feb-08 02:36:01
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?
reply
 
 

SCCM Setup Check Fails - Steve Thompson

13-Feb-08 03:12:18
Have you rebooted the server running SQL Server, since you added the site
server computer account to local admins?

Steve
reply
 

SCCM Setup Check Fails - Steve Gould

13-Feb-08 03:50:18
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.
reply
 

SCCM Setup Check Fails - Steve Thompson

14-Feb-08 07:45:27
Does SQL Server have the default security set? IOW, does the local
administrators group have sysadmin permissions on SQL Server?
reply
 

SCCM Setup Check Fails - Steve Gould

14-Feb-08 11:30:30
Yes, the local administrators group has sysadmin permissions.
reply
 

Resolved - Steve Gould

14-Feb-08 12:48:34
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
reply
 

Resolution Part 2 - Steve Gould

14-Feb-08 06:06:27
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.
reply
 
SCCM setup using External SQL and non-standard port
promotion
Silverlight    WPF    WCF    WWF    LINQ   
JavaScript    AJAX    ASP.NET    XAML   
C#    VB.NET    VB 6.0    GDI+    IIS    XML   
.NET Generics    Anonymous Methods    Delegate   
Visual Studio .NET    Expression Blend    Virus   
Windows Vista    Windows XP    Windows Update   
Windows 2003 Server    Windows 2008 Server   
SQL Server    Microsoft Excel    Microsoft Word   
SharePoint    BizTalk    Virtual Earth   
.NET Compact Framework    Web Service   

"Everything" RSS / ATOM Feed Parser
How to send and receive messages through message queuing in .Net
How to Read text file as database
SQL Server 2005 Paging Performance Tip
Display code of web page.
Fully Scalable Excel File Importer class for .net using Microsoft Jet driver
Generic Chart Color Manager class that can be used for any charts
Helper class to style the infragistics wingrid
Using Reflection to detemine as Assembly Info in and out.
Helper class to play with Window (Owners and position)
Resolving displayname from the culture using the XmlLanguage and LanguageSpecificStringDictionary class