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, 2017 at 16:35
  • Yes but I want to upgrade SQL Server to a newer version
    – Noah
    Mar 10, 2017 at 19:33
  • SharePoint is not supported with Sql Server 2012? do u have any data in your farm?
    – Waqas Sarwar MVP
    Mar 10, 2017 at 19:34
  • Yes, Can I run the SQL Server 2014 installer to update it?
    – Noah
    Mar 13, 2017 at 1:42

1 Answer 1


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 and acknowledge you have read our privacy policy.

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