Hello everyone,
I have following problem - We have 2 local networks on 2 different SFP ports (192.168.0.* and 192.168.2.*), and MS SQL server working in ‘0’ network.
We haven’t access to MS SQL server from any of this networks, only from ms sql server itself.
What should we do, to open access to ms sql via local network (both), but at the same time don’t open access to outside (internet)?
Thank you in advance.
Check configuration on both MSSQL (should allow remote connections) as well as windows server running MSSQL (check its firewall settings).
If you manage to connect ot MSSQL from the same subnet (clients from 192.168.0.x) but not form the other subnet (192.168.2.y), then check settings on the router.
Sorry guys, problem was in windows firewall.
I don’t know, how its happened, because before installing MikroTik, this server already works under pfSense with same firewall settings.
In any case, BIG thank’s!
Please, close thread.
Windows seemingly recognize network based on identity of gateway. When gateway changes (i.e. MAC address changes), Windows “detects” a new network and by default new network is declared to be “public network”. You have to check it as “home” or “business” network to make firewall rules less strict.
While I can understand benefits of such behaviour on typical moving installation (e.g. laptop running windows), I simply don’t understand it when it comes to a Windows Server installation (which is typically used to run MSSQL or some such).