I have a Windows Server 2012 R2 with Sharepoint Server 2016 installed but the SQL server version is 2012. What do I need to do to upgrade the database to 2014 or 2016. Everything is installed in the same machine Sharepoint + Database. What I need to check to performf this upgrade and if you have any guide I can follow it would be really appreciated.

Best Regards.

  • 1
    did you install sharepoint 2016 with SQL 2012? – Waqas Sarwar MVP Mar 9 '17 at 16:35
  • Yes but I want to upgrade SQL Server to a newer version – Noah Mar 10 '17 at 19:33
  • SharePoint is not supported with Sql Server 2012? do u have any data in your farm? – Waqas Sarwar MVP Mar 10 '17 at 19:34
  • Yes, Can I run the SQL Server 2014 installer to update it? – Noah Mar 13 '17 at 1:42

As you current configuration is not on supported software, i would do in the following way.

  • Take the backup of current content Databases
  • Rebuild new SharePoint 2016 Farm with desired SQL version (SQL 2016)
  • create and configure Service Application & web application
  • restore the database from backup and upgrade on SQL server then attach to SharePoint.
  • Now test the application.

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.