Prerequisite 1 – SQL Server setup
Our check includes three points, as outlined here:
- SQL Server version
To check your SQL Server version, use Command Prompt, as follows:
SQLCMD -S servername\instancename
The process is illustrated in the following screenshot:
- Database compatibility level
Run SQL Server Management Studio (SSMS), click on your database, and choose Properties. Then, choose Options and check the Compatibility level value. This must be SQL Server 2016 (130) or higher. Change it if needed and apply the changes.