EM Issue - Missing servers in available servers list?

My PC was renamed and added to Active Directory in a new domain yesterday. Today when I tried to register a server in EM I only see SQL Servers in this new domain and not in the other, trusted, domains. I visited the machines of 5 developers and found that some people are experiencing the same issue while others can see SQL Servers in other domains, however they can only see SQL 2000 and not SQL 7 servers.

Any idea how the "Available Server" list is populate in EM and what might be causing this issue? It is important to note that even though I do not see server in the list, I can still register the servers without a problem.

Thanks, DaveThe entries are stored in the client registry, as you might have assumed:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers|||...well, that's one of the places :)

I found another one:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers|||Dave
I assume you are talking about the list of available servers in the register server wizard in Enterprise Manager? If so, then there is actually a security alert about this (lastest SQL Server cummulative patch).

Your client broadcasts out a message to all of your (sub)network, and says I"I am looking for SQL Servers". Anything listening on port 1433 or so will respond with "Hey, I am a SQL Server". The vulnerability is in the way the client accepts the response. If someone "fakes" a response from SQL Server, they can do something to you (I forget the details, but you can look it up on the SQL site under downloads). But that is the short of how the register server wizard works. That is also why I never use it. If I don't know about the server, I probably shouldn't be messing with it. Hope this helps.

rdjabarov has pointed out where you get the lists of servers already registered in SQL Server Enterprise Manager and where Query Analizer and Profiler get that drop-down list of servers to connect to. Basically just the last 20 servers you visited.|||well, my first posting shows the currently used location, and my second posting shows the location on my other workstation. Both locations are sources for EM, not Profiler or QA. The latter 2 truely are using the last 20 servers you connected to.|||Thanks for the info about the security issue. I'll read about it.

The only reason why I like to see the list of servers is to ensure nobody is trying to add an unauthorized SQL Server to our network. There are probably other ways to verify this, but I'm just use to using EM.

Dave

eliechucrallah@hotmail.com

i was trying to register a new server in enterprise manager i got the
following message : "the client and server codepages do not match. some
ansi character mappings may not be possible" but under sql server
properties,general tab i have the same code page, just different product
version because of the installed service pack. i've used other then the
default collation and i am using replication between these two server.
the application is working fine not sure if the replication will work
fine. maybe other other settings in the same page where i choose
collation during setup don't match how can i check these settings after
setup is done ? i am using sql 7
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
elie,
What service pack levels are you running on the client and the server?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> i was trying to register a new server in enterprise manager i got the
> following message : "the client and server codepages do not match. some
> ansi character mappings may not be possible" but under sql server
> properties,general tab i have the same code page, just different product
> version because of the installed service pack. i've used other then the
> default collation and i am using replication between these two server.
> the application is working fine not sure if the replication will work
> fine. maybe other other settings in the same page where i choose
> collation during setup don't match how can i check these settings after
> setup is done ? i am using sql 7
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||select @.@.version
gave me this
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
on 1 server and this
Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
on the other
and sp_helpsort gave me the same result on both servers
i just downloaded sql 7 sp4 should i install it ?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||elie,
You should install SP4 on both machines.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> select @.@.version
> gave me this
> Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
> Nov 27 1998 22:20:07
> Copyright (c) 1988-1998 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> on 1 server and this
> Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
> Mar 2 2000 06:49:37
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
> on the other
> and sp_helpsort gave me the same result on both servers
> i just downloaded sql 7 sp4 should i install it ?
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
>

eliechucrallah@hotmail.com

i was trying to register a new server in enterprise manager i got the
following message : "the client and server codepages do not match. some
ansi character mappings may not be possible" but under sql server
properties,general tab i have the same code page, just different product
version because of the installed service pack. i've used other then the
default collation and i am using replication between these two server.
the application is working fine not sure if the replication will work
fine. maybe other other settings in the same page where i choose
collation during setup don't match how can i check these settings after
setup is done ? i am using sql 7
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!elie,
What service pack levels are you running on the client and the server?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> i was trying to register a new server in enterprise manager i got the
> following message : "the client and server codepages do not match. some
> ansi character mappings may not be possible" but under sql server
> properties,general tab i have the same code page, just different product
> version because of the installed service pack. i've used other then the
> default collation and i am using replication between these two server.
> the application is working fine not sure if the replication will work
> fine. maybe other other settings in the same page where i choose
> collation during setup don't match how can i check these settings after
> setup is done ? i am using sql 7
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!