Database requirements
- Last UpdatedNov 18, 2024
- 1 minute read
Supported Microsoft SQL Server versions
|
Microsoft SQL Server Version |
Type |
|
|
2017 |
64-bit |
Express, Standard, or Enterprise Edition |
|
2019 |
64-bit |
Express, Standard, or Enterprise Edition |
|
2022 |
64-bit |
Express, Standard, or Enterprise Edition |
Requirements
-
The MES 2023 R2 release requires SQL Server 2017 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.