un-registering a server

[Steve Blair]

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

[Erland Sommarskog]

Steve Blair (sp***********@yahoo.ca) writes:

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?

It appears that these names appear under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo in
the Registry.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Steve Blair]

Hi,

Can you suggest how I can set the default server?

thank you

g
"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...

Steve Blair (sp***********@yahoo.ca) writes:

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?

It appears that these names appear under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo in
the Registry.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Erland Sommarskog]

Steve Blair (sp***********@yahoo.ca) writes:

Can you suggest how I can set the default server?

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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx