Home Forums SQL Server 2014 Administration - SQL Server 2014 How to check connection to an sql server without ssms tools (Example : from web server) RE: How to check connection to an sql server without ssms tools (Example : from web server)

  • You can use the Windows telnet client to check if SQL is not blocked and accepting connections.

    From the web server open a cmd prompt. The command is "telnet MachineName port". If you get a black screen then sql is listening on that port.

    For example to check a server named Test with a default install of SQL/Server listening on port 1433: telnet Test 1433

    You can also use the IP instead of the MachineName