SQL Server Requirements
Verify the following SQL Server requirements with local database administrators:
- Microsoft SQL Server 2016, 2017, 2019 x64 (Standard or Enterprise Edition) or Developer Edition (for non-production and non-demonstration systems). The latest SQL Server service packs and patches are highly recommended.
- Firewalls and access lists must be configured such that the Web Server can maintain a connection to the Database Server. SQL Server uses TCP port 1433 for this by default, but ports may also be dynamically assigned or manually assigned by administrators.
- SQL Server must be installed using the default, server-level, case-insensitive collation sequence: SQL_Latin1_General_CP1_CI_AS.
NOTE: Once SQL Server is installed, it is not possible to change the collation sequence.
To verify the SQL Server version:
- Open SQL Server Management Studio.
- Click New Query on toolbar.
- Connect to the appropriate SQL server instance.
- Enter and execute the following: SELECT @@Version
- Verify in the Results pane that the version is a supported version of SQL Server outlined in the below table.
Verify SQL Server Version Results pane
NOTE: The version numbers display in the form shown in the table. The last three digits of the version number determine the service pack installed.
The following SQL Server versions are certified and supported. If necessary, contact internal client DBAs to request an update or to upgrade to a supported version.
|
|
No SP (RTM) |
SP1 |
SP2 |
|---|---|---|---|
|
SQL Server 2019 |
15.0.2000.5 |
||
|
SQL Server 2017 |
14.0.1000.169 | ||
|
SQL Server 2016 |
13.0.1601.5 | 13.0.4001.0 | 13.0.5026.0 |
