3

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

Which ports should be opened for this?

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)
3

According to MSDN:

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

Server: "IPAddress\NameofService,Port"

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

  • Please read the question again carefully. Your answer does not answer the original question. – DavidPostill Feb 11 '17 at 12:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.