I already have a service account created in Logins: SQL\SVC.
---CREATE ENDPOINT <endpoint_mirroring>
STATE = STARTED
AS TCP ( LISTENER_PORT = 7023 )
FOR DATABASE_MIRRORING (ROLE=PARTNER)-----
If I run above script, I think, my window authentication will be used.
So how to write query so SQL\SVC can run on both principle and mirror server?
Should I run below after the above script?
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [SQL\SVC];
GO