SQL 2000 - Enterprise Manager Question

25 Sep 2006 12:08 AM

MG

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

25 Sep 2006 12:31 AM

Sue Hoegemeier

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

On Sun, 24 Sep 2006 17:08:01 -0700, MG
<M*@discussions.microsoft.com> wrote:

Show quote

>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