web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Supported SQL versions for CRM 2016 (On Prem)

(0) ShareShare
ReportReport
Posted on by 350

Can anyone verify that the SQL server editions in software requerements is a minimum?

https://technet.microsoft.com/en-us/library/hh699671.aspx

Microsoft SQL Server 2012, Standard, 64-bit SP2 and SP3 has to be supported right?

We ave Standard 2012 SP2  now, should we update to SP3 latest patch?

SQL Server editions

Any one of the following Microsoft SQL Server editions is required and must be installed on Windows Server 2008 (SP2 or R2) 64-bit-based versions or Windows Server 2012 (RTM or R2) 64-bit-based computers, running, and available for Microsoft Dynamics CRM:

  • Microsoft SQL Server 2014, Enterprise, 64-bit

  • Microsoft SQL Server 2014, Business Intelligence 64-bit

  • Microsoft SQL Server 2014, Standard, 64-bitt

  • Microsoft SQL Server 2014, Developer, 64-bit (for non-production use only)

  • Microsoft SQL Server 2012, Enterprise, 64-bit SP1

  • Microsoft SQL Server 2012, Business Intelligence, 64-bit SP1

  • Microsoft SQL Server 2012, Standard, 64-bit SP1

  • Microsoft SQL Server 2012, Developer, 64-bit SP1 (for non-production use only)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Pratibha Singh Profile Picture
    on at

    Hi Tommy,

    I have just migrated to CRM 2016 (On premise) and I can verify that these are the minimum sql server requirements for Microsoft Dynamics CRM 2016.

    Also, you Standard 2012 SP2 will work fine and you don't have to update to SP3 patch.

    Thanks

    Pratibha

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans