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.
Karloi'm no expert with sql server. but i am pritty good with using Windows networking. i think in this case you might wanna check out IPSec deployment. it would be the most secure option. the Windows 2003 site has alot of docs on ipsec. also to some extent i think ssl might work too but i'm not sure|||
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.
No comments:
Post a Comment