Simpleton question please

[Steve Blair]

Hi .

MSSQL Service Manager has a few servers available, how do I force a default
server to launch at startup?
Thank you

[Jens]

Hi Steve !

Don´t know what you really mean by that, but if you want to start that
automatically, just set the service to start automatically.

HTH, jens Suessmeyer.

[Steve Blair]

Hi Jens,

I know that there is an "Auto-Start " option but that does not launch the
server I need. It defaults to another server.

THX

<Je**@sqlserver2005.de> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Hi Steve !

Don´t know what you really mean by that, but if you want to start that
automatically, just set the service to start automatically.

HTH, jens Suessmeyer.

[Erland Sommarskog]

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

I know that there is an "Auto-Start " option but that does not launch the
server I need. It defaults to another server.

You mean that you want to the service manager to display status for a
certain server when it starts up?

There is a Default key in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\Service
Manager
You could try playing with that one.

By the way, the Service Manager is 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