locked
ALTER authorization on Endpoint RRS feed

  • Question

  • Hi,

     

    I already have a Database Mirroring session up and running. I basically want to change the Authorization on the endpoint. I am aware that it is possible using ALTER AUTHORIZATION command.

     

    But,  i wanted to check would it break my mirroring if i do it when it is running. 

    Or can anyone please post me the steps that are required for the modifying the authorization without changing it.

     

    thanks,

    Kris

    Tuesday, September 9, 2008 4:40 AM

All replies

  •  Kris Mohan wrote:

    Hi,

     

    I already have a Database Mirroring session up and running. I basically want to change the Authorization on the endpoint. I am aware that it is possible using ALTER AUTHORIZATION command.

     

    But,  i wanted to check would it break my mirroring if i do it when it is running. 

    Or can anyone please post me the steps that are required for the modifying the authorization without changing it.

     

    thanks,

    Kris

     

     

    Can anyone please reply to this message i need it on an urgent basis

    Tuesday, September 9, 2008 6:54 AM
  • Hi,

    I just had the same issue and ran ALTER AUTHORIZATION to change it to 'sa'.

    It seems to be working so far and mirroring did not drop out.

    Ross
    • Proposed as answer by rossco_1 Tuesday, March 24, 2009 12:56 PM
    Tuesday, March 24, 2009 12:56 PM