Database snapshot using a mirror

[skhanal]

You could have used sp_change_users_login to update logins.

[J013]

OK I think I have it... I broke the mirror. I then brought the mirror on line and then used rev_login to get the users from the principal db then recreated them on the mirrored db. Took backups of the principal and restored them to the mirror db. Then I recreated the mirror and snapshot and now I'm able to query the snapshot without having userA as a sysadmin.

But doesn't that break the functionality of your mirror? Did you recreate the mirror after you fixed access to the snapshot? Otherwise I imagine you will have to have some other kind of mechanism in place to keep the data in the databases somewhat in sync like an SSIS package or BCP job.