Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Replication
Development
 Publishing Data over the Internet U...
Other versions are also available for the following:
SQL Server 2008 Books Online (May 2008)
Publishing Data over the Internet Using VPN
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Virtual Private Networking (VPN) technology allows users working at home, branch offices, remote clients, and other companies to connect to a corporate network over the Internet, while maintaining secure communications. Users can use Windows Authentication as though they were on a Local Area Network (LAN). All types of Microsoft SQL Server replication can replicate data over a VPN, but consider using Web synchronization if you are using merge replication, because Web synchronization eliminates the need for a VPN. For more information, see Web Synchronization for Merge Replication.

A VPN includes client software so that computers connect over the Internet (or in special cases, even an intranet) to software in a dedicated computer or a server. Optionally, encryption at both ends, as well as user authentication methods, are used. The VPN connection over the Internet logically operates as a Wide Area Network (WAN) link between the sites.

A VPN connects the components of a network using another network. To connect, the user tunnels through the Internet or another public network using a protocol such as Microsoft Point-to-Point Tunneling Protocol (PPTP) or Layer Two Tunneling Protocol (L2TP). This process provides the same security and features previously available only in a private network. PPTP is available with the Microsoft Windows NT version 4.0 and Microsoft Windows 2000 (and later) operating systems; L2TP is available with Windows 2000 and later.

For the user, the intermediate routing infrastructure of the Internet is not visible and it appears as though the data is being sent over a dedicated private link. As far as users are concerned, the VPN is a point-to-point connection between the user computer and a corporate server.

After you have your remote client configured to connect using a VPN, and the client has Internet access and is logged in to the corporate LAN, you can configure replication as though the remote client is connected directly on the LAN. For security reasons, it is possible to have different network resources available to users connected over VPN and to those connected directly on the LAN.

For more information about setting up a VPN, see the Microsoft Windows documentation.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker