February 17, 2009 at 4:04 am
I have a mirrored server structure. Im trying to transfer the server logins from the principal to mirror, but when i try to run the task it says it cannot complete because it is in a mirror.
Is there a way i can get around this rather than stopping the mirror on the database and then running the script?
February 17, 2009 at 4:13 am
There are two SP map_login and sp_sidmap which can be downloaded form microsoft website.
February 18, 2009 at 1:00 am
Im Sorry, i cant find this anywhere on the web. Can you provide me with a copy of them or some assistance in finding information about them.
Thanks very much for your quick reply.
February 18, 2009 at 7:00 am
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply