Posted by Steve Blair on 06/28/23 11:34

Hi,

Can you suggest how I can set the default server?

thank you

g
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns972AE121A66E4Yazorman@127.0.0.1...
> Steve Blair (sportman_6663@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, 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
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: trigger simple question
• Prev in forum: Re: query plan in clear text
• Thread view: Re: un-registering a server

[Reply to this message]