This article provides suggestions when the JDBC section in the Web Server DB Configuration Tool fails to connect to the HEAT database.
1. The following fields may be required to connect to the HEAT database through the JDBC section in the Web Server Configuration Tool, each has an explanation for possible values -
a. Host - enter a resolvable host name or IP address of the SQL Server
b. Port - this field value is not always required if SQL Server is using the default port of 1433. If connection fails then contact your SQL Server DBA for port number
c. Instance - this field value is not always required (if default instance name is used) but it would be good to enter the SQL Server Instance. If you are unsure of the SQL Server Instance name that contains the HEAT database (as there may be more than one on the same SQL Server) then contact your SQL Server DBA
d. DB - the HEAT database name
e. Additional Properties - do not modify the existing field/value if it is already populated.
If you have confirmed the above settings and still have issues then review the host and instance names as they are typically the most common issues. The host name may require a correct fully qualified domain name.