September 1, 2015 at 9:47 pm
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
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.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 2, 2015 at 10:23 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply