40.13 Database Connections
40.13.1 Overview ¶
In the Database connections area you manage SQL Server connections that are used in the Save to database task (see Chapter 15). A connection is created centrally once - with server, authentication and connection options - and can then be referenced in any number of profiles.
40.13.2 Toolbar ¶
| Button |
Effect |
| Add… |
Opens the editor to create a new connection |
| Edit |
Opens the selected connection for editing |
| Remove |
Removes the selected connection after a confirmation prompt |
A double-click on an entry opens the editor.
40.13.3 List Columns ¶
| Column |
Description |
| Display name |
User-assigned name (e.g. “Accounting DB”, “Helpdesk server”) |
| SQL Server |
Server address, with instance name if needed (e.g. sql.company.com\ACC01) |
| Authentication |
Windows authentication or SQL Server authentication |
40.13.4 Create or Edit a Connection ¶
The following inputs are available in the editor:
| Field |
Description |
| Display name |
Unique name |
| SQL Server |
Server address, port specification optional |
| Authentication mode |
Windows authentication (integrated security) or SQL Server authentication (username/password) |
| Username |
For SQL authentication: SQL user |
| Password |
Stored encrypted (see Chapter 40.6.7 - Password storage) |
| Test button |
Checks the connection with the entered data |
Note: The specific database and table are NOT stored in the connection but only in the Save to database task of the respective profile. This way one connection can be used for several databases on the same server.
40.13.5 Tip ¶
- On a Test click, the program checks the server reachability, NOT a specific database - that happens only in the Save to database task with the database configured there