SMEX has no special dependency for the SQL version.
The following are the supported SQL server versions in SMEX:
- SQL Server 2022
- SQL Server 2019
- SQL Server 2016
- SQL Server 2014
- SQL Server 2012
- SQL Server 2008 R2
- SQL Server 2008
SMEX 12.5 and 14.0 support both SQL Server account and Windows account to access the remote SQL server during installation.
To prevent permission issues when installing SMEX, the account used for installation should have the following privileges:
| ScanMail Database Option | Setup Account Privileges | Database Access Account Privileges |
| Remote SQL Server with SQL Windows Authentication |
Note: Activate End User Quarantine setup account should be the Domain Administrator. | dbcreator role plus the following privileges:
Note: Activate End User Quarantine setup account should be the Domain Administrator. |
| Remote SQL Server with SQL Authentication |
Note: Activate End User Quarantine setup account should be the Domain Administrator. | dbcreator role |
- If you choose to use Remote SQL Server Windows Authentication option, it is a best practice to use same domain account for Setup Account and Database Access Account.
- SMEX 11.0 only supports SQL Server account to access remote SQL server during installation.
- If only TLS 1.2 is enabled on your server, ensure that SMEX and your SQL Server can support TLS 1.2. Refer to KB 1119104 for details.