?
Solved

script synchronize logins and permissions between principal and mirror servers

Posted on 2014-12-07
3
Medium Priority
?
99 Views
Last Modified: 2014-12-09
Hello,

I search a script to synchronize logins and permissions between principal and mirror servers.

Thanks

Regards
0
Comment
Question by:bibi92
  • 2
3 Comments
 
LVL 53

Expert Comment

by:Vitor Montalvão
ID: 40486582
The users are already in both databases, right? You just need to create the logins, correct?
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'
0
 

Author Comment

by:bibi92
ID: 40487609
Thanks but  I search to transfer login or synchronize them
0
 
LVL 53

Accepted Solution

by:
Vitor Montalvão earned 1500 total points
ID: 40488414
This MSDN article has a script that do that.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question