“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.

0 0 votes
Article Rating
Subscribe
Notify of
guest
17 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Padawan

Thanks for this usefull solution !!!!

Anonymous

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

Anonymous

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

Me too! Thank you.

Pim van de Vis

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

Thank you

NOob

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 🙂

Avadesh

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

Anonymous

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

jo

ditto. thank you sir.

outsource financial

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.

brad

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

Charlie

Thanks, you’re the man!

Anonymous

Thanks a lot

itguy

thank you!

Alex

thank you!!

17
0
Would love your thoughts, please comment.x
()
x