Encryption of SQL Queries
Hi.
I am running SQL select queries over a network from a SQL Server to a mySQL server by creating a linked server.
I need data to be encrypted (nothing heavy), but some form of encryption over the network as it exits the firewall.
Any help appreciated.
Karlo
[268 byte] By [
KarloS] at [2008-2-28]
 Karlo S wrote: |
| Hi. I am running SQL select queries over a network from a SQL Server to a mySQL server by creating a linked server. I need data to be encrypted (nothing heavy), but some form of encryption over the network as it exits the firewall. Any help appreciated. Karlo |
|
Natively with SQL you can utilise certificates to achieve this, or indeed IPSec if your mySQL server supports it, and if both servers were SQL 2005 MS might suggest using HTTP endpoints.
However you mentioned firewalls, and I would recommend that you implement a firewall to firewall VPN between your network and the destination network containing the mySQL. This simpifies things greatly, and requires no config on either database server.
