multiple instances in a single system

  • 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

  • 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!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • 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.



    Pradeep Singh

  • 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 !

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • 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