Share
Report
35Hi there.
As part of a Merge and Acquisition - we will be decommissioning DOMAINA and migrating users from DOMAINB. We have a good grasp on the environment - only bit outstanding is Dynamics SL.
Dynamics is currently using Windows Authentication for DOMAINA - we need to change this to DOMAINB for all our users.
What is required, both on the SQL and Dynamics side to allow for a smooth transition?
Does anyone have a QUERY that we can use to transition both permissions and Windows Logins to the new format?
1) When I look at the DBs in SQL, I see that each user explicitly has access to the sys/app DBs, ie: DOMAINA\jsmith. - Do we start adding duplicate records for DOMAINB\jsmith?
2) I notice that the 'CompanyNameSys' database has a UserRec table which appears to have various fields which are for the UserName/WindowsUserAcct. Is it as simple as updating these records? Do we need to perform any additional steps after making these changes?
3) We have a small set of users (15) - would it be just as easy to do this in the UI over SQL?
Assuming these changes would need to be done PRIOR to the cutover to ensure we do not get locked out?
Anything else we need to consider prior to making the cut over?
Appreciate your help!
Thank you.
M.
All responses (
Answers (
