How to change or alter endpoint Mirror user

Question

How to change or alter endpoint Mirror user

MAK1

Ten Centuries

Points: 1162
More actions
August 25, 2011 at 7:41 am

#242272

I am running 2005 Ent. edition, I want to change the user but getting following error
ALTER ENDPOINT [Mirroring]
AUTHORIZATION [XXXXXX\XXXXXX]
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AUTHORIZATION'.

Viewing 7 posts - 1 through 6 (of 6 total)

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

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

MAK1 (8/25/2011)
I am running 2005 Ent. edition, I want to change the user but getting following error
ALTER ENDPOINT [Mirroring]
AUTHORIZATION [XXXXXX\XXXXXX]
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AUTHORIZATION'.

if you're trying to change the user account for the mirroring endpoint (and i supsect you are), you need to create the login on the partner instance and then grant connect for the account on the endpoint.

Please confirm the following

account name sql server runs under on principal

account name sql server runs under on mirror

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

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

MAK1 Ten Centuries Points: 1162 More actions · Answer 2

one of my old dba create a mirroring on his account now I want to change the all principal, mirror and witness server to the swl server account but getting an error

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

as i said, this is not how you change it

MAK1 (8/25/2011)
ALTER ENDPOINT [Mirroring]
AUTHORIZATION [XXXXXX\XXXXXX]

Create the login on each instance and grant connect to the mirror endpoint

CREATE LOGIN [Mydomain\UncleBobCobbly] FROM WINDOWS

GRANT CONNECT ON ENDPOINT::TheEndpoint TO [Mydomain\UncleBobCobbly]

Generally the account sql runs under is the account you create and grant connect to within each instance of sql server

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

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

MAK1 Ten Centuries Points: 1162 More actions · Answer 4

Thanks for help but I am getting following syntax error

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

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'ENDPOINT:'.

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

MAK1 (8/25/2011)
Thanks for help but I am getting following syntax error
GRANT CONNECT ON ENDPOINT: [Mirroring] TO [XXXXX\XXXXXX]
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ENDPOINT:'.

Sorry my bad forgive my typing it should be

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 6

Thanks this work for grant permission, i want to change the owner of the Mirroring and delete the owner