Forum Discussion
Connect to MS SQL Server 2014 database (OS Windows Server 2012 R2) from Azure App service
Hello Everyone, I have a task to connect the Azure App service to an MS SQL Server database working inside an Azure VM. The VM with MS SQL Server and the Azure App are connected to the same local...
Your connection problem is related to the TLS version requested by your application and the TLS version used by the server.
On this link you find some details about TLS version support on SQL 2014, you need to ensure you have the correct service packs/CU's to support TLS 1.2, if that's what you would like: https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe
On this other link you find details about how to configure TLS in the server: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15
On this link you find some details about TLS version support on SQL 2014, you need to ensure you have the correct service packs/CU's to support TLS 1.2, if that's what you would like: https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe
On this other link you find details about how to configure TLS in the server: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15