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?

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy