Database Reference
In-Depth Information
Enabling the firewall's database port
As you must have noticed in the previous section, the port
1433
is responsible for ex-
changing information between the client and database server. So, naturally, this port
should be enabled on the server machine for packets to pass through it. I really hope you
are not one of those users who disable the firewall completely just to allow a single ap-
plication to pass through. Disabling the firewall is never a good idea unless you know
what you are doing; always spend more time to configure your firewall rather than taking
the easy way out by shutting down the entire protection.
Perform the following steps to enable the SQL Server port on the database server:
1. In
GDBServer
, click on
Start
, type the
WF.msc
command, and then hit the
Enter
key.
2. In
Windows Firewall with Advanced Security
, click on
Inbound Rules
.
3. From the
Action
menu, click on
New Rule
.
4. In
New Inbound Rule Wizard
, select
Port
and then click on
Next
, as shown in
the following screenshot: