locked
Effect of changing ownership of database mirroring endpoint RRS feed

  • Question

  • Hi All,

    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.

    Regards,
    Ravi Agarwal

    Saturday, January 14, 2012 8:55 PM

Answers

  • >>>>effect of transferring the ownership of mirroring endpoint 

    Not dropping endpoint , so should not be aside effect

    http://msdn.microsoft.com/en-us/library/ms189127.aspx


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by RamJaddu Sunday, January 15, 2012 11:32 AM
    • Marked as answer by msdbapro Sunday, January 15, 2012 1:34 PM
    • Unmarked as answer by msdbapro Saturday, February 11, 2012 10:48 AM
    • Marked as answer by msdbapro Saturday, February 11, 2012 10:48 AM
    Sunday, January 15, 2012 4:44 AM
  • Their should not be any side effects of changing ownership of mirroring endpints provided new owner has granted connect permissions
    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by msdbapro Sunday, January 15, 2012 1:34 PM
    Sunday, January 15, 2012 11:23 AM

All replies

  • >>>>effect of transferring the ownership of mirroring endpoint 

    Not dropping endpoint , so should not be aside effect

    http://msdn.microsoft.com/en-us/library/ms189127.aspx


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by RamJaddu Sunday, January 15, 2012 11:32 AM
    • Marked as answer by msdbapro Sunday, January 15, 2012 1:34 PM
    • Unmarked as answer by msdbapro Saturday, February 11, 2012 10:48 AM
    • Marked as answer by msdbapro Saturday, February 11, 2012 10:48 AM
    Sunday, January 15, 2012 4:44 AM
  • Their should not be any side effects of changing ownership of mirroring endpints provided new owner has granted connect permissions
    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by msdbapro Sunday, January 15, 2012 1:34 PM
    Sunday, January 15, 2012 11:23 AM