Log Shipping (can't "auto_fix" user after db restore)

Anyone,
I've implmented log shipping and it's working fine for the most part, but
since it's in a "read only" state,
I can't run a sp_change_users_login to remap my reports_readonly user to the
login on the secondary server.
Thus, this user can not access the read only database at all.
Anyone else seen this, or have a fix for it.
Thank you,
WayneNote the SID of that user in sysusers table within that database.
After that, drop the login and recreate it using sp_addlogin and the most
important being to use the SID noted from the sysusers table above
Look at sp_addlogin in Books Online along with @.sid parameter.. Good luck
!!!
"Wayne" <wgadberry@.comcast.net> wrote in message
news:%23x$ixsqbEHA.368@.TK2MSFTNGP10.phx.gbl...
> Anyone,
> I've implmented log shipping and it's working fine for the most part, but
> since it's in a "read only" state,
> I can't run a sp_change_users_login to remap my reports_readonly user to
the
> login on the secondary server.
> Thus, this user can not access the read only database at all.
> Anyone else seen this, or have a fix for it.
> Thank you,
> Wayne
>|||i'll give it a shot... thanks..
Wayne
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ekyMEmubEHA.3636@.TK2MSFTNGP10.phx.gbl...
> Note the SID of that user in sysusers table within that database.
> After that, drop the login and recreate it using sp_addlogin and the most
> important being to use the SID noted from the sysusers table above
> Look at sp_addlogin in Books Online along with @.sid parameter.. Good luck
> !!!
>
> "Wayne" <wgadberry@.comcast.net> wrote in message
> news:%23x$ixsqbEHA.368@.TK2MSFTNGP10.phx.gbl...
> > Anyone,
> >
> > I've implmented log shipping and it's working fine for the most part,
but
> > since it's in a "read only" state,
> > I can't run a sp_change_users_login to remap my reports_readonly user to
> the
> > login on the secondary server.
> > Thus, this user can not access the read only database at all.
> > Anyone else seen this, or have a fix for it.
> >
> > Thank you,
> > Wayne
> >
> >
>|||Worked like a champ Hassan.. you the man..
Wayne
"Wayne" <wgadberry@.comcast.net> wrote in message
news:%23wqQ3RzbEHA.2816@.TK2MSFTNGP11.phx.gbl...
> i'll give it a shot... thanks..
> Wayne
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:ekyMEmubEHA.3636@.TK2MSFTNGP10.phx.gbl...
> > Note the SID of that user in sysusers table within that database.
> >
> > After that, drop the login and recreate it using sp_addlogin and the
most
> > important being to use the SID noted from the sysusers table above
> >
> > Look at sp_addlogin in Books Online along with @.sid parameter.. Good
luck
> > !!!
> >
> >
> > "Wayne" <wgadberry@.comcast.net> wrote in message
> > news:%23x$ixsqbEHA.368@.TK2MSFTNGP10.phx.gbl...
> > > Anyone,
> > >
> > > I've implmented log shipping and it's working fine for the most part,
> but
> > > since it's in a "read only" state,
> > > I can't run a sp_change_users_login to remap my reports_readonly user
to
> > the
> > > login on the secondary server.
> > > Thus, this user can not access the read only database at all.
> > > Anyone else seen this, or have a fix for it.
> > >
> > > Thank you,
> > > Wayne
> > >
> > >
> >
> >
>