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 2000 Forums
 SQL Server Administration (2000)
 Paranoid? - Extra Entries in the Service Manager

Author  Topic 

OwnedByTheMan
Starting Member

35 Posts

Posted - 2002-12-06 : 13:49:34
I don't know if I'm being paranoid but when I dropped down the list to select the server I wanted to start, there were 8 additional entries for servers not located on my machine nor do I recognize them at all. Is it possible that these are other SQL server users on my network (via Rogers cable modem) of should I be worried?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2002-12-06 : 15:08:23
That is very peculiar. The service manager should only detect the SQL Server installations on your machine.

I would suggest checking MS' knowledge base to see if this is a bug.


Go to Top of Page

OwnedByTheMan
Starting Member

35 Posts

Posted - 2002-12-06 : 15:24:25
A couple of other things I have noted. The list of extra servers is not always the same, sometimes servers shown when starting service manager one time are no longer shown when the manager is started another time. Also, if I go to EM and try to register another server, the same list of servers is present when using the wizard. I will investigate further.

Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2002-12-06 : 16:07:31
The service manager should show all SQL instances that are currently on your network and broadcasting. My service manager shows all SQL servers (including multi-instance SQL 2000) on our primary domain and a development domain. You're probably picking up PCs that have MSDE or SQL installed and are broadcasting on your network.

-- monkeybite

Go to Top of Page

OwnedByTheMan
Starting Member

35 Posts

Posted - 2002-12-06 : 16:13:19
That is what I was beginning to think. It falls inline with my observations of the available list changing in size and names of entries. Also, a few of them are of the "CR11etc.." hostnames I associate with cable networks.

I just get paranoid when I see things on my machine that I didn't put there :)

Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2002-12-06 : 16:21:16
Make sure you've turned off broadcasting. Your machine may be showing up in their service managers as well. You can do this in the server network utility. Also, if you don't have a firewall protecting your machine, you may be inviting attack...

-- monkey

Go to Top of Page

OwnedByTheMan
Starting Member

35 Posts

Posted - 2002-12-06 : 17:04:54
Is that the Hide Server checkbox under TCP/IP properties? I can't find anything else that might refer to that.

Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2002-12-06 : 18:04:23
quote:
Is that the Hide Server checkbox under TCP/IP properties?


Bingo! That's it!

-- monkey

Go to Top of Page
   

- Advertisement -