How do I change the default Service in SQL Server Service manager?

I have SQL Server 2000 and SQL Server 2005 loaded on my computer. The
Service for "my computer name" loads at startup and is disabled. How do I
change the default service to the SQL database on the server?

It's stored in the Default value registry key in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\80\Tools\Service Manager
I know you can changed this to a local named instance -
haven't ever tried a network server or instance.

-Sue

On Wed, 20 Sep 2006 13:42:51 -0700, "R Weeden"
<rweeden@wesd.k12.az.us> wrote:

>How do I change the default Service in SQL Server Service manager?
>
>I have SQL Server 2000 and SQL Server 2005 loaded on my computer. The
>Service for "my computer name" loads at startup and is disabled. How do I
>change the default service to the SQL database on the server?
>

I tried this and it still comes up to "my computer name" which is
\\2006-5316 instead of the \\FS-ADM that I reset this value to.

Is there any way to set this in Enterprise manager or through Query Analyzer
in SQL Server 2000?


"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:4f9eh2dflgn65lb5le2iucit259agh3qt8@4ax.com...
> It's stored in the Default value registry key in:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\80\Tools\Service Manager
> I know you can changed this to a local named instance -
> haven't ever tried a network server or instance.
>
> -Sue
>
> On Wed, 20 Sep 2006 13:42:51 -0700, "R Weeden"
> <rweeden@wesd.k12.az.us> wrote:
>
>>How do I change the default Service in SQL Server Service manager?
>>
>>I have SQL Server 2000 and SQL Server 2005 loaded on my computer. The
>>Service for "my computer name" loads at startup and is disabled. How do I
>>change the default service to the SQL database on the server?
>>
>

No...Enterprise Manager and Query Analyzer don't control SCM
settings. The registry is where those settings are stored.
The only other option would be to write you won SCM type of
utility. It's not too terribly hard. Just use SQLDMO. It
would probably be easier to just set SCM to whatever server
you want manually and then don't log off your computer. Just
lock it.

-Sue

On Thu, 28 Sep 2006 10:44:58 -0700, "R Weeden"
<rweeden@wesd.k12.az.us> wrote:

>I tried this and it still comes up to "my computer name" which is
>\\2006-5316 instead of the \\FS-ADM that I reset this value to.
>
>Is there any way to set this in Enterprise manager or through Query Analyzer
>in SQL Server 2000?
>
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:4f9eh2dflgn65lb5le2iucit259agh3qt8@4ax.com.. .
>> It's stored in the Default value registry key in:
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
>> Server\80\Tools\Service Manager
>> I know you can changed this to a local named instance -
>> haven't ever tried a network server or instance.
>>
>> -Sue
>>
>> On Wed, 20 Sep 2006 13:42:51 -0700, "R Weeden"
>> <rweeden@wesd.k12.az.us> wrote:
>>
>>>How do I change the default Service in SQL Server Service manager?
>>>
>>>I have SQL Server 2000 and SQL Server 2005 loaded on my computer. The
>>>Service for "my computer name" loads at startup and is disabled. How do I
>>>change the default service to the SQL database on the server?
>>>
>>
>