Run below command in command prompt to verify whether port 5022 is blocked or not.

portqry -n  servername -e 5022

Note: portqry Utility should be available in windows to run the above command


The best way to check if a port is blocked is to do a port scan from the client machine.

There are many ways to do a port scan but since you mentioned being on Windows then I will suggest the Microsoft command line utility PortQry and the Graphical version PortQryUI

Using a PortScan utility you will get one of 3 results.

  • Listening means the server is listening on the specified port
  • Filtered means it received a TCP acknowledgement packet with the Reset flag set which likely indicates a firewall or software issue
  • Not Listening means it didn’t receive a response at all


Another way to check:

  • There is one command to check the firewall state
    (Update for Windows 7 users — as referred by Nick below — use netsh advfirewall firewall)

    netsh firewall show state

*******************SQL Server Error:1418******************

SQL Error 1418

Refer for Workarounds: