July 1, 2008 at 10:18 am
I have looked around and can't find any info on this so forgive me if it's answered and I can't find it.
I have a 2005 db (call it X) that is mirrored (not syncro) to another 2005 server (call it Y).
On X & Y there are SQL server logins that match with same passwords.
I create a snapshot of the mirrored DB on Y. When I login as one of the SQL server logins to Y,
I am not able to access the snaphot. If I make the login a sysadmin it will work but who wants
to do that.
Is there something I am missing that would make this work? Normally I would map the login
back to Y login and all is fine but the snap is R/O.
Thanks
Matt
July 1, 2008 at 11:11 am
Check the snapshot.sys.users to see what's mapped there and see if you have unmatched SIDs.
Or run sp_change_users_login with the reporting option.
July 1, 2008 at 11:30 am
sp_change_users_login 'Report'
From the snapshot db for user XYZ ...3319
user XYZ has SID of from master.syslogins.... 4449
I see now the way to handle this is to create the login with SID option using SID
from principal DB.
Thanks for the point in the right direction!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply