Hi all, I have a few questions about permissions connecting to a snapshot of a database mirror.

Here is my set up. I have two servers principal and mirror they are different servers. I have created a snapshot of the mirrored db on the server that has the mirrored database.

When I log into the principal server and log into SSMS as userA I can query the principal database without any issues.

When I log into the mirrored server and connect with the same user I can see the snapshot in SSMS but cant loginto it.

It's telling me its not accessable. But when I log in to the mirror using SA I can see the snapshot and query it without any issues. I then changed the login userA permissions and made it an sysadmin on the mirrored server. I then connected using SSMS as userA and could query the snapshot. Is there something Im missing permission wise? Or do the users have to be sysadmins on the mirror to query the snapshot.

Thanks for your time.