1 Reply Latest reply on Jan 19, 2012 11:48 AM by fhuelsbeck

    JBoss "forgets" MSSQL password

    fhuelsbeck

      I am running JBoss 4.0.5 GA on Windows 2008 32bit.  During a 29 minute period connection to my MSSQL server was non-funtional.  The server log shows login failed and the MSSQL log indicates the password being supplied was invalid.

       

      Server.log

      org.jboss.resource.connectionmanager.JBossManagedConnectionPool -- Throwable while attempting to get a new connection: null

      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Login failed for user <DBO>

       

      MSSQL

      Login failed for user <DBO>. Reason: Password did not match that for the login provided.

       

      There were no JBoss or MSSQL process or sever restarts during this period for either server.  Also, I have verified the password in all datasources is set correctly.  It truly appears the password was "forgotten" for 29 minutes.  Any ideas on how to troubleshoot/identify a root cause will be greatly appreciated.

       

      Cheers... Fred