SQL Server does not exist or access denied

Question

I'm trying to test my connection outside of Azure, on my local machine using a .UDL and I get the error below:

---

Microsoft SQL Server Login

---

Connection failed:

SQLState: '01000'

SQL Server Error: 53

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQL Server Error: 17

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Answer 1

Hi Will Stephens,

Welcome to Microsoft Q&A forum.

As I understand, you are getting SQL Server does not exist or access denied error.

Could you please refer to the solutions discussed over these links which might help:

https://stackoverflow.com/questions/4657919/sql-server-does-not-exist-or-access-denied

https://support.microsoft.com/en-us/topic/eb667d0e-9489-89c4-78d6-5e314bd1d806

Let us know if above do not help.

Thanks

Answer 2

I am getting this error:

Login failed for user 'SERVER NAME'. Reason: Azure Active Directory only authentication is enabled. Please contact your system administrator.

Answer 3

Hi @Will Stephens

Thanks for sharing error message.

Kindly refer to the comprehensive blog for the error you provided and its corresponding mitigation.

https://techcommunity.microsoft.com/t5/azure-sql-blog/azure-active-directory-only-authentication-for-azure-sql/ba-p/2417673

Thank you!