How to update Microsoft SQL Server password when it has expired
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When using Microsoft SQL Server with an Atlassian application that uses database pooling (Confluence, JIRA, etc.), suddenly becomes unreachable without any configuration changes in the application.
The user interface may show an error such as:
1
2
com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.NullPointerException
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:152)However this error by itself is rather generic.
Check for the following in the log file (here from Confluence):
1
2
2013-01-04 12:34:01,872 WARN [Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@6c74ac85] [mchange.v2.resourcepool.BasicResourcePool] run com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5693c09e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Login failed for user 'atlassian'. Reason: The password of the account has expired.Cause
SQL Server has 'Password Expiration' enabled and the database user's password has expired.
Resolution
On the Microsoft SQL Server side, ensure the database user's credentials are valid. You may then need to update the database connection information. Depending on your product you will need to check
<confluence-home>/confluence.cfg.xml<jira-home>/dbconfig.xml<bamboo-Home>/bamboo.cfg.xml<bitbucket-home>/shared/bitbucket.properties<FISHEYE_HOME>/config.xml
Was this helpful?