TCP/IP Sockets Client Connections

Troubleshooting SQL Server

Troubleshooting

TCP/IP Sockets Client Connections

The following procedure describes how to test a network connection when using TCP/IP Sockets as the IPC mechanism.

To test a TCP/IP Sockets connection

  • At the operating system command prompt on the client workstation, type:

    ping {ip_address | server_name}

When using ping, ip_address is the TCP/IP address of the server to which you want to connect, and server_name is the name of the server to which you want to connect.

For example, to check the connection between a TCP/IP Sockets client workstation and a server at the TCP/IP address 11.1.4.70, type the following on the client workstation:

ping 11.1.4.70

If the connection is open, the output looks something like this:

[1] echo received from 11.1.4.70 with roundtrip < 50 sec

This example checks the connection between a TCP/IP Sockets client and a server named SEATTLE1:

ping SEATTLE1

If the connection is open, the output looks something like this:

[1] echo received from SEATTLE1 with roundtrip < 50 sec

See Also

Configuring Client Network Connections