One machine 2 Instances SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » One machine 2 Instances SQL Server - Set...

One machine 2 Instances SQL Server - Set Default ?

Rate Topic

Display Mode

Topic Options

Author

Message

ZeeAtl

Posted Thursday, October 01, 2009 9:04 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, June 23, 2012 9:48 AM
Points: 59, Visits: 259

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 Tongue

,

Zee
GDIT - SS DBA
Atlanta, GA

Post #796402

JamieX

Posted Thursday, October 01, 2009 9:22 AM

Old Hand

Group: General Forum Members
Last Login: Friday, October 15, 2010 8:23 AM
Points: 371, Visits: 437

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

Post #796418

« Prev Topic | Next Topic »

Permissions