External Web Based Access

SQL Server Administration
1

Hi there,

I look after a SQL Server 2012 box which is used for connecting via the local network but I've been asked by the boss to configure it so that an external website can connect. I know some of that will require a firewall change to allow traffic through but did not know where to start with configuring the server itself to accept that traffic and secure it.

Can anyone point me in the right direction?

I appreciate that some of you might shout 'no, don't do that, use xxx instead', but I have my instructions.

Thanks for any help.

2

You should go this one it may help yours. Here you can see the Common Firewall Rules and Commands that may enhance the security. https://www.digitalocean.com/community/tutorials/iptables-essentials-common-firewall-rules-and-commands