3

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

1

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

  • in my current environment sharpoint 2013 i am using reporting services sharepoint mode how can i migrate to new sql server 2017? – adilahmed Mar 27 '18 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 ? – Gautam Sheth Mar 27 '18 at 10:12
4

Yes it support SQL server 2017

Check

SharePoint 2016 with SQL server

Overview of SQL Server in a SharePoint Server 2016 environment

4

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.