August 26, 2004 at 9:18 am
In my shop we have several SQL Server DBAs and a large number of servers. We have registered all the servers, in EM, on one server and then the DBAs point to that server in EM, with the Tools, Options, Read From Remote option. That allows us all to have a common view of the servers.
Enough setup. The server with the shared registrations died. We have tried to set up the same thing on more than one other server but when we point there, we see the server grouping but it says "No Items" where the server names should display.
Microsoft has a worthless article about the problem at http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fbin%2Fkbsearch.asp%3FArticle%3D280836.
Has anyone else had this problem? Any solution other than MS's "workaround"? Thanks
August 26, 2004 at 10:01 am
I work with Ken and we have been able to narrow down the behavior, we just don't know why that makes a difference. We have been able to consistenly see the remote registration entries when the host server is a Windows NT server but have never been able to see the entries when the host server is a Windows 2000 server. This must have something to do with it but what that is we don't know.
August 26, 2004 at 10:38 am
Is the Windows 2000 box part of an active directory and your Windows NT box isn't?
Is the Windows 2000 box on a different network than the SQL Servers and the Windows NT on the same server as the SQL Servers?
-SQLBill
August 26, 2004 at 10:49 am
Unfortunately as DBA's we have little access and knowledge of what's going on behind the scenes with the domain so as to active directory, I'm not certain but I would venture to say that the Windows 2000 servers are part of an active directory and the NT boxes are not.
The servers can all communicate with one another and are in the same Class B subnet but the domains are all different. The NT servers that I can successfully see entries for are all in different domains from each other as well as from the Windows 2000 servers which are also in different domains from each other, so I wouldn't think that there is a pattern there.
Also, our workstations that we are trying to view the entries from are in different domains than the servers as well.
Is that what you're asking? Thanks for your help by the way.
-mack
September 8, 2004 at 5:47 am
did you install SQL Server SP3a ?
Alamir Mohamed
Alamir_mohamed@yahoo.com
September 8, 2004 at 6:58 am
Yes. The servers that do not show the remote registrations do have SP3a. Based on the Microsoft article that I mentioned above, this is apparently a known problem, MS just isn't going to fix it. Hopefully it will be fixed in Yukon.
Thanks
Ken
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply