Follow

arcserve-KB : UDP | UDP Console | Unable to launch Arcserve UDP console

Last Update: 2018-05-14 14:04:56 UTC
Problem: 

Unable to launch Arcserve UDP console as the following error is reported ' SQLServer is not available now. Please verify the service status, then restart Arcserve UDP Management Service' 

Environment:

UDP:- 6.5 Update 1.
SQL server : 2016 (Remote server)

Cause:  

The root cause is the password of the account expired for Arcserve_UDP as seen from the logs 'Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Login failed for user 'Arcserve_UDP'. Reason: The password of the account has expired.' 

Excerpts from the ARCAPP.log

Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Login failed for user 'Arcserve_UDP'. Reason: The password of the account has expired. ClientConnectionId:8083752e-9e27-4e58-a7e4-df0632313657)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
at com.ca.arcserve.edge.app.base.dao.impl.SimpleJDBCDao.execute(SimpleJDBCDao.java:46)
... 13 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'Arcserve_UDP'. Reason: The password of the account has expired. ClientConnectionId:8083752e-9e27-4e58-a7e4-df0632313657
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217


Solution: 

1. If we receive the above error as seen under the ARCAPP.log - 

In Login dialog box, you will be able to see checks boxes for Enforce Password Policy and Enforce Password Expiration as highlighted in the snippet below.

Uncheck the Enforce Password expiration as highlighted.   



Note:  If the above check boxes are selected while creating the new SQL Server logins, then the SQL Server will leverage the Windows password policies set by the windows administrator across the organization.

If the SQL Server Password is not changed within the Maximum Password Age window then it will be expired. 



2. After the above changes we will be able to launch the console without issues. 


More info: 

https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode

Enforce password expiration: 

The maximum password age policy of the computer is enforced for SQL Server logins.

To review the local policies on the machine expand Security Settings | Account Policies | Password Policy as shown in the snippet below.

​ 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments