ERROR org.apache.tomcat.jdbc.pool.ConnectionPool - Unable to create initial connections of pool. com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xxxxx'.
Article ID: 133540
Updated On:
Products
CA Application Test
Service Virtualization
Issue/Introduction
Start IAM and getting this error in the server.log file:
2019-06-18 15:34:24,538Z (10:34) [main] ERROR org.apache.tomcat.jdbc.pool.ConnectionPool - Unable to create initial connections of pool.
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user xxxxx'. ClientConnectionId:d7dd0adc-3476-4126-a139-321a92ed5ffd
Cause
The server failed over to the SQL Server secondary node
Environment
All supported DevTest releases.
Resolution
The server failed over to the SQL Server secondary node. DBA failed it back and needed to update the credentials on the secondary node in case it fails over in the future.
Once fixed was able to bring all DevTest components up and login in to the Dashboards.
Additional Information
For more information on SQL Server secondary nodes, also called replicas, refer to this link:
Make the most of secondary replicas in SQL Server Always On Availability Groups
Feedback
Yes
No
Powered by
