SQL Server 2016 Windows Server 2016 Firewall Rule Step-By-Step.
Opening Firewall in SQL Server 2016.
Once
the SQL Server is installed on the machine. We must enable the incoming traffic
i.e., from the application to the SQL Server Database. For this purpose, we must
create rule for SQL Server ports so that the application can
connect to database & perform the CRUD operations on the tables.
Now Let’s start Step-by-Step to enable it.
1. Start System and Login (As
Administrator);
2. Open Control Panel.
Click on Windows
Firewall;
3. Now click on Advanced
Settings;
4. Windows Firewall console open. If you click on Properties
(right side) – you can disable firewall for all networks. We going to Inbound
Rules (left side) for our rule creation;
After Clicking on the Inbound rules. We will see the
below screen.
Click on New Rule.
6. Rule creation process
begin. In my case, I create rule for Inbound TCP ports. For Rule Type
select option Port and click Next;
7. For Protocol and
Ports select option TCP and Special Local Ports. SQL TCP
ports (1435). After entering ports click Next;
8. For Action (in
this case leave by default Allow the connection). Click Next;
9. For Profile,
leave by default, click Next;
10. Enter name for your
rule (as example MSSQL_DB), so you can easily find it in future. Click Finish;
Now We can see the Firewall rule which has been created
just now in the Inbound Rules.
Comments