You are prompted to enter a password when you sign in to Dynamics SL and the database is Windows Authenticated

  • Article

This article provides a solution to an issue where you are prompted to enter a password when you sign in to Microsoft Dynamics SL and the database is Windows Authenticated.

Applies to:   Microsoft Dynamics SL 2011
Original KB number:   2953173

Symptoms

You are prompted to enter a password when you sign in to Microsoft Dynamics SL and the database is Windows Authenticated, even though you have not selected to require the entry of a password when users sign in.

Resolution

Run the following SQL Script in SQL Server Management Studio on the system database.

update userrec set [Password] = '' where userrec.UserId <> 'SYSADMIN' and userrec.UserId <> 'SERVICEUSER' and RecType = 'U'