SQL running on Azure VM regularly throws connection error

Question

I have an SQL server running on Azure VM which is accessed by multiple MS Access database running on multiple computers.
Since about 2 months ago, we will get this error regularly, once or twice a week, when opening the MS Access DB:

Restarting the VM does not seem to work. What can I do to fix?

Answer 1

That is a generic error meaning it could not connect to the server and does not help diagnose the actual issue in any way.

Please see:
https://learn.microsoft.com/en-us/troubleshoot/sql/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection#sql-server-does-not-exist-or-access-denied

Answer 2

Hi @Irma Kusuma ,

Any other related error message that your found in the log? Could you share them to us?

In addition, please try the solutions from below blog to resolve your issue.

SQL server error 17 – SQL Server does not exist or access denied