I'm having intermittent connectivity problems when trying to connect to an azure based SQL database when using SSMS. I've done the following troubleshooting:
- The exact same version of SSMS has been installed on several computers (all SQL components are the same versions as well). Connecting to the database works fine on all computers except for one which a coworker is using.
- The same user account has been used for all connections.
- The one computer either straight up can't connect or when it does it will eventually disconnect (usually on the first query) with the same error message attached.
- I went through the SQL Server logs and can't find anything indicating why the connection would have been forcibly closed.
I'm wondering if it could be a security/firewall issue on the one computer but am not sure where or how I would find logs documenting this. The SSMS configuration is the same on all computers, shown in the screenshots below.
exec sys.sp_enum_oledb_providersreturns? And also, which version do you have of OLEDB : learn.microsoft.com/en-us/troubleshoot/sql/database-engine/… I think you need somewhat later versions of OLEDB to support the mandatory encryption and TLS stuff, see also learn.microsoft.com/en-us/sql/connect/oledb/…