This document lists the Microsoft SQL Server 2014 features supported with Microsoft Dynamics GP 2013 R2 and later versions.
Microsoft SQL Server 2014 Feature Supportability
Data Alerts require SQL Server Reporting Services to be deployed in SharePoint Mode
Click HERE for more information regarding Data Alerts in Microsoft SQL Server 2012.
No additional features will be added to Microsoft Dynamics GP to take advantage of the FileTable functionality.
Click HERE for more information regarding Distributed Replay in Microsoft SQL Server 2012.
No additional features will be added to Microsoft Dynamics GP to take advantage of the Columnstore Indexes functionality.
Supportability under investigation
Microsoft Dynamics GP is dependent on consistent login information across the SQL Server instance, which is not guaranteed when this feature is used. This supportability of this feature is still under investigation.
Click HERE for more information regarding Contained Databases in Microsoft SQL Server 2012.
The Power View features requires SharePoint Enterprise.
No Power View reports will be provided out of the box, however, Customers can create their own Power View reports.
Click HERE for more information regarding Power View in Microsoft SQL Server 2012.
The AlwaysOn feature requires the Enterprise Edition of SQL Server 2012.
Click HERE for more information regarding AlwaysOn for Microsoft SQL Server 2012.
Click HERE for Guidance when running Microsoft Dynamics GP with Microsoft SQL Server AlwaysOn
SQL Server Developer Tools
The SQL Server Developer Tools enhancements will provide value to developers building on the SQL Server platform. No changes will be made in Microsoft Dynamics GP.
Transparent Data Encryption
HERE for more information regarding TDE in Microsoft SQL Server 2012.
Refer to the information below for more information on Microsoft SQL Server 2014.
1. What's New in Microsoft SQL Server 2014 - Click HERE
2. Books Online for Microsoft SQL Server 2014 - Click HERE
For technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can enter a new support request to Microsoft Dynamics® Technical Support from Customer Source or Partner Source under Support >> New Support Request.
You can also contact Microsoft Dynamics® Technical Support by phone using these links for country specific phone numbers.
Partners - Global Support Contacts (requires PartnerSource login)
Customers - Global Support Contacts