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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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