January 24, 2017 at 10:36 am
Hello
The below query will give the details of the HADR node. But I cant find who presently owns the account so that I can change it using query :2
SELECT p.name, e.* FROM sys.endpoints e
inner join sys.server_principals p on e.principal_id = p.principal_id
query 2:
Alter Authorization on endpoint::Mirroring to [SA] \[domain\account]
Kindly suggest
Thanks.
January 24, 2017 at 10:55 am
SQL-DBA-01 - Tuesday, January 24, 2017 10:36 AMHelloThe below query will give the details of the HADR node. But I cant find who presently owns the account so that I can change it using query :2
SELECT p.name, e.* FROM sys.endpoints e
inner join sys.server_principals p on e.principal_id = p.principal_id
query 2:
Alter Authorization on endpoint::Mirroring to [SA] \[domain\account]Kindly suggest
This link, details the following
AUTHORIZATION login
The AUTHORIZATION option is not available in ALTER ENDPOINT. Ownership can only be assigned when the endpoint is created.
You'll have to drop the endpoint and recreate it with the correct owner specified
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2017 at 11:04 am
Hw to find who owns the End point?
Thanks.
January 24, 2017 at 11:08 am
SQL-DBA-01 - Tuesday, January 24, 2017 11:04 AMHw to find who owns the End point?
the 1st column in the 1st query tells you who owns the endpoint, but that is immaterial since you have to drop the endpoint and re create it anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2017 at 11:16 am
Yep - thanks
Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply