Post reply

Execute as user

  • October 17, 2006 at 3:24 am

    #115889

    Hello,

    I've a little annoying problem.

    When I try to run an "execute as user='MyDomain\SomeUser' I get this:

    Msg 15404, Level 16, State 19, Line 1

    Could not obtain information about Windows NT group/user 'MyDomain\SomeUser', error code 0x5.

    Really strange, when I try with a non-existent domain account, I get this:

    Msg 15404, Level 16, State 11, Line 1

    Could not obtain information about Windows NT group/user 'MyDomain\NonUser', error code 0x534.

    It seems it can determine that SomUser is real, but nothing else.

    Any idea about this?

    TIA

    Alx

  • October 17, 2006 at 1:35 pm

    #666345

    error code 0x5. = Access is denied

    BUT 0x534 means "No mapping between account names and security IDs was done"

    does it give you some clue?

     

  • October 18, 2006 at 3:09 am

    #666420

    Thanks for your info.

    "Access is denied", ok, but which one?

    I thougth the problem was about account used to run MSSql Service, but I changed it from Local System to a domain account (member of BUILTIN/Administrators) and nothing happens.

    Maybe I need a tool to investigate better, 'cause there is no log ingo about this.

     

  • April 1, 2008 at 4:15 pm

    #796925

    Could you get this problem solved? How?

  • July 17, 2008 at 1:15 am

    #844181

    I faced the same problem and found that the db owner doesn't exists in the domain.

    so change the db owner to a vaild use in domain and should get solved. email me if you have any question balu4k@yahoo.com

    USE dbname

    GO

    EXEC sp_changedbowner 'domain\account'

    GO

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

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