Friday, February 17, 2012

Error 21776 when mapping orphaned users..

When restoring a database to another server (both servers running SQL Server
7) I use the sp_change_users_login procedure ("Update_one" argument) to map
one particular orphaned user to a user on the new server. This orphaned user
happens to be the dbo of the database on the original server.
The procedure exucutes correctly, but when I look in Enterprise Manager
(login properties) I get the Error 21776 message "The name "xxx" was not
found in the users collection..." etc.
Is this only a refresh problem whitin Enterprise Manager? If not, can I just
ignore it anyway, or do I have to take further actions to have it working
the way I want it to (that is, to let the user on the new server access the
restored database)
Thanks for your help!
Per WilliamsonTry to exit EM and start it again, to see if it is a refresh issue.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Per Williamson" <per.williamson@.telia.com> wrote in message
news:G5dEb.42639$dP1.166871@.newsc.telia.net...
> When restoring a database to another server (both servers running SQL Server
> 7) I use the sp_change_users_login procedure ("Update_one" argument) to map
> one particular orphaned user to a user on the new server. This orphaned user
> happens to be the dbo of the database on the original server.
> The procedure exucutes correctly, but when I look in Enterprise Manager
> (login properties) I get the Error 21776 message "The name "xxx" was not
> found in the users collection..." etc.
> Is this only a refresh problem whitin Enterprise Manager? If not, can I just
> ignore it anyway, or do I have to take further actions to have it working
> the way I want it to (that is, to let the user on the new server access the
> restored database)
> Thanks for your help!
> Per Williamson
>

No comments:

Post a Comment