up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
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
feedback

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

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

1 Answer

up vote 7 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard