Return
-
Title
Database error 18456 after changing SQL administrator password -
Description
After changing the password used by the administrative account that connects to the database, the following error is seen in the Job Service log
"ErrorMessages(2020-11-12 21:17:48.453) [810143] Database error 18456: Login failed for user '
'.
[System.Data.SqlClient.SqlException] Login failed for user ''." Updating the connection information in the Job Service configuration does not resolve the error.
-
Cause
The connection string must be updated in the Base Data in Designer. -
Resolution
Update the value in Designer.
- In the Navigation pane, select "Base Data".
- Expand "General", and then select "Databases".
- Select the database that requires an update (in most instances this will be "Main Database").
- Select the "Settings" tab.
- Update the value of the "Connection parameter" with the new password.
- Commit changes to the database.
