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?
>