DB user is locked and you get error message on the DB configuration page.

Problem:

DB user is locked and you get error message on the DB configuration page that “Your login failed for this database user. Please verify that you have specified the correct login and password for your database user.”

Reason:

If you see this in debug logs:

2011-03-29 12:28:08 “Unable to connect to database breeze.” DB DB_CONNECTION_ERROR E S – “-” – – -

2011-03-29 12:28:25 “Start up error: java.sql.SQLException: MacromediaSQLServer JDBC DriverSQLServerLogin failed for user ‘breeze’ because the account is currently locked out. The system administrator can unlock it. .” START_UP START_UP_ERROR E S – “-” – – –
Error message on the DB configuration page “Your login failed for this database user. Please verify that you have specified the correct login and password for your database user.”

Solution:

To resolve this unlock account issue, we need to uncheck the status of user on its Login Properties.
You can go to DB engine -> Security -> Logins -> Right click properties on sa and uncheck “Login is locked out” on its status.

Comments are closed.