You’re offline. This is a read only version of the page.
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.
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.
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?
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,524
Super User 2024 Season 2
#2
Martin Dráb
228,469
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (