We have to deploy SharePoint 2016 production farm for Intranet portal can we use now SQL Server 2017 as back-end and high availability with Always on
-
Check also the list of all Supported and Unsupported SQL Server for SharePoint 2019 and 2016– Mohamed El-Qassas MVP ♦Commented Apr 21, 2020 at 18:42
Add a comment
|
3 Answers
Yes, you can use SQL server 2017 with high availability always on.
Reference - Hardware and software requirements for SharePoint Server 2016
Overview of SQL Server in a SharePoint Server 2016 environment
answered Mar 27, 2018 at 9:58
-
in my current environment sharpoint 2013 i am using reporting services sharepoint mode how can i migrate to new sql server 2017? Commented Mar 27, 2018 at 10:01
-
That might be a long answer and it can't be given in comments section :) , can you accept this as answer and ask a separate question related to migration ? Commented Mar 27, 2018 at 10:12
Yes it support SQL server 2017
Check
SharePoint 2016 with SQL server
Overview of SQL Server in a SharePoint Server 2016 environment
Yes, you can use it, as it is supported version with SharePoint 2016. But if you are using the BI functionality then SQL Server 2017 no longer includes SQL Server Reporting Services integration with SharePoint.
Supported combinations of SharePoint and Reporting Services server
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).
SharePoint Server 2016 Supports SQL Server 2017
also check this one Embed paginated reports into SharePoint using the Report Viewer web part
answered Mar 27, 2018 at 12:46
