December 29, 2008 at 5:34 am
hi friends,
Can i have two or more instances of sql server running in my machine and access the same simultaneously. If yes how?
Please help...
thank you
December 29, 2008 at 6:03 am
Yes you can run multiple instances in SQL Server Express also in Standard or Enterprise editions!
You should install again the SQL Server and during installation you will installed named instance, simply you will give a name for second instance. The first one is default instance and as usually it has the machine name! You can connect with SSMS same like default instance but you should check the combo box and you will see the list of all installed instances!
The same is also with SQL Server other editions Standard or Enterprise!
December 29, 2008 at 6:03 am
Yes you can install more than one instance of SQL Server on a system.. Check maximum capacity specification on the limit of instances BOL... I guess its 50..
To access u write ServerName\InstanaceName to refer the instance.
December 29, 2008 at 6:05 am
ps (12/29/2008)
Yes you can install more than one instance of SQL Server on a system.. Check maximum capacity specification on the limit of instances BOL... I guess its 50..To access u write ServerName\InstanaceName to refer the instance.
Yea that's correct the max number of instances that you can install in one machine is 50 !
August 2, 2011 at 3:46 am
Can i have the same setup with developer eddition?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply