none
How many Sql Instances can be installed. RRS feed

  • Question

  • Hi All,

    Please let me know how many instances of sql can be installed on below version?

    Sql 2000 [Cluster and Non CLustered]

    Sql 2005 [Cluster and Non CLustered]

    Sql 2008 [Cluster and Non CLustered]

    Sql 2012 [Cluster and Non CLustered]

    Thanks,

    Nani.

    Wednesday, February 27, 2013 6:24 PM

Answers

  • Hello,

    SQL Server 2000 can have 16 standalone instances and 16 clustered instances.

    SQL Server 2005 can have 50 standalone instances and 25 clustered instances. Workgroup Edition supports a maximum of 16 instances.

    SQL Server 2008 can have 50 standalone instances and 25 clustered instances.

    SQL Server 2008 R2 can have 50 standalone instances and 25 clustered instances.

    SQL Server 2012 can have 50 standalone instances and 25 clustered instances.


    Hope this helps.

     Regards,

     Alberto Morillo
    SQLCoffee.com

    Thursday, February 28, 2013 3:20 AM
    Moderator

All replies

  • It depends on SQL Server edition, please refer the following MSDN article for limits on SQL Instances: http://msdn.microsoft.com/en-us/library/ms143432.aspx

    Hope this helps! 


    Thanks, Sohail ~Please mark answered if your question is completely answered; vote it as helpful to help others find a solution quicker. This posting is provided AS IS with no warranties.

    Wednesday, February 27, 2013 6:41 PM
  • Hello,

    SQL Server 2000 can have 16 standalone instances and 16 clustered instances.

    SQL Server 2005 can have 50 standalone instances and 25 clustered instances. Workgroup Edition supports a maximum of 16 instances.

    SQL Server 2008 can have 50 standalone instances and 25 clustered instances.

    SQL Server 2008 R2 can have 50 standalone instances and 25 clustered instances.

    SQL Server 2012 can have 50 standalone instances and 25 clustered instances.


    Hope this helps.

     Regards,

     Alberto Morillo
    SQLCoffee.com

    Thursday, February 28, 2013 3:20 AM
    Moderator