Many times people around me fail to connect to SQL Server from other Non-Microsoft Applications.
Assuming that there is no SQL Server Client installed, what are the different ways we can troubleshoot the connectivity test?
I know of following 2 tests: 1) Telnet to SQL Server IP with port 1433. 2) Every Windows PC comes with SQL Server ODBC Driver. Goto Control Panel and setup a test ODBC connection for SQL Server and perform the connectivity Test.
Please add any other ways you would troubleshoot such problem.