SQLServer2008 Open Windows Firewall configuration

 

In order to remotely access the SQL Server database through the TCP/IP protocol, the following points are required:

On servers running SQL Server, we must locate the port that SQL Server listens on and then add it to the "Allow inbound" Windows Firewall.

One: The port of SQL Server needs to be added to the firewall's inbound rules.

Two: If you cannot determine the port of the connection string, or if SQL Server is not listening on TCP 1433, add the UDP 1434 port that the SQL Server Browser service listens to in Windows Firewall. This is because:

A) If the TCP port is explicitly specified by the connection string, then a connection provider such as SQL Native client will use this port to connect to SQL Server, so SQL Server is not required at this time Browser service to find the appropriate port that SQL Server listens on.

b), if the port is not explicitly defined by the connection string, then the connection provider sends a UDP packet to port 1434. Therefore, if port 1434 is not turned on in Windows Firewall, the connection provider will not get the appropriate TCP port that SQL Server listens on. The connection provider then connects SQL Server with only 1433来. If SQL Server does not listen on port 1433 at this point, it will return a failure. Therefore, you also need to add the UDP1433 port to the Windows Firewall inbound rules.

Sometimes during the development process, someone else needs to connect to your local site to access the website, the firewall will block the outside access, you can open a port locally, so that others can access it.

1. Find the Firewall

2. Click Advanced Settings

3. Click on "Inbound Rules" and click "New Rule":

4. Click "Port"

5, fill in the port number you want to open, I use 9999:

6, the default next, next, and finally give you the settings to take a name, whatever you, I use pass9999point here, is to let 9999 port through

7, click Done, you can see in the list of the rules you set, and then this port can be accessed by the outside world, without having to shut down the firewall:

SQLServer2008 Open Windows Firewall configuration