SharePoint Server 2016 Supports SQL Server 2017

The software requirements for SharePoint Server 2016 were updated with Microsoft SQL Server 2017 support. Two features I’m excited about:

  • SQL Server 2017 now supports Always On Availability Groups without an underlying Windows Cluster
  • SQL Server 2017 now supports RedHat, SUSE, and Ubuntu Linux distributions

More information can be found in What’s new in SQL Server 2017.

Another consideration is that SQL Server 2017 no longer includes SQL Server Reporting Services integration with SharePoint. This means that you must stick with SQL Server 2016 for SSRS integration with SharePoint Server 2016 or move to SSRS Native, however like past versions of SSRS, you can host downlevel SSRS database on an uplevel version of SQL Server (e.g., SSRS 2016 databases on SQL Server 2017).

Trevor Seward is a Microsoft Office Apps and Services MVP who specializes in SharePoint Server administration, hybrid scenarios, and SharePoint Online. He has been working with SharePoint for 16 years from SharePoint 2003 on up, managing environments with terabytes of content for 150,000+ user organizations. Trevor is an author of Deploying SharePoint 2016 and Deploying SharePoint 2019. You can find him on Twitter and in /r/sharepoint.