This forum thread needs a solution.
Kudos0

Connection to SQL Server

I tried to connect a C++ application to SQL server using ODBC .. When using the local computer name , connection is Ok. Using the TCI/IP adress of the local host, it's not working. I enable a lot of SQL features. But I don't know if the port 1433 is open. When I check with Tellet , it fails (could not open connection to the host on port 1433)  How can I know if Norton Firewall is blocking port 1433 ? How can I open specifically port 1433 ? 

Replies

Kudos0

Re: Connection to SQL Server

You can test to see if Norton firewall is involved by right clicking on the Norton icon in the system tray and click on Disable Smart Firewall. Then test your connection again. If still blocked it is not Norton.  If it is, someone else will chime in to try to help with a firewall rule. Not my strong suit.

Kudos0

Re: Connection to SQL Server

Hello

I guess I was confused by Telnet. I configured the protocols TCP/IP with SQL Server Configuration Manager and add ports 1433 and 1434. I then checked with Telnet (using open 192.168.xx.xx 1433 and 1434) and all seems Ok, both on the client and the server side. I did what you suggest and disabled the firewall on the server and it works. I just add two rules for ports 1434 and 1434 and now it works.

I was just hoping that Telnet was a good tool to check if a port is blocked or not. But it seems that it"s not enough

Thank your for your help

Thierry

Kudos0

Re: Connection to SQL Server

Good news. Thanks for posting back.

Glad you were able to figure it out.