Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

One machine 2 Instances SQL Server - Set Default ? Expand / Collapse
Author
Message
Posted Thursday, October 01, 2009 9:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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 ,

Zee
GDIT - SS DBA
Atlanta, GA
Post #796402
Posted Thursday, October 01, 2009 9:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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 »

Add to briefcase

Permissions Expand / Collapse