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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

SL 2011 User Setup

(0) ShareShare
ReportReport
Posted on by

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

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

    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'

  • Verified answer
    Community Member Profile Picture
    on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans