Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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 or 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 or – 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

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.