It's great to be able to access your SQL Server remotely, whether during an unexpected emergency or the convenience of working from home. However, you've got to take care to set up remote access correctly.
The only secure way to connect from outside a network to inside the network is to use a VPN (Virtual Private Network) connection, This allows you to create a secure encrypted tunnel from your home computer to your office or data center. Your home (remote) computer is issued an IP address on the office network, and you are able to communicate with office computers over a secured link instead of connecting directly over the public Internet.
In this excerpt from Securing SQL Server: Protecting Your Database from Attackers (3rd edition) by Denny Cherry, you'll see how to set up secure access using Microsoft's Routing and Remote Access Services (RRAS). RRAS can be set up on a machine within a few minutes -- whether or not you have an in-depth knowledge of Windows networks. You'll get step-by-step instructions on installing RRAS and then allowing users to VPN into the network.
Register to download the free PDF, and also to see your discount coupon to save 25% if you want to purchase the full Securing SQL Server book. The excerpt and discount coupon are from and with permission of Elsevier Inc., all rights reserved.
To continue reading this article register now