Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I require our firewall to allow ODBC connection from clients to the MS SQL Server.

Which ports should be opened for this?

share|improve this question
    
I think it is about time to accept an answer – spuder Jul 24 '13 at 21:56

We opened these ports and that did the trick. We can ping the server and create an odbc connection to the server:

1433 (ODBC)
icmp 
netbios (UDP ports 137, 138 & TCP 139 for NetBIOS over TCP)
share|improve this answer

According to MSDN:

Default instances of the Database Engine use TCP port 1433 by default.
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .