SQL Database connection- Disable SSL

Question

SQL Database connection- Disable SSL

Just_learn 1

Oct 2, 2020, 5:47 PM

As stated, SQL Database and SQL Managed Instance enforce encryption (SSL/TLS) at all times for all connections. Is there any workaround to connect to azure SQL database without ssl ceritificate

David Browne - msft 3,851 Reputation points

Oct 3, 2020, 5:17 PM

Of course the client doesn't need a certificate. The server has one to validate the identity of the server and to provide TLS encryption.

1 answer

Your answer

David Browne - msft 3,851 Reputation points

Oct 3, 2020, 5:17 PM

Of course the client doesn't need a certificate. The server has one to validate the identity of the server and to provide TLS encryption.

Answer 1

Anurag Sharma 17,626

Oct 3, 2020, 9:11 AM

Hi @Just_learn , welcome to Microsoft Q&A forum.

As you have rightly mentioned there is no way to disable the SSL/TLS in Azure Sql Database. This is designed keeping the security and vulnerability prospects of the database.
https://learn.microsoft.com/en-us/azure/azure-sql/database/security-overview

There is more details available on the same at the below link.
https://learn.microsoft.com/en-us/previous-versions/technet-magazine/hh351833(v=msdn.10)

Could you please let us know the requirement as to why you would want to disable it?

UzarPiotr 26 Reputation points

Mar 27, 2023, 3:11 PM

I would like to pick up this topic - my problem is simple, currently my SQL server is being exposed via privateendpoint, and due to configuration of VPN, while connecting to the SQL I need to use privatelink address - however - when I do that I do receive error on SSL verification (for example connecting using PowerBi), due to the policy - even clicking "OK" doesn't allow me to go forward

AI Skills Fest

Share via

SQL Database connection- Disable SSL

1 answer

Your answer