Re: Default Service SQL Server 2000

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@xxxxxxxxxxxxx> wrote in message
news:4f9eh2dflgn65lb5le2iucit259agh3qt8@xxxxxxxxxx
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@xxxxxxxxxxxxxx> 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?




.

Relevant Pages

  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • RE: Upgrading to SQL 2005 ENT
    ... I left the reporting services off. ... It gives a good step by step how to on upgrading to SQL Server 2005. ... some SQL Server features will not be available for installation. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • RE: Upgrading to SQL 2005 ENT
    ... Microsoft SQL Server 2005 9.00.1399.06 ... some SQL Server features will not be available for installation. ... not the sql server management studio or enterprise manager. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • RE: Upgrading to SQL 2005 ENT
    ... Microsoft SQL Server 2005 9.00.1399.06 ... some SQL Server features will not be available for installation. ... not the sql server management studio or enterprise manager. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
Loading