Migrate users to a new domain

Hello,

Yes it is possible to change the domain of your users with a SQL Statement. I will send you the SQL Statement in a private message.

Have you created, in RDM, these users with the Create SQL Server Login and User option activated? If yes, you will have to create these new domain accounts on your SQL Server before running the query.




If not and these users have access to the SQL Server from an Active Directory group, the query to change the domain will work.

@everyone : If you need to change the domain for the RDM accounts, because every installation and configurations are different, please contact us at support@devolutions.net.

Best regards,

Hello,
I am in the same situation.
Would it be possible to have the query?
Thank you

Hello,

@tguichard What RDM version are you using?

What data source type are you using?

Best regards,

Hello, I have a same problem. Just there is one specific change that we are moving from "domain.local" to "domain.cz" so netbios name is the same "domain"
we have RDM version 2020.3.19 and using MS SQL.

Olda

Please try the rename functionality in RDM. We use the "with name" syntax of SQL server to rename the users. For this to work the SID must match. As per the documentation:

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-login-transact-sql?view=sql-server-ver15

NAME = login_name The new name of the login that is being renamed. If this is a Windows login, the SID of the Windows principal corresponding to the new name must match the SID associated with the login in SQL Server. The new name of a SQL Server login cannot contain a backslash character (\).

Hi,

We are migrating from domain A to domain B. Can I have this query to fix the users?

Thanks.

Hello,

@tomers I have sent a private message with the SQL statement.

Let us know if you have any questions about it.

Best regards,