Configuring database connection
- Kiss, Mate
Database connection can be configured in Verba on profile or on per server level.
- In order to configure the database connection settings on the profile level, go to the Administration / Configuration Profiles menu and select the profile. The configuration can be found at the Change Configuration Settings tab.
- In order to configure the database connection settings on the server level, go to the Administration / Verba Servers menu then select the server that needs to be configured. The configuration can be found at the Change Configuration Settings tab.
The database connection settings can be found under the Database Connection node.
| Settings Name | Description |
|---|---|
| Database Hostname | The hostname or IP address where the database server hosted. If the database is a named instance then provide the instance also. In case of Always-on database, the connector name. If custom port used then use the hostname:port format or turn on the SQL Server Browser service at the database side. Examples:
|
| Database Name | The name of the Verba database. |
| Database Windows Authentication | Set to Yes if Windows authentication is used. |
| Database Login | The SQL username or the Windows username with the domain for the database access. |
| Database Password | The password for the SQL/Windows user. |
| Database Failover Partner | The hostname or IP address where the failover partner database server is hosted. If the database is a named instance then provide the instance also. If a custom port is used then turn on the SQL Server Browser service at the database side. Please note that if mirroring is configured then the ODBC 13.1 or newer has to be used as Database Driver. |
| Database Multi-Subnet Failover | Set to Yes if the Always-on database is used with Multi-Subnet Failover configuration. Please note that in this case, the ODBC 13.1 or newer has to be used as a Database Driver. |
| Database Driver | The driver is used for database connection. This driver configuration is only used by specific services in the system, other services use different SQL Server drivers bundled with the product (JDBC driver) or provided by other prerequisites (.NET framework). The following options are available:
 Certain advanced features require ODBC driver instead of the default:
|
| Enable SSL Encryption | Set to Yes if you want to set up SSL encryption. For more information see: Configuring SSL encryption for database connections |
| Java Trust Store Path | Java Trust Store path used for SSL encryption. For more information see: Configuring SSL encryption for database connections |
| Java Trust Store Password | The password for the Java Trust Store. For more information see: Configuring SSL encryption for database connections |
Check the firewall configuration on the SQL Server to ensure connectivity with the Verba servers, see https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-2016