I have a LAN which I connect two PCs through an ADSL Router.
I want to disable the internet on the PC carrying the SQL Server, and of course want to still be able to connect to SQL Server from the other PC.
- To block the internet from the server, I set its gateway to nothing.
- To enable access, I added the ports (TCP 1433, UDP 1434) to the firewall exceptions list on the server.
- I am connecting to the server from my client using SSMS's normal connect.
There are some blogs on the internet which say I have to 4. forward the same two ports to my server IP on my router settings, Is this last step necessary? because after applying the above 3 steps, I already can connect from my client.
Or the port forwarding step is meant only for VPN configuration (which I don't need I guess)?