I have just started to use Central management Services. I've registered a central server, created a Serer Group off that, and then registered several servers under that.
If I select * from sysmanagement_shared_server_groups, i get 5 entries for each server (Engine, Analysis, Reporting, Intergration etc), but If I try to run Select * from sysmanagement_shared_registered_servers_internal, to get a list of my registered servers, I get nothing returned.
I have full sysadmin rights on every server as I am a dba, However I have been reading about 2 specific roles for msdb that lets you query the central management servers. I would presume my admin rights give me all permissions of all roles including ServerGroupAdministratorRole, ServerGroupReaderRole However If i dont , How would i go about granting sysadmins rights, and on what werver would I need to add the rights to msdb, the initial one I set up, or on all the registered servers?
I just dont understand how I cant see the list of registered servers when i run SELECT * FROM msdb.dbo.sysmanagement_shared_registered_servers_internal
any Help would be appreciated.