Post reply

how to delete a login linked with endpoints ??

  • September 1, 2015 at 9:47 pm

    #302700

    I am planning to delete a login from SQL logins because he moved out from project .when i try to delete the login , it throws an error saying " The server principal owns an endpoint and cannot be dropped , error 15141 "

    Same problem facing on different servers.

    Note : Environment is SQL 2012,SQL 2008 including cluster servers .

    Thanks,

    Lavanaya

  • September 1, 2015 at 11:41 pm

    #1823866

    Lavanyasri (9/1/2015)

    I am planning to delete a login from SQL logins because he moved out from project .when i try to delete the login , it throws an error saying " The server principal owns an endpoint and cannot be dropped , error 15141 "

    Same problem facing on different servers.

    Note : Environment is SQL 2012,SQL 2008 including cluster servers.

    Thanks,

    Lavanaya

    A very brief Google search threw up this thread.

    If this answers your question, perhaps you'd attempt the search yourself in future. If not, please explain why.

  • September 2, 2015 at 10:23 pm

    #1824183

    thread provided is different to my issue ..

    on some servers getting an error 15173

    can i change the authorization to sa or other different account ??

    USE master

    GO

    ALTER AUTHORIZATION ON ENDPOINT::Mirroring TO [sa]

    GO

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

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