August 7, 2003 at 2:31 pm
I transfered the database from one server to another, want to have an account to access to the database, I got the error message:
Error 21776: The name was not found in the User collection.If the name was qulified, use [] to separate various part of the name and try again.
August 7, 2003 at 2:41 pm
See http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
You may transfer the logins from the source server to the destination server or drop the user from database you restored and the grant database access again.
August 7, 2003 at 3:19 pm
I dropped the account and create it again by using following, it appears same error message.
use MASTER
go
exec sp_revokedbaccess 'ACCOUNT'
exec sp_revokelogin 'DOMAIN\ACCOUNT'
go
use DATABASE
go
exec sp_revokedbaccess 'ACCOUNT'
exec sp_revokelogin 'DOMAIN\ACCOUNT'
exec sp_grant login 'DOMAIN\ACCOUNT'
exec sp_defaultdb 'DOMAIN\ACCOUNT','DATABASE'
exec sp_grantdbaccess 'DOMAIN\ACCOUNT', 'ACCOUNT'
go
August 7, 2003 at 3:37 pm
Are you getting the error message from EM? If so, have you tried restarting EM?
Cheers,
- Mark
Cheers,
- Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply