Post reply

Problem in sa user properties

  • September 20, 2005 at 9:30 am

    #87830

    Hi Gurus,

                I have a problem in my development server.When I open Enterprise Manager-> Security-> Logins and right click on sa and choose properties it gives me error message "Error 21176:[SQL-DMO] The name 'dbo' was not found in users colletion.If the name is a qualified name,use [] to seperate various parts of name,try again."

      Please help me to resolve this issue.It's urgent.

                                  Thanks in advance.

                                               Manutosh

  • September 20, 2005 at 10:37 am

    #591418

    This Link from Microsoft Should help you with a work around for your problem

    http://support.microsoft.com/default.aspx?scid=kb;en-us;305711

    Thanks

    Prasad Bhogadi
    www.inforaise.com

  • September 20, 2005 at 5:31 pm

    #591551

    Hi all,

               it is still not working. Please help me.

                                                 Thanks

                                                     Manutosh

  • September 21, 2005 at 7:17 am

    #591735

    Have you tried to run the select statement from the mentioned article in every database? you can use this command to do that (should be on one line to work):

    exec sp_MSforeachdb

    @command1="SELECT '?',ISNULL(l.name,'unmatched') FROM ?..sysusers u LEFT JOIN master.dbo.syslogins l ON u.sid = l.sid WHERE u.name = 'dbo'"

    What is the output? It should list all databases with their respective owners. Isn't there "unmatched" somewhere?

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

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