How to change the owner of the mirroring

Question

Post reply

How to change the owner of the mirroring

MAK1

Ten Centuries

Points: 1162
More actions
August 26, 2011 at 9:48 am

#247084

my old friend (dba) create a mirroring and he is gone now, I want to change his Id to SA, but system is not allow me to change it, can someone help me, how to change the the ownership of mirroring and endpoint, I am running En. 2005

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

didnt we already discuss this at the link below?

http://www.sqlservercentral.com/Forums/Topic1165352-146-1.aspx

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

MAK1 Ten Centuries Points: 1162 More actions · Answer 2

but I didn't get the answer how to change the princple owner of mirroring and endpoint

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

to change endpoint users you run this against the mirror and the principal

GRANT CONNECT ON ENDPOINT::Mirroring TO [XXXXX\XXXXXX]

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

MAK1 Ten Centuries Points: 1162 More actions · Answer 4

Thanks for reply,

I can grant the new user but my issue is to replace the orignal user I want to delete the orognal user that i want to do that I want to totally replace that user or delete that user from my system

Thanks again

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

It's still unclear what you are trying to achieve, are you wanting to change the database owner?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

MAK1 Ten Centuries Points: 1162 More actions · Answer 6

Sorry not to clear properly,

I want to change/replace the "database Mirrorring owner"

Perry Whittle SSC Guru Points: 234013 More actions · Answer 7

Can you post a screenshot of what you are trying to change?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

MAK1 Ten Centuries Points: 1162 More actions · Answer 8

My cut and past is not working

whenI chech on server object then endpoing thne database mirroring

Name Owner

Mirroring [XXXX\XXXXXX]

that I want to change

David Perez V SSC Enthusiast Points: 194 More actions · Answer 9

I'm not sure if it's the same case, but i recently made a mirror and noticed that the wizard added my AD account into the logins and made it owner of the mirror endpoint. Searching for an answer I came to this forum and with a little help of the BOL I changed the endpoint so that I could drop my login. This is the script I used:

CREATE LOGIN [XXXX\XXXXX] FROM WINDOWS;

GRANT CONNECT ON ENDPOINT::Mirroring TO [XXXX\XXXXX];

ALTER AUTHORIZATION ON ENDPOINT::[Mirroring] TO [XXXX\XXXXX];

I post it in hopes that may be some one else will find it useful too.;-)

EDIT NOTE: I forgot to thank Perry Whittle. I got the GRANT line from his reply and it helped me to know what to search for in the BOL to make the change. Thank you Perry!

Todd Carrier Hall of Fame Points: 3951 More actions · Answer 10

Thank you for posting! Books Online says this in ALTER ENDPOINT:

AUTHORIZATION login

The AUTHORIZATION option is not available in ALTER ENDPOINT. Ownership can only be assigned when the endpoint is created.

Which made me think I was going to have to break the mirror and re-create.

But NO!

This did the trick for me:

ALTER AUTHORIZATION ON ENDPOINT::[Mirroring] TO sa;

Thanks again

Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)