SQL Server Named Instances

All replies

• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  Thank U.....

  ---

  DURAIMURUGAN V

  Sunday, May 23, 2010 6:49 AM
• 

  

  0

  Sign in to vote

  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