SBX - Search With Button

SBX - Forum Post Title

Moving SL to another domain

Microsoft Dynamics SL Forum

afali asked a question on 19 Apr 2016 1:48 PM
My Badges

Question Status

Suggested Answer

HI guys, I would like to move SL to another domain, we are using windows auth. How will I update the Sysadmin account to a new domain account and other users as well? As well as any other details that I may be missing?

Reply
Mark E responded on 21 Apr 2016 3:09 PM
My Badges
Suggested Answer

1. Move the databases to the new SQL server

2. Update the domain table with the new server name

3. Update the windows acct info in the userrec table to update to the new domain

4. Run the sync security option in the Database Maintenance scenario, this should update all the user logins and create Windows logins in SQL

Reply
Jeffrey Leiseth responded on 1 Nov 2018 1:00 PM

Other resources I found that seem to elaborate more on the awesome 4 point list

  1. Move the databases to the new SQL server
  2. Update the domain table with the new server name Update the ServerName in Domain table which located in System DB
  3. Update the windows acct info in the userrec table to update to the new domain - Ref  Unofficial Guide to Security in Microsoft Dynamics SL 7.0 Ctrl F userrec 
  4. Run the sync security option in the Database Maintenance scenario, this should update all the user logins and create Windows logins in SQL

I am about to attempt it so wish me luck!

Reply
Mark E responded on 21 Apr 2016 3:09 PM
My Badges
Suggested Answer

1. Move the databases to the new SQL server

2. Update the domain table with the new server name

3. Update the windows acct info in the userrec table to update to the new domain

4. Run the sync security option in the Database Maintenance scenario, this should update all the user logins and create Windows logins in SQL

Reply

SBX - Two Col Forum

SBX - Migrated JS