Maintaining Logins, Passwords and roles from Principal to Mirror

Question

Post reply

Maintaining Logins, Passwords and roles from Principal to Mirror

Patti Johnson

SSCertifiable

Points: 7054
More actions
April 25, 2011 at 11:35 am

#236226

Does anyone have a sql script or process that can be used to automate the transfer of logins, passwords, roles, etc from the principal database to the mirrored database?
Thanks fellow DBA's.
Patti

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 1

Hey it doesn't have to be a script. I'm happy with a process or procedure that works and is automated.

Help! 😀

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

did you try:

http://support.microsoft.com/kb/918992

or

http://www.sqlservercentral.com/scripts/31776/

Keep in min you would better do this procedure including login SIDs !

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 3

Thanks ALZDBA. The solutions that I think you provided are for a one time solution. I could be mistaken.

What I want to do is automate this to run as a sql job so that the logins are always updated continuously just in cases they are changed, or if new logins are created.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

That problem can be solved using a service broker solution ( event AUDIT_ADD_DB_USER_EVENT to be investigated ).

or maybe even using extended events. ( could be in the audit events. I didn't play with those yet )

( start here: http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/01/an-xevent-a-day-1-31-an-overview-of-extended-events.aspx )