Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Trouble with Windows Authentication

Posted on by 5

Hey Everyone - 

Hoping someone might be able to point me in the right direction here.

I'm working on changing over from SQL Authentication to Windows Authentication in our Dynamics SL 2018 environment. 

I started by going into user maintenance, and adding the Windows user name to all of our users. Then, I went into Database maintenance, set the authentication mode to Windows, and did a synchronize security.

After that, our SYSADMIN account was able to login using windows, but the general user accounts are still being prompted for credentials when they launch the client.

To further try to resolve this, I went into SQL and added our Windows SL Users group to the MSDynamicsSL database role for the system and application database. Unfortunately, no change.

I then removed the SL Group mapping, and added the SL Group mapping as a SQL Security login with rights to the SYS and APP database, still no luck.

Does anyone have any ideas what might be the issue?

  • dmrichards26 Profile Picture
    dmrichards26 5 on at
    RE: Trouble with Windows Authentication

    Thanks, Mark - This did the trick!

  • Verified answer
    Mark E Profile Picture
    Mark E 6,405 on at
    RE: Trouble with Windows Authentication

    Try removing the Passwords from the UserRec table for each SL UserID.  Existing SL Passwords will cause conflicts with Windows Authentication method.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans