Technical Guide > Database > Database Connections

Creating a New Database or Connecting an ELM database

You can create a new database by the top Menu > New > Server (Group) > Database (Wizard). This will open a database wizard document.

Create or Connect: From the drop-down box, select if you would like to create or connect to an existing database.

Database Role: Primary, Failover, Archive, or Other (Use other if you just want to connect for reporting).

Server Name: servername\InstanceName,port (Port is only needed for non-standard 1433 SQL port). ex: sql2019\elmdb,1750

Database Name: Type the name of the new database or the name of the database you want to connect

Authentication Type: Windows Authentication is generally recommended however you can specify the SQL user name and password here.

Database Create-connect

Advanced: These optional settings are only available when creating a new database. Any changes made will apply to all new databases going forward.

Partition Scale -

Days: Each day a new set of data partitions is created.

Weeks: Each week new data partitions are created. Less physical files on the file system, slower query response times.

Database Role - This will show the role you selected previously.

Initial Data file Size - Default 100MB

Initial Log File Size - Default 100MB

Initial Data grow By - Default 20MB

Initial Log Grow By - Default 20MB

Initial Data File Path - Enter a path that is accessible to the SQL server to override SQL settings.

Initial Log File Path - Enter a path that is accessible to the SQL server to override SQL settings.