Database snapshot using a mirror

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.

If your server login and database user ID synchronized in mirror server.

Quote:

---

Originally Posted by skhanal

If your server login and database user ID synchronized in mirror server.

---

Hi, how would you go about doing that?

Quote:

---

Originally Posted by ezecastle

Hi, how would you go about doing that?

---

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.

Thanks.

You could have used sp_change_users_login to update logins.

Quote:

---

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.

>> Then I recreated the mirror and snapshot and now I'm able to query the snapshot without having userA as a sysadmin.

Did you see OP's post?

Quote:

---

Did you see OP's post?

---

NNNNope. Sorry about that. My mistake.