Post reply

error 21776: User login issue

  • August 7, 2003 at 2:31 pm

    #64974

    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

    #469091

    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

    #469097

    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

    #469101

    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