SQL Server Connection-

General questions.
Post Reply
ramses2010
Posts: 21
Joined: February 10th, 2016, 7:28 am

SQL Server Connection-

Post by ramses2010 » August 13th, 2019, 11:01 am

ALOHA:

I am stuck with the firewall rules. I've spent hours on your Wiki's and still can't get it to work. I am wondering if anyone can share a few pointers. I am trying to pass through an SQL Server connection but unfortunately it appears my IPFire firewall keeps dropping the connection. Tried many combinations on the firewall rules, so far doesn't work.

This is what I need to do.
1. Pass through a connection from a specific IP and port from the external/internet Red NIC to a server in my domain with a specific IP and port in the green side of my firewall.

By going through wikis and playing around the firewall rules, I think I was able to get to "Incoming Connections" but the bottom says policy "BLOCKED" so I don't know if that makes that whatever I specify there is blocked. I certainly do not want it blocked.

Any Ideas on how to go about making this work? I have the latest build of IPFire.

Mahalo Nui Loa

gpatel-fr
Posts: 14
Joined: July 24th, 2019, 7:59 am

Re: SQL Server Connection-

Post by gpatel-fr » August 13th, 2019, 12:47 pm

Hello

first begin with a simple case such as a web server before going to difficult stuff like Sql Server. Once you have seen how it works, then pass to more complex cases.
The tutorial that has worked for me is here:

https://wiki.ipfire.org/configuration/f ... forwarding

Sql server is special you have no hope to make it work if you can't change engine configuration since it use dynamic ports by default:

https://docs.microsoft.com/en-us/sql/da ... erver-2017

Post Reply