TLS was enabled? Yes 1.2, so then we reached out windows team to review it.
The strange thing was that Microsoft maintain it’s own SSL certificates so there was no reason to believe that there was an issue with the service itself… So, we focused on the jump server machine. (provider: SSL Provider, error: 0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054) The issue that they saw was:Ĭonnection was successfully established with the server, but then an error occurred during the login process. My client was able to connect to Azure SQL DB using that version of SSMS, but one day suddenly they couldn’t. Jump Server -> Windows server 2016 with management studio 18.3 But connecting to an Azure SQL DB? below the topology, issue and solution:
This week I had this case that blowed my mind! It is true that authentication issue are common in SQL Server. I’m not able to connect to any Azure sql database from my jump server vm, please help me!