0

getting error:

"The target database ('MyDB') is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent, see SQL Server Books Online."

in the SQL error logs with no information who is trying to log in.

This is on SQL 2017 version 14.0.3026.27 with Always On High Availability

3
  • Maybe this helps: mssqltips.com/sqlservertip/4511/…
    – McNets
    Jun 6, 2018 at 18:37
  • yeah, I saw that, thank you. My issue isn't why its happening but how to identify where its coming from.
    – Tomasz
    Jun 6, 2018 at 19:05
  • Sorry McNets, i just reread my question and see that i never specified what i was looking for.
    – Tomasz
    Jun 6, 2018 at 19:25

1 Answer 1

0

So on the SQL server, I was able to go to the "Event Viewer -> Windows Logs -> Application" and was able to match the event time with my time stamp in the SQL error log. Then i was able to find the user that was causing the error. Since we have a newly introduced AlwaysOn environment we went through his options to make sure it was set up correctly, that didn't help.

The issue was that he was on an old verision of SSMS that when he tried to connect seemed to cause the error. We updated his SSMS to latest version and it stopped.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.