-
Titre
FMS will not start. "Fatal error connecting to database". "com.microsoft.sqlserver.jdbc.SQLS -
Description
FMS will not start. "Fatal error connecting to database". "com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'foglight'." Password changed in SQL Server
-
Cause
put FMS in debug mode (see SOL41911), looked at FMS log and saw first listed error:2011-04-18 15:14:44.471 FATAL [main] 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.
2011-04-18 15:14:44.471 DEBUG [main] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database
java.lang.RuntimeException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'foglight'.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'foglight'.)) -
Résolution
- using backend SQL Server database - used SQL Management Studio to change the password of the foglight user to 'foglight'
- then, took md5 encrypt script for the password 'foglight' on Quest Fog5 lab server that knew used password 'foglight' for backend database (does not matter what type database)
foglight.database.password = "q25f5a0c606fa55f9ee9dc65f698d8e6d"
and replaced same line in customer's foglight.config fileresults: Foglight started right up.