I have a Windows Server 2003 SP2 machine with SQL Server 2008 Express installed. I have my network configured with a NAT.

Internal clients can access the instance of SQL Server without a problem. I would like to enable SQL Server to be accessible from anywhere on the the internet.

I am not sure how to allow my NAT firewall to allow that. I tried adding the port 1443 to it but I still can't access it from a remote machine.

How can you make a given SQL Server available to the WAN?

Any help would be greatly appreciated.

Thank you


Depending on what brand/type your NAT/Firewall is you may look at Port Forwarding

This allows the public address of your NAT to recieve traffic to a specified port and then direct it through the NAT to the specific machine.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.