Problem with user logins after db Restore

Posted by JJgates on Stack Overflow See other posts from Stack Overflow or by JJgates
Published on 2010-05-19T07:37:11Z Indexed on 2010/05/19 7:40 UTC
Read the original article Hit count: 141

Filed under:
|

I have two SQL 2005 instances that reside on different networks. I need to backup a database from instance A and restore it to a database in instance B on a weekly basis so that both databases hold the same data. After the restore, logins SIDS on database B are changed and therefore users can't log into database B and connection strings for the web application it supports are broken. Is there a work around for this? Thanks.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2005