<div>
Hi,<br />
<br />
Consider enforcing an IPSEC policy between the SQL server and the client?<br />
<br />
Regards,<br />
<br />
<br />
RobMobility.
</div>


Hi,

Consider enforcing an IPSEC policy between the SQL server and the client?

Regards,


RobMobility.

<div>
Hi,<br />
<br />
You could also use SSL:<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms189067.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms189067.aspx</a><br />
<br />
Regards,<br />
<br />
RobMobility.
</div>


Hi,

You could also use SSL:

http://msdn.microsoft.com/en-us/library/ms189067.aspx [http://msdn.microsoft.com/en-us/library/ms189067.aspx]

Regards,

RobMobility.

<div>
<div class="content wysiwyg-content">
Is there a way to VPN SQL data and CIFS data when the clients are at one MAN location using Windows 7 and the CIFS is on a Windows 2008 server and SQL cluster at another MAN location using a single encryption protocol? &nbsp;I know that some may ask why encrypt or encpasulate when the data is on a VPN. &nbsp;The answer is that the data is highly sensitive Personally Identifiable Information. &nbsp;Any assistance would be greatly appreciated.<br />
<br />
Thanks,<br />
<br />
Mark
</div>
</div>


Is there a way to VPN SQL data and CIFS data when the clients are at one MAN location using Windows 7 and the CIFS is on a Windows 2008 server and SQL cluster at another MAN location using a single encryption protocol?  I know that some may ask why encrypt or encpasulate when the data is on a VPN.  The answer is that the data is highly sensitive Personally Identifiable Information.  Any assistance would be greatly appreciated.

Thanks,

Mark

VPN with SQL Cluster data &amp; CIFS Data with encryption using Windows 7 and Windows 2088

A virtual private network (VPN) is a network that uses a public telecommunication infrastructure, such as the Internet, to provide remote offices or travelling users access to a central organizational network securely. VPNs encapsulate data transfers using secure cryptographic methods and other security mechanisms to ensure that only authorized users can access the network and that the data cannot be intercepted.

Encryption is the process of encoding messages or information in such a way that only authorized parties can read it. In an encryption scheme, the intended communication information or message, referred to as plaintext, is encrypted using an encryption algorithm, generating ciphertext that can only be read if decrypted. For technical reasons, an encryption scheme usually uses a pseudo-random encryption key generated by an algorithm. An authorized recipient can easily decrypt the message with the key provided by the originator to recipients, but not to unauthorized interceptors.

Encryption

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

VPN with SQL Cluster data &amp; CIFS Data with encryption using Windows 7 and Windows 2088

VPN with SQL Cluster data & CIFS Data with encryption using Windows 7 and Windows 2088