0

I have a plan to upgrade our SharePoint 2013 web application to SharePoint 2019 for this task now I am preparing Test Environment for SharePoint 2016 & SharePoint 2019 before that I want to clear some below my confusions:

  1. Is SharePoint 2016 & SharePoint 2019 supports SQL Server 2017 developer edition as backend SQL Server because in Production I will mount SharePoint 2019 upgraded database, In production sure it will be SQL Server 2017 Enterprise edition.

  2. Can SharePoint 2016 & SharePoint 2019 will support sharing the same instance in a separate SQL Server 2017 Server?

7

Yes, SharePoint 2016 and SharePoint 2019 support SQL Server 2017 Developer Edition only for non-production use.

Check also

Update

If I got your second point correctly, and you want to use the same SQL server instance for multiple farms.

So the answer is Yes, but for optimal performance in production environment, you would install SQL Server on a dedicated server that does not run other farm roles and does not host databases for other applications.

11
  • 2.Can SharePoint 2016 & SharePoint 2019 will support to share same instance in separate SQL Server 2017 Server? Dec 22 '20 at 10:26
  • Not clear! what do you mean at this point? Dec 22 '20 at 10:27
  • Hi can i use same SQL Server 2017 instance for Create SharePoint 2016 farm and SharePoint 2019 farm ? Dec 22 '20 at 11:19
  • @user3520155 Yes, you can! please, check the updated answer! Dec 22 '20 at 11:21
  • Thanks can i use in my case also for upgrade SP 2013 to SP 2016 and to SP 2019 ,i want to use separate SQL Server but one SQL 2017 Instance for SP 2016 & SP 2019 Dec 22 '20 at 11:26

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.