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 4 possible alternate formats as described below.

New in 7.0: If a local SQL database is installed with the Server component, a 4th option becomes available. In that case, the server name and instance will read "(LocalDB)\TNT_Data", with the database named ELM_Primary_00001 by default. If this database is used, the LocalDB files will be stored in the Users\Public\ELM Data\'Instance Name' directory.

Note
This syntax for SQL Server name can be used for all 3 ELM databases: Primary, Failover, and the optional Archive database. In the case of LocalDB Database names, "_00001" will be appended to automatically generated databases, and subsequent Rollover/Archive databases will use the same ascending numbering scheme.

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.