Users are unexpectedly prompted to type a password by a Windows Authenticated database in Microsoft Dynamics SL 2011


Symptoms


Users are prompted for a password when they log on to a Windows Authenticated database in Microsoft Dynamics SL 2011 after the system is upgraded from a previous version of Microsoft Dynamics SL.

Cause


This behavior occurs because a new feature was added in Microsoft Dynamics SL 2011 to optionally require the entry of a password when users log on, 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 logs on to Microsoft Dynamics SL 2011.

Resolution


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.

Method 1:

1. Log on to Microsoft Dynamics SL as the SYSADMIN user.

2. Under the Administration module group, open the User Maintenance (95.260.00) screen.

3. Select a user ID in the User ID box.

4. Delete the value from the password box.

5. Save, and then repeat for each user.


Method 2:


Note 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.
  1. Log off all users from the Microsoft Dynamics SL database.
  2. 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')

More Information


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.