General database configuration
- Kiss, Mate
Owned by Kiss, Mate
Jun 21, 2017
2 min read
Loading data...
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 the database isntanced 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. |
| Database Name | The name of the Verba database. |
| Database Windows Authentication | Set to Yes if Windows authentication used. |
| Database Login | The SQL user name or the Windows user name with the domain for the database access. In case of Windows authentication a Windows service user have to be used for the Verba services. |
| Database Password | The password for the SQL/Windows user. |
| Database Failover Partner | The hostname or IP address where the failover partner database server hosted. If the the database isntanced then provide the instance also. If custom port used then turn on the SQL Server Browser service at the database side. Please note that if mirroring is configured then the Native Client 11 or ODBC 13.1 have to be used as Database Driver. |
| Database Multi-Subnet Failover | Set to Yes if Always-on database used with Multi-Subnet Failover setting. Please note that in this case the Native Client 11 or ODBC 13.1 have to be used as Database Driver. |
| Database Driver | The driver used for database connection. SQL Server Native Client 11 download Microsoft ODBC Driver 13.1 download Note: If TLS 1.0 is disabled on the OS level, then the Native Client 11 or ODBC 13.1 have to be used. |
| 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 |