Hi all! I have a domain server which controls internal and external traffic to our LAN, and a separate web server that hosts our websites. Recently I installed SQL Server Express on the web server and works fine with the websites hosted on the same site. However, now I'm required to allow an external website to access it and I'm not sure how to do that. Any suggestions on how to go about it?
The external website should connect to SQL Server thru the database server's address and port number. You might have to open the firewall to allow connection to that port number.