Re: Default Service SQL Server 2000

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@xxxxxxxxxxxxxx> 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@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

  • Re: SQL 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... and I need to know how to use this thing to connect to the database remotely. ... I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)
  • Re: Time allowed for service shutdown
    ... > service can tell the SCM from ... > the SCM itself is only allowed to take WaitToKillServiceTimeout ... > I'm working on a database manager service which batches and delays index ... Windows ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Hard Drive wont stop spinning
    ... Security Accounts Manager ... SQL Server ... Symantec Lic NetConnect service ... Windows Firewall/Internet Connection Sharing ...
    (microsoft.public.windowsxp.perform_maintain)
  • Hard Drive wont stop spinning
    ... Security Accounts Manager ... SQL Server ... Symantec Lic NetConnect service ... Windows Firewall/Internet Connection Sharing ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Locking in SQL Server
    ... > But I think main problem is, this is his first proj on SQL server and MS ... >> If your manager understand locking, he/she will understand why it isn't possible. ... >>>> Say User A issues the following command: ... >>>> In this case User B goes into Deadlock situation. ...
    (microsoft.public.sqlserver.programming)