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"