Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the co
rrect SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an opt
ion for you, you need to
do something with sp_change_users_login, something you run after the failove
r has taken place...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is t
here a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>

Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the correct SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an option for you, you need to
do something with sp_change_users_login, something you run after the failover has taken place...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is there a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>sql