Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

SL 2011 User Setup

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I am having an issue for which I am curious if anyone else has had and has a resolution.  This client is using SL 2011 with Windows authentication.   I added a new SL 2011 user under user maintenance providing that user's Windows login, made this user a member of an SL group that existing users belong to, verified that the user shows under Windows User Maintenance, verified that he is a local admin and that her has SQL rights.

When this user launches SL, he can go to find database and enter the SQL instance name and it sees the system and application databases.  He select the system database and then, on the login screen, enters his user id and password.  No error message is given but the two fields simply clear and the login screen remains.  If he goes through this cycle 3 times, the login screen changes to also include the company id field but when he selects the company id and enters his user name and password he then gets the message that it is an invalid company id, user name or password.  I have reset the password in user maintenance just in case that got entered incorrectly but he still has the same issue.

Any idea what is missing to cause this?

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 User Setup

    I will try that but it is interesting that the other users, that are working, have passwords in the userrec table.  Currently, I have switched them to SQL authentication and this new user can get into SL just fine now.

  • Suggested answer
    Mark E Profile Picture
    Mark E 6,405 on at
    RE: SL 2011 User Setup

    If you are using the Windows Authentication method to login, the SL Passwords should be removed.

    From a previous post on another thread....

    There may be passwords still stored in your system DB.  Make a backup of your system DB and run the following:

    update UserRec set password = ' ' where UserId <> 'SYSADMIN'

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans