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