One machine 2 Instances SQL Server - Set Default ?

• ZeeAtl

  SSCommitted

  Points: 1569

  More actions

  October 1, 2009 at 9:04 am

  #156276

  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

• JamieX

  Hall of Fame

  Points: 3763

  More actions

  October 1, 2009 at 9:22 am

  #1060514

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