Resolve – Databases running in compatibility range, upgrade recommended.

I noticed this warning on top of my Central Administration page after the migration from SharePoint 2013 to 2016.

The SharePoint Health Analyzer has detected some critical issues that require your attention. View these issues.

One of the Configuration warnings is Databases running in compatibility range, upgrade recommended.

To clear this warning, follow the steps below:

1. Open SharePoint 2016 Management Shell from the SharePoint server
2. Use this cmdlet to upgrade content databases

   Get-SPContentDatabase | Upgrade-SPContentDatabase

3. Use this cmdlet to upgrade the other databases such as Search

   PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

4. Once the upgrades are done, click Reanalyze Now against the issue.

Troubleshoot – install SSRS 2016 Integrated Mode with SharePoint 2016

This week, I’ve been assigned a task/challenge to try and install and configure the SSRS 2016 for our new SharePoint 2016 environment. We are migrating from SharePoint 2013 to SharePoint 2016, and upgrading the SSRS becomes part of the migration.

The installation process is pretty simple and straightforward IF you didn’t have these many issues like what I have experienced.

Convert SharePoint server to Custom Role
Install the SSRS
Troubleshoot – Error 1603
– Fix exception – missing feature
– Fix exception – database schema
References