Database migration...

I just migrated database A from Server A to Server B.
Server B has a database B on it. Database B has a stored
procedure that has a cross server transaction.
Now that both the databases are on Server B, I am trying
to execute that stored procedure. The procedure works fine
if I run it through Query analyzer logged in as a regular
user.
If I login in as an Application Role it gives me the
following error message...
Server: Msg 916, Level 14, State 1, Procedure
P_Transfer_to_DBNew, Line 173
Server user 'transferuser' is not a valid user in
database 'DatabaseNew'.
Any thoughts or suggestions are welcome.
Thank you
AjayFigured it out, thank you
The guest login needed to be given permissions.
>--Original Message--
>I just migrated database A from Server A to Server B.
>Server B has a database B on it. Database B has a stored
>procedure that has a cross server transaction.
>Now that both the databases are on Server B, I am trying
>to execute that stored procedure. The procedure works
fine
>if I run it through Query analyzer logged in as a regular
>user.
>If I login in as an Application Role it gives me the
>following error message...
>Server: Msg 916, Level 14, State 1, Procedure
>P_Transfer_to_DBNew, Line 173
>Server user 'transferuser' is not a valid user in
>database 'DatabaseNew'.
>
>Any thoughts or suggestions are welcome.
>Thank you
>Ajay
>.
>