Is is possible to run multiple instances (installations) of SQL Server databases on the same machine (assuming the machine is not virtualized)
+3
A:
Yes, you can give the installations different names. I think you have to choose "advanced options" on installation to be able to set the name.
Jon
2010-04-23 17:48:06
You can also have multiple instances of the same version of SQL server, each with a different service pack. There can only exist a single unnamed instance, all the other instances have to be named.
Chris Bednarski
2010-04-24 05:09:22
+1
A:
Yes, you can run multiple databases in a single instance of SQL Server on the same machine.
Robert Harvey
2010-04-23 17:48:24
A:
yep, they need to be named instances though. Run the setup but when you get to the instance name - add a new name for the instance.
Mauro
2010-04-23 17:48:59