What ports does MS SQL Server use for ODBC connections?

Question

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

Which ports should be opened for this?

score 6 · Accepted Answer · edited Jun 27 '16 at 20:33

6

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)

edited Jun 27 '16 at 20:33

DavidJ

answered Jan 25 '11 at 10:18

fluf

score 4 · Answer 2 · answered Jan 25 '11 at 10:19

4

According to MSDN:

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

answered Jan 25 '11 at 10:19

Siim K

score -1 · Answer 3 · answered Jan 18 '17 at 13:46

-1

Server: "IPAddress\NameofService,Port"

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

answered Jan 18 '17 at 13:46

fegomes

3 Answers3