Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Changing domain usernames
Microsoft Dynamics SL (Archived)

Changing domain usernames

(0) ShareShare
ReportReport
Posted on by d_j_twilight 50

Our central IT department recently changed a bunch of users' active directory names, and now they can't log into the dynamics system I'm responsible for.

I'm trying to change their Windows User name in the User Maintenance Screen, but doing that results in "System Message 9891":

<username> is the default Microsoft Dynamics SL user for <AD user>, please define a new default Microsoft Dynamics SL user for <AD user> before deleting or updating <username>.

I don't want to have to create a bunch of new users and re-setup their permissions if there's an easier way, but I can't find any reference to this error or how to get around it.

Much appreciated.

*This post is locked for comments

  • Brian_IL Profile Picture
    Brian_IL 717 on at
    RE: Changing domain usernames

    If using Windows Authentication, did you check in SSMS that the user's domain accounts exist and have appropriate rights to the SL databases?

    Also check the SL user maintenance screen, that the SL user accounts are associated with the new domain account names.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing domain usernames

    I have done what listed above and everything looks like it should, but the user cannot connect.  At the Find Database, I enter the server name and the SYSTEM database, but I get the Unable to open the specified server database (66).

    Any other suggestions?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing domain usernames

    Hi

    You can find that Dynamics SL Dtabase Maintenance screen under Control panel-> Administrative Tools

    and follow the steps as mentioned above.

    Hope this helps

    Thanks & Regards

  • d_j_twilight Profile Picture
    d_j_twilight 50 on at
    RE: Changing domain usernames

    That seems like it should work, and I can do all of that except the Database Administration screen has no tabs, so I assume you meant Database Maintenance, as referenced by countless other articles with this sort of issue.

    Problem is, I can't find the Database Maintenance screen anywhere; I've logged in as myself (an administrator) as well as the sysadmin account, and neither has that screen available.

    We're running Dynamics SL 2011

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing domain usernames

    Hi

    Follow the below steps to handle this scenario easier.

    1) Take all the SL UserID's using the below query.

         Select UserId,UserName  From UserRec Order By UserId

         (execute the above query in SL System Database)

    2) Copy the Query results in to Excel and insert the appropriate Windows Acct (DomainName\USerName) next to the Userame for each UserID

    2) Form the Update Query based on the excel data.

        For EX:.

        Update UserRec SET WindowsUserAcct ='DOMAIN\USERNAME' Where UserId ='SLUSERID'

    3) Execute the above update statement under SL System database.

    4)  Open the Database Administration Screen and connect the appropriate Server credentials

    5)  Under the Update Database Tab select the correct SL System and Application Dbs

    6) Select the "Synchronize All Ownership & Security" scenario and Click the Update Database button

    7) During the synchronizing process system will map the new windows user account with SL DB (SQL)

    8)  You can verify this after the process done.

    Hope this Helps

    Thanks & Regards

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans