Database Requirements
- Last UpdatedApr 15, 2022
- 1 minute read
Supported Microsoft SQL Server Versions
|
Microsoft SQL Server Version |
Type |
Service Pack |
|
|
2016 |
64-bit |
Express, Standard, or Enterprise Edition |
SP3 |
|
2017 |
64-bit |
Express, Standard, or Enterprise Edition |
N/A |
|
2019 |
64-bit |
Express, Standard, or Enterprise Edition |
N/A |
Requirements
-
The MES 2023 release requires SQL Server 2016 SP3 or later as it makes use of SQL functionality added in that release.
-
SQL Server should be configured for TCP/IP for local connections. SQL Server should also be configured for TCP/IP for remote connections if servers that require access to the MES database, such as the MES middleware server or the Reports server, are on remote machines. SQL Server must be installed using a case-insensitive collation.
-
Microsoft Distributed Transaction Coordinator and IIS 6.0 or later.
-
MES Database using multiple languages requires AL32UTF8 Unicode character set installed on your server.
Recommendations
-
For proper database maintenance, use a SQL Enterprise version due to the availability of online indexing capability.