Post reply

'Could not obtain information about Windows NT group/user... ' error

  • February 24, 2010 at 9:13 am

    #217021

    Hello!

    I have upgraded several databases from 2005 to 2008. I configured replication (created publisher and subscriber) and log reader for a database in question was failing because of 'Could not obtain information about Windows NT group/user ...' error. Now I am trying to drop publication. All articles have been dropped, but publication itself can't be dropped because of the following error:

    exec sp_droppublication @publication = N'<DBName>'

    Msg 15404, Level 16, State 19, Procedure sp_replcmds, Line 1

    Could not obtain information about Windows NT group/user '<DomainName>\<UserName>', error code 0x37.

    I was able to configure replication for other databases successfully. There is only one I am having problems with. I am not sure how to interpret this error.

    Any help is appreciated.

    Thanks,

    Igor Marchenko

  • February 25, 2010 at 2:10 pm

    #1125213

    Hi Igor,

    Can you check and confirm if the Database owners User name still exists in the domain. I have seen this error happen when let us say that the UserA was the owner of the DB and at alter point that UserA was removed from the domain. When that happens these errors usually throw up. I am not at all sure about this but please do check it.

    -Roy

  • February 25, 2010 at 6:51 pm

    #1125324

    Roy,

    I fixed the problem by executing (found somewhere in the posts):

    ALTER AUTHORIZATION ON DATABASE::<DBName> to sa

    Thanks,

    Igor

  • March 6, 2010 at 2:01 pm

    #1129676

    Dear Igor,

    I had the same issue and I solved it using your suggestion to alter db ownership.

    Thanks.

  • December 14, 2015 at 10:40 am

    #1845877

    I had the same issue with replication and resolved it with the suggested sp

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

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