Could not connect to SQL server using Microsoft SQL Server Connection in Data Manager but the connection is ok through OLEDB and through ODBC DNS.
Error message:
Please check the values for Username, Password, Host and other properties. Description: Communication link failure. Details: Error [08S01][Simba]Connection broken
Resolution
Verify if there are semicolons or other special characters in the password.
Is the TCP/IP protocol enabled in the SQL Server Configuration? See screen capture: