I wish all of you are doing safe and my sincere prayers to all of them who lost their lives during this battle with the on-going Pandemic. I am not able to focus on my work as many of my families got affected and I am trying my best to come out of this.
This post is more of a questionnaire rather than a solution. I got a mail last week saying the application team are getting time out Errors when they are trying to connect to Secondary replicas for reporting purpose.
As we know my initial checks are with Always ON Routing and couldn't find any issues in that.
Later I started checking from my end and surprisingly I didn't find any issues with SQL Server Management Studio from the Jump Server.
Then I tested the same with SQLCMD and I got the below Error.
3) why only with OLEDB provider but not with Native client?
Well I don't have an answer for this but as per the below link there are no updates being shipped with SQL Server Native Client.
Conclusion: To Mitigate the issue I made use of -l parameter and the issue got resolved to certain extent and this is how I worked to answer my self to the questions pose while connecting to DB Engine from different tools.
Hope you Learned something new and Happy Reading. Stay Safe.