January 22, 2019 at 9:14 am
Hi Team,
How to move SQL Logins from one environment to other environments without effecting the existing passwords.
1. I have created new environment(Windows 10) for dev testing and installed SQL 2012.
2. Restored all database from old to new environment.
3. Generated scripts for databases login from old server and executed in new server.
Now users are trying to connect to new server, it is throwing error as invalid password !!!
Please help me, how to migrate passwords from one environment to other(new) environment.
We have 100+ user , they are not able to connect to new server(environment) but they can able to connect old server.
Note: each one using their individual password.
January 22, 2019 at 1:46 pm
PRAMANA.DBA - Tuesday, January 22, 2019 9:14 AMHi Team,How to move SQL Logins from one environment to other environments without effecting the existing passwords.
1. I have created new environment(Windows 10) for dev testing and installed SQL 2012.
2. Restored all database from old to new environment.
3. Generated scripts for databases login from old server and executed in new server.Now users are trying to connect to new server, it is throwing error as invalid password !!!
Please help me, how to migrate passwords from one environment to other(new) environment.
We have 100+ user , they are not able to connect to new server(environment) but they can able to connect old server.Note: each one using their individual password.
What did you use to generate the scripts to transfer the logins? Not sure if you used these but the scripts in the following article work to do this:
How to transfer logins and passwords between instances of SQL Server
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply