ELM Database Connections

When entering the SQL Server name for the ELM databases, use the default: just the name of the SQL server or one of 3 possible alternate formats as described below.

Note
This syntax for SQL Server name can be used for all 3 ELM databases: Primary, Failover, and the optional Archive database.

ELM Database Authentication

ELM can authenticate to the database using either Windows Authentication (recommended) or SQL Authentication. With either type of authentication, the ELM Server service will need DDL permissions like create databases, tables, and views, and DML permissions like select, insert and delete records. These permissions are inherited when the db_owner role is assigned to a user account in SQL Management Studio.