bibi92
asked on
script synchronize logins and permissions between principal and mirror servers
Hello,
I search a script to synchronize logins and permissions between principal and mirror servers.
Thanks
Regards
I search a script to synchronize logins and permissions between principal and mirror servers.
Thanks
Regards
ASKER
Thanks but I search to transfer login or synchronize them
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could create a script for the logins in the principal server and run it in the mirrored server and after that just run the following command for each user in the mirrored database:
EXEC sp_change_users_login 'Auto_Fix', 'UserName'