Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
groston
Yak Posting Veteran
61 Posts |
 Posted - 2006-03-04 : 11:50:17
|
| To properly simulate my production environment, I need to run multiple instances of SQL Server 2005 (Express) on my development machine. Doing so regularly is not desireable as it tends to tax my machine.Question: Can I install multiple instances of SQL Server, but only have the default instance run (by default) but be able to have the other instances run when needed? If so, how do I do this?Thank you. |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-03-04 : 11:53:25
|
| You can use SQL Server Configuration Manager to Stop SQL services for the instances that are not required. |
 |
|
|
groston
Yak Posting Veteran
61 Posts |
Posted - 2006-03-04 : 12:01:34
|
| cshah1,Thanks. Your suggestion seems to imply that each time the computer is booted that the SQL Services for the other instances will have to be stopped. Is it possible to configure the system such that they are stopped by defualt and only started when needed? |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-03-04 : 13:01:09
|
| In the configuration manager right click on the appropriate SQL server instance services (properties), go to service tab and change the start mode from "Automatic" to "manual" .Keep your default sql server services start mode "Automatic" |
|
|
|
groston
Yak Posting Veteran
61 Posts |
Posted - 2006-03-04 : 13:14:02
|
| Excellent! Thank you. |
|
|
|
|
|
|
Enabling instances only when needed