Cannot Connect to DB with TCP/IP but can with Named Pipes

[dellyjm]

When trying to connect to the DB from the ODBC creation wizard I get a cannot connect error. When I switch from TCP/IP to Named Pipes it connects easily. Any clue?

Delton.

 

[Corran007]

are you sure you have the correct ip address? and is the port number standard(1433) or is it set to something different?

 

[SQLBill]

As Corran007 said, check the Port your server is using; but also:

When connecting via TCP/IP are you using the Server Name or the IP address?

If you are using the name, try the IP address. If the IP address works then DNS isn't set up to recognize the Server Name.

-SQLBill

 

[timscronin]

If you can't get someone to put the server name into DNS, go to client network utilities and you can add a server Alias using tcpip for the connection. last resort is to add server name to host file