CRM 2011 - SQL 2008 Enterprise or Standard

All replies

• 

  

  1

  Sign in to vote

  Shouldn't matter, according to the implementation guide you can use either, but only 64 bit.

  SQL Server editions

  Any one of the following Microsoft SQL Server editions is required and must be installed on a Windows Server 2008 64-bit or later version, running, and available for Microsoft Dynamics CRM:

  • Microsoft SQL Server 2008, Standard Edition, x64 SP1 or later version
  • Microsoft SQL Server 2008, Enterprise Edition, x64 SP1 or later version
  • Microsoft SQL Server 2008 Datacenter x64 SP1 or later version
  • Microsoft SQL Server 2008 Developer x64 SP1 or later version (for non-production environments only)

  ---

  Jamie Miley
  http://mileyja.blogspot.com
  Linked-In Profile
  Follow Me on Twitter!

  • Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
  • Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM

  Thursday, March 31, 2011 3:25 PM

  Moderator
• 

  

  0

  Sign in to vote

  Thanks.  Not being a SQL guy, I am wondering what are the differences between standard and enterprise?

  ---

  Regards, Bill

  Thursday, March 31, 2011 3:33 PM
• 

  

  1

  Sign in to vote

  As far as I know, the only difference that has an effect in CRM is that CRM will partition the audit tables if it's installed on SQL Enterprise; this is for performance reasons, and this functionality is only available with SQL Enterprise

  ---

  Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
  

  • Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
  • Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM

  Thursday, March 31, 2011 6:24 PM

  Moderator
• 

  

  1

  Sign in to vote

  Here is a comparison,

  http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx

  The PDF at the bottom of the screen goes intomore depth also.

   

  ---

  Jamie Miley
  http://mileyja.blogspot.com
  Linked-In Profile
  Follow Me on Twitter!

  • Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
  • Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM

  Thursday, March 31, 2011 6:25 PM

  Moderator
• 

  

  0

  Sign in to vote

  Thanks David.  Are you referring to the case where CRM and SQL are installed on the same box?

  ---

  Regards, Bill

  Thursday, March 31, 2011 6:58 PM
• 

  

  1

  Sign in to vote

  Bill, it makes no difference if CRM and SQL are on the same box, or different ones

  ---

  Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
  

  • Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM

  Thursday, March 31, 2011 8:51 PM

  Moderator