Prereq issue and computer added to local adminisrator group
Scenario: SCCM Server with remote SQL DB When I run the precheck I continuously get the error that the SCCM computer accountis not part of the local administrators group on the SQL DB Server. However, it is a member of the group. I have rebooted, but still get the same error. "Configuration Manager Setup requires that site server computer possess administrative rights on the SQL Server and management point computers" Any ideas?
February 18th, 2008 12:13pm
The rule also fails if we are unable to check the condition, is it possible the user running setup is not an administrator on the SQL machine?
February 18th, 2008 1:37pm
I verified that the user and the SCCM computer account are both local administrators on the SQL server. i still get the prereq check error.. The only other thing I have not done is reboot the SQL server..I have already rebooted the SCCM server. I wouldn't think I need to reboot the SQL server computer just because an object was added to the local admin group..
February 18th, 2008 2:10pm
Can you connect to the admin$ from the site server? If you remotely connect the 'computer management' MMC to the SQL Server from the site server can you verify group membership?
February 18th, 2008 4:03pm
I was able to connect to the admin$ share and SQL server "Computer Management"from the site server using MMC fine. I'm wondering if there is some type of GPO security setting preventing the check to be successful.
February 18th, 2008 4:30pm
Did you also check the management point? Finally, there could be some authentication problems that are not obvious. Check the security and system event logs looking for DNS, Kerberos or other machine account registration issues, this is fairly common.
February 20th, 2008 12:22pm
How did you go with this? I have the same setup - SCCM on 1 server and SQL2005 on another. If you make the Computer account that hosts the SCCM (i.e. the one you are running the check from) a member of Administrators group in the Active Directory, this will give it rights in SQL 2005 because BULTIN\Administrators have SQL admin rights. This will get you around the prerequisite check but you will need to get the SQL Admin guys to set explicit permissions for you - it's a good idea to use a descriptive group from AD and use that group. Making the SCCM server a member of Administrators gives it access to all servers etc via BUILTIN
February 24th, 2008 9:18pm
I realize this is an old post but first hit when Googling so thought Id post another solution. If your SQL instance is clustered youll need to give SCCM Server full control over the cluster. James
April 30th, 2012 4:19pm