By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,625 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,625 IT Pros & Developers. It's quick & easy.

un-registering a server

P: n/a
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
Dec 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Dec 12 '05 #2

P: n/a
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

Dec 13 '05 #3

P: n/a
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
Dec 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.