Product(s):	Promis.e, Bentley Substation
	Version(s):	08.11.13.140
	Environment:	N\A
	Area:	Database Platform Support
	Subarea:	N/A

Error or Warning Message

Error - Configuration Not Saved: Login failed for Ecaduser: Reason: The Password of the account Expired

Explanation

SQL Server has 'Password Expiration' enabled. After a certain time, the database users will need to change their passwords.

How to Avoid

Change the password

1. Close Promis.e/Bentley Substation.

2. Open SQL Server Management Studio.

3. Try to connect to the database engine by using the old user name and password.

4. When prompted, enter the new password and confirm the password.

(Optional) Disable expiration policy

1. In SQL Server Management Studio, select New Query.
2. Paste the following script nto the new query window:
   ALTER LOGIN [ecaduser] WITH DEFAULT_DATABASE=[promise], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
3. Modify the script to match the true login name and database.
4. Click Execute.

See Also

[[Install SQL Server Management Studio]]

[[SQL Server Login]]

Original Author:

Bhargav