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

Detailed:

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:

1. https://blogs.msdn.microsoft.com/docast/2015/07/30/database-mirroring-configuration-failure-scenarios/

2. http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-that-the-ports-for-the-local-and-remote-endpoints-are-operational-microso/

3.http://stackoverflow.com/questions/11032937/how-to-resolve-error-1418-in-sql-server-while-mirroring

4.https://msdn.microsoft.com/en-us/library/ms189127.aspx

 

 

 

 

Advertisements