Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL 2000 - Enterprise Manager Question

0 views
Skip to first unread message

MG

unread,
Sep 24, 2006, 8:08:01 PM9/24/06
to
I have two separate servers with SQL 2000 installed. Simple install and no
replication.

Server A is production and is running SQL Server 2000 Standard Edition
Server B is development and is running SQL Server 2000 Standard Edition

Both are on the same domain.

Here is what I have seen and am very curious to find out why I see it.

I go to Server A and have registered that instance of SQL - obviously it
shows that SQL in the EM view.

I go to Server B and it also shows the Server A instance of SQL - without me
registering it!!!

I then register Server B's instance of SQL to view it in EM and now there
are two - production and development which is what I expect.

I then go back to Server A and it is showing the production instance of
itself AND the one for Server B (Development)!!!. I went back to Server B,
deregistered the production SQL in the EM view that is on Server A. I then go
back to Server A and production SQL is also deregistered in the EM view!!!

My question is this. Why is SQL synchronizing EM between the two boxes? I
was expecting that EM is a standalone app on each box and what you register
on one box should have no relationship to what is registered on another box.

Any help would be appreciated.
MG

Sue Hoegemeier

unread,
Sep 24, 2006, 8:31:42 PM9/24/06
to
You could have Enterprise Manager set up to read
registrations from a shared file
In Enterprise Manager, go to the menu to Tools and then
select Options. On the General tab, look at the bottom
section and check the Server Registration Information.
The settings you are expecting from your description are
Read/Store Locally and Read/store user independent.

-Sue

0 new messages