Users are unexpectedly prompted to type a password by a Windows Authenticated database in Microsoft Dynamics SL 2011
This article provides methods to solve the issue that users are unexpectedly prompted for a password when they sign in to a Windows Authenticated database in Microsoft Dynamics SL 2011 after an upgrade.
Applies to: Microsoft Dynamics SL 2011
Original KB number: 2550383
Users are prompted for a password when they sign in to a Windows Authenticated database in Microsoft Dynamics SL 2011 after the system is upgraded from a previous version of Microsoft Dynamics SL.
This behavior occurs because a new feature was added in Microsoft Dynamics SL 2011 to optionally require the entry of a password when users sign in, even when Windows Authentication is being used. When a database that previously used SQL Authentication is upgraded, each user's password is retained and must be entered when the user signs in to Microsoft Dynamics SL 2011.
If you do not want to require the entry of a password for a Windows Authenticated database, remove the value from the Password box on the User Maintenance (95.260.00) screen for all users except the Sysadmin user. To do this, use one of the following methods.
- Sign in to Microsoft Dynamics SL as the SYSADMIN user.
- Under the Administration module group, open the User Maintenance (95.260.00) screen.
- Select a user ID in the User ID box.
- Delete the value from the password box.
- Save, and then repeat for each user.
Before you follow the instructions in this section, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
Log off all users from the Microsoft Dynamics SL database.
Run the following SQL statement in Microsoft SQL Server Management Studio against your Microsoft Dynamics SL 2011 System database to remove the passwords for all users except Sysadmin:
update userrec set Password = '' where UserId not like ('SYSADMIN')
For more information, see the Microsoft Dynamics SL Login topic in the Reference section of the Microsoft Dynamics SL 2011 Help or User's Guide.