January 31, 2012 at 7:50 am
So I see that in my wonderful 70-432 Training Kit it says that Standard, Workgroup, Web, and Express editions can support 16 instances. However, it later says in a question and answer that the only edition that can support installing more than 1 instance of SQL Server on a machine is Enterprise... Can someone clear this up for me?
Jared
CE - Microsoft
January 31, 2012 at 8:14 am
All editions other than Enterprise Edition supports up to 16 instances and Ent Edition supports upto 50 instances. This is on a stand alone Server, on a failover cluster Ent Edition supports 25 instances..
You might want to look at this link for more info..
http://technet.microsoft.com/en-us/library/cc645993(SQL.100).aspx
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 31, 2012 at 8:15 am
All editions support named instances therefore you can have more than one and even mixed editions in your server. I've seen Standard and Enterprise edition named instances sitting pretty on the same server.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 31, 2012 at 8:21 am
So basically... The question on page 21 (for anyone using the book) which reads "Which edition of SQL Server supports installing more than one instance of SQL Server on a machine?" and is answered by "Only SQL Server Enterprise supports multiple instances on the same machine." is incorrect.
Jared
CE - Microsoft
January 31, 2012 at 8:22 am
SQLKnowItAll (1/31/2012)
So basically... The question on page 21 (for anyone using the book) which reads "Which edition of SQL Server supports installing more than one instance of SQL Server on a machine?" and is answered by "Only SQL Server Enterprise supports multiple instances on the same machine." is incorrect.
Yes..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply