all groups > sql server (alternate) > december 2005 >
You're in the

sql server (alternate)

group:

un-registering a server


un-registering a server Steve Blair
12/12/2005 2:16:25 PM
sql server (alternate):
Please pardon my ignorance, but I am using MS SQL2000...On system start up
the Server Service Manager defaults to server "BACK" which is not even
registered in the SQL Enterprise Manager. Enterprise Manager shows only one
server " OFFICE" which is the one I want to default to. How do I remove the
"Back" server completly from the system?


thank you

Re: un-registering a server Erland Sommarskog
12/12/2005 9:07:51 PM
Steve Blair (sportman_6663@yahoo.ca) writes:
[quoted text, click to view]

It appears that these names appear under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo in
the Registry.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
Re: un-registering a server Steve Blair
12/13/2005 8:35:23 AM
Hi,

Can you suggest how I can set the default server?

thank you

g
[quoted text, click to view]

Re: un-registering a server Erland Sommarskog
12/13/2005 10:30:05 PM
Steve Blair (sportman_6663@yahoo.ca) writes:
[quoted text, click to view]

Actually, I have no idea how it does it. I guess that if you have
SQL Server on your machine, it will default to the default instance.
That is at least what mine seems to be doing.

Anyway, maybe you should start to learn not relying on the Service
Manger. To wit, it's gone in SQL 2005....


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
AddThis Social Bookmark Button