Updating a DotNetNuke website I was unable to proceed, encountering the error: login failed for SQL Server login. The full error reported by DNN was:
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )ERROR: Could not connect to database. Login failed for SQL Server login 'dbUser'. The password for this login has expired.
This error is caused by the configuration of the SQL user assigned to the DotNetNuke website installation instance. When adding the user through the Microsoft SQL Server Management Studio the Checkbox for Enforce password expiration was left checked.
When the password had expired the database connection for the site was blocked.
To re-enable the password expiration checkbox needs to be unchecked. Open the SQL Server Management Studio to make the change:
- Login to the SQL Server Management Studio
- Expand the Security and logins folders
- Double click on the relevant user name
- Ensure that the checkbox for Enforce Password Expiration is unchecked.
- Click on OK
