Tuesday, March 27, 2012

Creating Additional Instances

How do I create additional instances of any MSSQL 2005 service(specifically database and analysis) given that a default instance is present?

You just need to run setup.exe again but this time do not install it as the default instance. In stead, you install it as a named instance. Under UI, you need to choose a different instance name. If you use a command line, the parameter INSTANCENAME=<NEW INSTANCE NAME> should be use.

|||

During the instance selection screen of the install, you can also click on the button to show currently installed instances to make sure that you don't pick the same instance name again.

Thanks,
Sam Lester (MSFT)

No comments:

Post a Comment