Post reply

Windows Principal Orphan (DETECT, DELETE and/or DROP)

  • October 6, 2009 at 12:07 pm

    #156292

    Situation:

    Restore SQL 2005 database from another domain server (STUDENTLAB.local) to (ABC.LOCAL).

    oops! forgot to delete STUDENTLAB users.

    User STUDENTLAB\MATT can be seen but not deleted.

    What is the procedure to drop this Windows Principal orphan, please?

    Mike

  • October 6, 2009 at 12:43 pm

    #1062414

    that user is the owner of schemas or other objects in the database. change ownership of those objects to another user and then you should be able to drop that user.

    The probability of survival is inversely proportional to the angle of arrival.

  • October 6, 2009 at 2:28 pm

    #1062481

    When I do that I get the famous "Login name must be specified". In fact when I do anything to the user I get that response. The User Name is also greyed out in the USER record. So I cannot change it and I cannot delete it.

    Mike

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

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