Saturday, January 14, 2012 8:55 PM
We are unable to delete a login from sql server because it is also owner of database mirroring endpoint.
We are not sure about the effect of transferring the ownership of mirroring endpoint to 'sa' on Database Mirroring session.
Please guide us.
Sunday, January 15, 2012 4:44 AM
>>>>effect of transferring the ownership of mirroring endpoint
Not dropping endpoint , so should not be aside effect
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Sunday, January 15, 2012 11:23 AMTheir should not be any side effects of changing ownership of mirroring endpints provided new owner has granted connect permissions
- Marked As Answer by msdbapro Sunday, January 15, 2012 1:34 PM