locked
SQL Server Named Instances RRS feed

  • Question

  • Maximum how many Named instances of SQL SERVER 2008 possible in a single machine?

    Saturday, May 22, 2010 5:25 PM

Answers

  • It depends on edition of SQL Server

    http://msdn.microsoft.com/en-us/library/ms143432.aspx#3

    Per SQL 2008 Books Online

    50 instances on a stand-alone server  (25 instances on a failover cluster) for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

    P.S. There is a correction on the bottom only 16 instances in Standard Editon.

    • Proposed as answer by Olaf HelperMVP Sunday, May 23, 2010 5:47 AM
    • Marked as answer by LekssEditor Sunday, May 23, 2010 10:36 PM
    • Unmarked as answer by LekssEditor Sunday, May 23, 2010 10:38 PM
    • Marked as answer by LekssEditor Sunday, May 23, 2010 10:39 PM
    Saturday, May 22, 2010 5:42 PM

All replies

  • It depends on edition of SQL Server

    http://msdn.microsoft.com/en-us/library/ms143432.aspx#3

    Per SQL 2008 Books Online

    50 instances on a stand-alone server  (25 instances on a failover cluster) for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

    P.S. There is a correction on the bottom only 16 instances in Standard Editon.

    • Proposed as answer by Olaf HelperMVP Sunday, May 23, 2010 5:47 AM
    • Marked as answer by LekssEditor Sunday, May 23, 2010 10:36 PM
    • Unmarked as answer by LekssEditor Sunday, May 23, 2010 10:38 PM
    • Marked as answer by LekssEditor Sunday, May 23, 2010 10:39 PM
    Saturday, May 22, 2010 5:42 PM
  • Thank U.....
    DURAIMURUGAN V
    Sunday, May 23, 2010 6:49 AM
  • SQL Server 2005 Enterprise or Developer supports 50
    SQL Server 2005 Other Editions supports 16
    SQL Server 2008 Enterprise or Developer 50
    SQL Server 2008 Other Editions supports 16

    Thanks, Leks
    Sunday, May 23, 2010 10:39 PM
    Answerer