Thank you @Andy_Wismer
I wasn’t very clear (I’m at work and a lot of interruptions/tasks)
- This SQLServer is (2012R2) running on a Windows Server 2012 R2 (named ‘sql2’, with an ERP)
- ‘sql2’ is joined to an AD in an old windows 2000 server (SBS) (named ‘serverA’, domain avion.local)
- There is our NS running as VM in Proxmox (named ‘ADS’, and domain is avion.lan)
- After proving that moving from one domain to another all my users can still use the ERP, y proceed to move users [avion.local → avion.lan]
- Almost all my windows users are now from ‘serverA’ domain to ‘ADS’ [avion.local → avion.lan]
I’m aware, of something, sql2 authenticate the users on avion.local, I create the sames accounts, groups and passwords the same in both domains.
But, the problem occurs when I try to change the domain of ‘sql2’ from avion.local to avion.lan
- (the error) The sql services shows and error and the services don’t start. I document the process but I can’t find it.
- I know that after migrate the domain, I need to re-create sql accounts (well I think that is needed) so previously I backup the users+groups needed to recreate in sqlserver.
But I can proceed in the final step because the error.
So the correct question needs to be:
¿How to migrate a windows 2012r2 server running sql server 2008 r2, from an old windows 2000 domain to a new doman in NethServer/Samba/AD)?
As I say, I have the test VM replicating the “current” setup of server2012r2+sqlserver2008r2 joined in the old domain, I’m in the step of test that the ERP works for some users, then migrate to NS and test the ERP… hopefully I’ll find and solve the error that I have in the real setup.
Regards!