Connectivity issue from Visual Studio Application on Read Routing in Always on MSSQL Setup.
When Client executes certain .execs from servers which are in domain same as that of the database servers then the .execs get executed successfully but when client tries to execute the .execs from their local machine which is not in domain then they are facing issues in connecting with the secondary instance.
2.When did it begin and how often does it occur?
It’s a repetitive issue, when client executes particular executable via local desktop systems which are not part of this mssql always on cluster domain.
What errors do you see?
è Logon failure errors of secondary instance.
What's the environment and are there recent changes?
è Two Host always-on setup in domain.
What have you tried to troubleshoot this?
è General troubleshooting and permissions issue on OS and DB level we have done.