Tuesday, March 20, 2012

permissions issue with restore of a db from one server to another

I have backed up a database from ServerA and restored it onto ServerB.
I realise that permissions do not get transferred correctly as part of the
restore so i have corrected these on ServerB so that they match ServerA.
The app i am using to look at the database, Microsft Project Web Access
2003, is complaining that the access is not correct.
What have i done wrong ?
Should i have transferred the permissions via DTS or is there another way
for me to extract out what i need from ServerA to load onto ServerB.
Thanks in advancePermissions are unchanged when you restore or attach a database. The
problem you are experiencing is that the mapping between database users and
logins is out-of-sync, resulting in mismatched and/or orphaned database
users.
You can use sp_change_users_login to identify and correct login/user
mapping. See the Books Online <tsqlref.chm::/ts_sp_ca-cz_8qzy.htm> for more
information.
Hope this helps.
Dan Guzman
SQL Server MVP
"billu" <billu@.discussions.microsoft.com> wrote in message
news:426FA498-B2E8-4386-92B7-9AB2467C5A61@.microsoft.com...
>I have backed up a database from ServerA and restored it onto ServerB.
> I realise that permissions do not get transferred correctly as part of the
> restore so i have corrected these on ServerB so that they match ServerA.
> The app i am using to look at the database, Microsft Project Web Access
> 2003, is complaining that the access is not correct.
> What have i done wrong ?
> Should i have transferred the permissions via DTS or is there another way
> for me to extract out what i need from ServerA to load onto ServerB.
> Thanks in advance

No comments:

Post a Comment