Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You are prompted to enter a password when you sign in to Microsoft Dynamics SL and the database is Windows Authenticated

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

View products that this article applies to.

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.

↑ Back to the top

Resolution

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

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

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2953173
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 223