How to migrate logins from one server to another

Question

Currently setting up a new server and wanted to know if there is a way to migrate logins and passwords from one server to another without it being on a domain?

Answer 1

Hello

Migrating logins and passwords from one server to another without a domain can be achieved through several methods. Here are a couple of options based on the information available:

From your company's resources:

1.The Identity Pass application helps to verify a user's identity before granting them access to corporate resources, which could be part of the solution for migrating credentials securely.

2.ADMT (Active Directory Migration Tool) can be used for migrating service accounts, where a new complex password is generated for each of them. This tool might be useful for your scenario, especially since it includes a feature for enabling the migration of passwords.

3.Azure Migrate, ASR (Azure Site Recovery), and DMS (Database Migration Service) are tools mentioned in a presentation by Rochak Mittal, which could be relevant if you're considering a migration involving Azure services.

From the web:

1.Microsoft provides detailed instructions on how to transfer logins and passwords between instances of SQL Server, which might be applicable to your situation. This includes creating stored procedures to generate scripts for transferring logins and their passwords.

2.There are also third-party tools like Sys-Manage's CopyRight2, which can selectively copy user and group accounts, including password hashes, from one computer to another, supporting various scenarios such as cross-domain and workgroup mode.

Please review these resources to determine the best approach for your specific needs.