4

I use MS SQL 2017 Express Database server in my Windows 2016 server.

I hope to expose MS SQL 2017 Express Database server to the internet, so I need open 1433 port in firewall.

But I find there are two options, local port and remote port, you can see Iamge 1, what are different?

What option should I set to open 1433 port for public internet?

Image 1 enter image description here

0

1 Answer 1

8

The local port is the port number on the local computer, in this case your Windows 2016 server. The remote port is the port number on the remote computer, in this case the client that is connecting to your SQL server.

In most protocols (including SQL Server) the client uses a randomly chosen port number, so the remote port setting in the firewall rule needs to be configured to the default setting of "All Ports". The local port number in the firewall rule needs to be whatever port number your SQL Server is listening on, in this case port 1433.

(Typically, you would only specify a particular remote port when creating an outbound rule; for example, you would specify remote port 80 if you wanted to create a rule blocking outbound HTTP traffic.)

You must log in to answer this question.

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