-
Titel
Foglight service fails to start on FMS server -
Beschreibung
Foglight FMS server unable to create a connection to external database server running with SQL Always on.
The FMS log lists repeating errors as such,
FATAL [forge-startup] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database. Shutting down Foglight server... Check and make sure your database configuration is correct and the database server is up running.
java.lang.RuntimeException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host hostname, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
... 220 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host hostname, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
at
... 228 more
INFO [forge-startup] com.quest.nitro.startup.ForgeServer - Forge Server is shutting down.
-
Ursache
Foglight requires a host port to talk to its SQL Server repository to and does not connect via a port listener. -
Lösung
Must use the assigned port number of the SQL Server database.