February 2, 2016 at 11:24 am
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.
February 2, 2016 at 12:05 pm
First, you'll need to allow either 1433 (not recommended) or another port that forwards to 1433 on the firewall. I wouldn't open 1433 since lots of bots scan that port. I'd use something high if you need to and redirect that.
After that, there's nothing different. If people use SQL auth, the connection from the internet is the same as the LAN. If they use Windows auth, they'd need to be able to reach a domain controller, in which case, you'd likely want a VPN to allow access from approved users to multiple sites.
If not, you'll have to dig in to what the Windows Auth process needs to access a DC.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply