Issue
In an environment where the Security Expert database is installed on a remote SQL server (i.e. not on the same machine as the one where Security Expert Server is installed), can I use SQL Authentication for the connection between SX and SQL Server?
Product Line
EcoStruxure Security Expert
Environment
Security Expert Server
Cause
SQL Server supports two authentication methods: Windows Authentication and SQL Authentication. Security Expert supports Windows Authentication only.
Resolution
No, Security Expert does not support SQL Authentication. You must use Windows Authentication, i.e. a domain user account must be setup with permissions both to the machine where SX Server is installed and the one where the SX databases are installed. Please refer to the SX-SRVR Security Expert - Client Server - Installation Guide for more information on the installation pre-requisites. See also KB article Security Expert Multiple Machine Installation for Windows Authentication with Active Directory for further information on how to setup SQL Server and SX on different machines.
