Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

When I start SQL Server 2008 R2, I connect to the database server of (local). I want to create another database server at (local)/mypath.

However, I don't see where this can be done. Can I run multiple database servers on one machine?

share|improve this question

migrated from stackoverflow.com Mar 8 '11 at 17:15

This question came from our site for professional and enthusiast programmers.

There is an option in the installer to modify the installation - Add Instance. It's more of a serverfault.com or superuser.com question, though... –  Jaroslav Jandek Mar 8 '11 at 17:10
Sounds like you want to create a new instance, not a new database; Either way, it's not a programming question, and may be better answered on a sister site such as serverfault.com or dba.stackexchange.com –  Rowland Shaw Mar 8 '11 at 17:11
If all you are trying to do is create a new database, each instance can hold several databases (up to several thousand per instance). –  mrdenny Mar 8 '11 at 20:37

1 Answer 1

you have to run the installer again and install a named instance

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.