question

khemmerl avatar image
khemmerl asked

How to allow access to list of registered servers in CMS

I have a Central Management Server on which I have registered all my development, test and production SQL servers. When the other DBA in my office uses Remote Desktop to connect to my CMS server and run SQL Server Management Studio, he does not see any of the registered servers. I have confirmed that both our AD accounts are in the sysadmin server role which I understood gave access to everything. Can anyone explain how I allow my teammate access to the list of registered servers? Thanks Ken
sql-server-2008cms
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Tim avatar image
Tim answered
In his SSMS window under registered servers they need to add the Central Management Server to the list. They should then be able to see all the registered servers with CMS.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Tim, you were right. I had my partner in crime right-click on "Central Management Servers", select "Register a Central Management Server" and select the CMS named instance. Once complete, all the groups and server were visible from his account. Thanks again, I appreciate the help. Ken
0 Likes 0 ·
Awesome, glad I could help. Since this answered you question, could you kindly click the check next to my answer to mark it as answering your question. That will let others know you have gotten the necessary response.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.