I have created a number of users and databases using the SQL Server Management Studio. Unfortunately, whilst creating a new user login, unticking of the entries relating to the password policy can be forgotten:
- Enforce password expiration
- User must change password at next login
With these entries ticked and enforced an automated login from a CMS website such as DotNetNuke will fail. There is no support for the password change dialogue.
To change the password policy for the account run the following as a new query (top left hand corner)
ALTER LOGIN USERNAME WITH PASSWORD=’PASSWORD’
Where USERNAME is the name of the user and PASSWORD is the new password.
Following this it is now possible to revisit the properties for the user and to uncheck the checkbox for enforce password expiration.
