Configuring Database Authentication

By default, Enterprise Server for .NET connects to SQL Server using Windows authentication (SSPI), with user login credentials.

You can configure the installation to connect to the database using supplied SQL Server authentication and credentials instead of user login credentials.

This method is useful in situations where:

Set the database authentication details to use in machine.config.

Important: Use this process when an installation accesses database servers located on remote machines that use different login credentials. If an event monitor attempts to access a database server on a remote machine for which it has no access, the attempt fails.
Note: If your installation uses Windows authentication for SQL Server, ensure that the event monitor service (seemonitor.exe) and the IIS application pool used by Enterprise Server for .NET are configured to run as a Windows user that has database administration privileges for each of the region databases that are to be accessed.