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.- 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')