What ports does MS SQL Server use for ODBC connections?

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

Which ports should be opened for this?

3 Answers

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) 

According to MSDN:

Default instances of the Database Engine use TCP port 1433 by default. 

Server: "IPAddress\NameofService,Port"

You need to use comma, after name of service, example: "localhost\MSSQLSERVER,1433"