web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Trouble with Windows Authentication

(0) ShareShare
ReportReport
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?

I have the same question (0)
  • Verified answer
    Mark E Profile Picture
    6,451 on at

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

  • dmrichards26 Profile Picture
    5 on at

    Thanks, Mark - This did the trick!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans