“Configuration Manager Setup requires that the site server computer has administrative rights on the SQL Server and management point computers” in SCCM 2012

During the prerequisites check of SCCM 2012, you may encounter the error:
Configuration Manager Setup requires that the site server computer has administrative rights on the SQL Server and management point computers.

The prerequisite “Site server computer account administrative rights” equals the status “Failed”.

image

This message typically occurs when you’re setting up a new SCCM environment with a new remote SQL Database server.
In most cases, you can solve this error by adding the SCCM server name to the Local Administrators Server.
(To add a computer to the Administrators group, don’t forget to tick the Computers checkbox under Object Types , since you won’t find your server if you don’t :-) ).

image

When running SQL in a cluster, make sure to add the SCCM server to all cluster members.
If you’re installing SCCM 2012 with an account that’s not a member of the Domain Admins, make sure to add that user account as well to the Local Administrators group of the SQL Server.

Leave a Reply

14 Comments on "“Configuration Manager Setup requires that the site server computer has administrative rights on the SQL Server and management point computers” in SCCM 2012"

Notify of
avatar
Sort by:   newest | oldest | most voted
Anonymous
Guest

Thanks a lot

Charlie
Guest

Thanks, you’re the man!

brad
Guest

worked like a F*ing charm. Thank you so much

outsource financial
Guest

The online solutions are better marketing outsourcing
in the sense that you can have on an anti spam appliance tools, articles, tips, anti-spam software, available at an unbeatable price!

As always, whether your anti spam program has the ability to filter email based on the keywords used in the mails.

One of its features is allowing you to use the net, you will discover the concept of
spamming. Well, you have the starter package, which is great for those of you using the computer at home.

jo
Guest

ditto. thank you sir.

Anonymous
Guest

Why is it required to make the SCCM server a local admin of the remote SQL Server? What purpose does it serve?

Avadesh
Guest

Sometimes while doing big things we end up missing crucial parts..Certainly people like u have great Eye to point us through to Solution!!! thanx a ton

NOob
Guest

Was sitting many frustrating hours trying to find the solution. I did see a similar post to this went around and added users to administrator all over the place, also added computer to Administrators. Nothing worked what so ever. Then found out that the SCCM computer needed to be added, as it says in this post on the LOCAL Administrators. I’ve added the computers to the Administrators on the AD server -.-

Thanks for help :)

Pim van de Vis
Guest

Hi Christian, I would never have guessed that I would contact you through your blog. But I had the above issue and your site gave the first Google hit :)
See you soon.

FMK
Guest

Thank you

Anonymous
Guest

Me too! Thank you.

Anonymous
Guest

This was very helpful!! It resolved my issue. I’m fairly new to installing MS Server products. Your guide was pretty straight forward once I figured out the terminology. Right on target and the pre-requisite check passed. Thank you.

Anonymous
Guest

Thank you.. Super simple solution but I just couldn’t work it out.

Padawan
Guest

Thanks for this usefull solution !!!!

wpDiscuz