Asked by lianne143
at 2024-07-28 02:20:41
Point:500 Replies:6 POST_ID:829134USER_ID:12026
Topic:
Windows Server 2012;MS SQL Server;TCP/IP
Hi
We have SQL 2012 server and I have opened SQL server browser on( port 1434 inbound) and SQL server on (port 1433 inbound). Now I want to add a 10.25.4.0/22 inbound to our SQL server Firewall , which is installed on Windows 2012 ( any request coming from 10.25.4.0/22 should be able to access our SQL Server) Is there a way to achieve this .
Please post me some tutorials as how to do this.
Any help much appreciated.
Thanks
We have SQL 2012 server and I have opened SQL server browser on( port 1434 inbound) and SQL server on (port 1433 inbound). Now I want to add a 10.25.4.0/22 inbound to our SQL server Firewall , which is installed on Windows 2012 ( any request coming from 10.25.4.0/22 should be able to access our SQL Server) Is there a way to achieve this .
Please post me some tutorials as how to do this.
Any help much appreciated.
Thanks
Expert: David Johnson, CD, MVP replied at 2024-07-28 07:10:38
Assisted Solution
Expert: duncanb7 replied at 2024-07-28 06:31:26
100 points EXCELLENT
David, you are correct completely,
after I review the link I posted, it mentions remoteip=localsubnet,
Dear author please also try it at window command line if have time
netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip =10.25.4.0/22 profile = DOMAIN
Duncan
after I review the link I posted, it mentions remoteip=localsubnet,
Dear author please also try it at window command line if have time
netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip =10.25.4.0/22 profile = DOMAIN
Duncan
Accepted Solution
Expert: David Johnson, CD, MVP replied at 2024-07-28 06:17:31
200 points EXCELLENT
- 1
From Sever Manager Tools Bring up Windows Firewall with Advanced Services
- 2
Create a New Custom Rule or if you have an existing rule you can sort by port number i.e. 1434 and edit it
- 3
- 4
Add the program or service , here I checked service
- 5
Port and Protocol
- 6
Remote alow ip Addresses
]
- 7
The Profile you want this allow rule to be effective in
- 8
Apply, OK, You're done
Assisted Solution
Expert: duncanb7 replied at 2024-07-28 03:49:55
100 points EXCELLENT
What is remote address IP for 10.25.4.0/22 ?
Or are you talking about all access within your local LAN only including database server ?
Duncan
Or are you talking about all access within your local LAN only including database server ?
Duncan
Author: lianne143 replied at 2024-07-28 03:38:41
I want to only add a 10.25.4.0/22 inbound to our SQL server Firewall
Means any request coming from PCs belonging to 10.25.4.0/22 should be able to access our SQL Server
Means any request coming from PCs belonging to 10.25.4.0/22 should be able to access our SQL Server
Assisted Solution
Expert: duncanb7 replied at 2024-07-28 03:14:09
100 points EXCELLENT
Please read this configuration SQL server access using netsh command with advfirewall provided by
Microsoft at this site,http://msdn.microsoft.com/en-us/library/cc646023.aspx and example netsh command
Hope understand your question completely.If not, pls pt it out
Duncan
Microsoft at this site,http://msdn.microsoft.com/en-us/library/cc646023.aspx and example netsh command
Hope understand your question completely.If not, pls pt it out
Duncan
