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.
| 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. |
 |
|
|
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. |
 |
|
|
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 |
 |
|
|
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 :) |
 |
|
|
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 |
 |
|
|
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. |
 |
|
|
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 |
 |
|
|
|
|
|