Post reply

sql server 2000- Error 21776

  • November 5, 2008 at 12:06 am

    #72976

    Hi friends,

    I have faced error in sql server 2000 for the following stpes

    In Enterprise manager under security-> logins->then right click sa login name-> then click properites

    Immediatelly error has display

    Error number 21776 [SQL-DMO]- The name 'dbo' was not found.

    How solve this error? please tell me.

    thanks

  • November 5, 2008 at 2:02 pm

    #894520

    Have a look at

    http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-05/0276.html

    and

    http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-05/0278.html

  • August 6, 2009 at 1:22 pm

    #1035635

    Try deleting user account and then recreating it. Do this with SQL rather than via Enterprise Manger. The following sequence cured the problem on the server where it was observed (although it is not clear at which point the problem went away):

    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

    where ‘ACCOUNT’ is the name of the user account, ‘DOMAIN’ is the name of the NT domain in which the account is defined and and ‘DATABASE’ is the name of the database that the user is to have access.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply