Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 central management server

Author  Topic 

cottage125
Starting Member

32 Posts

Posted - 2009-04-03 : 14:54:52
hi i have a strange thing on sql 2008 cms

on my machine i have default instance of sql 2008
and i have one named instance of sql2005(sp3) and one named instance of sql2000(RTM)
When i use cms and register central management server as my sql2008 server
then i created a group named sql and
under sql group i have successfully registered sql2005 and sql2000 servers.
now when i right click on my group SQL and select evaluate policy then it will evaluate policy
on both sql2000 and sql2005 servers.
BUT
when i right click on my group SQL and select new query then it wont connect to sql2000 server why??

I can see my group is registred in msdb..sysmanagement_shared_server_groups_internal table
and both servers registerd under msdb..sysmanagement_shared_registered_servers_internal table.

I have all 3 servers running under same domain account and i m admin of the box.. any hints??
Thanks

   

- Advertisement -