How do I configure a connection to use tcp-ip sockets with SQL Server?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo

A. Run the SQL Client Configuration program on the client in questionand follow these steps :-

  1. Select the Advanced Tab

  2. In the Server box type in the name your application will use to referencethe server.

  3. For DLL Name select TCP/IP Sockets.

  4. For a server name that will be resolved to a numeric IP address just enterthe name into the Connection string. (This should work if you can PING thatserver by name.) For a numeric IP address just type the IP address into theConnection String.

  5. If you want to use a different port from the default (1433 is the default)follow the IP name or address with a comma and the alternate port. For example:,1434

  6. Hit the Add/Modify Button.

That should do it

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like