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.

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.

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.

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.sql

Empty dialog box on startup of Management Studio Express

Hi,
Everytime I start Studio Express I get an empty dialog box. I've seen some
posts about a similar problem but they were linked to upgrades. I have not
upgraded SQLExpress so there must be something else that causes it.
The only thing that I have done recently was to delete few users from a
database and instance.
I'm using SQLExpress 2005.
Any ideas what could be happening and how to troubleshoot this?
ThanksHi
I would suggest removing and re-installing, but other posts say fixing .NET
Framework 2 .0 fixed it!
John
"bogdan" <bogdan@.company.com> wrote in message
news:OvOLTAplIHA.2396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Everytime I start Studio Express I get an empty dialog box. I've seen
> some posts about a similar problem but they were linked to upgrades. I
> have not upgraded SQLExpress so there must be something else that causes
> it.
> The only thing that I have done recently was to delete few users from a
> database and instance.
> I'm using SQLExpress 2005.
> Any ideas what could be happening and how to troubleshoot this?
> Thanks
>