One machine 2 Instances SQL Server - Set Default ?

  • I have two instances of SQL Server [2005] on my box. The second one was created post-Install of MSSQL, when I installed SharePoint MOSS 2007.

    <MachineName>\VM_DC\VM_DC_SQLSERVER

    <MachineName>\VM_DC\OFFICESERVERS

    By default the MSSQL installed instance VM_DC_SQLSERVER is the startup

    instance.

    I'd like to make OFFICESERVERS the one and only instance started when my

    SQL Server service starts up (at OS restart).

    How do I do?

    Thanks 😛 ,

    Zee

    GDIT - SS DBA

    Atlanta, GA

  • set the service start mode to manual or disabled under sql server configuration manager.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply