Encrypt data on connection to DB

[shirleyj]

Hi,
I'm implementing EA for one of our clients, and I'm trying to set a connection to a model whose located on SQL server.
Because the info On the model is of top importance and confidential, I was ordered to encrypt the connection to the db.
When setting the new connection to SQL db on the 'Data Link Properties' window, I go to the 'All' tab and there , appears a property named  'Use Encryption for data'. I set it to 'TRUE'.
After clicking OK, the station tries to connect to the DB, and then pops out a window, the requires a password.
This window appears only when setting the encryption property on.
I have no idea what pass I'm supposed to enter, I tried entering all the pass. I know, but no success setting the connection this way.
Please someone advise,  I need to find a way to encrypt the data so it would be safe.

[Angel Catala]

Sometimes it is a right solution use SSH to create a encrypted tunnel between a client machine and a server (or a network). After that, you can trust the tunnel.

Of course, you could also use VPN, but this solution requires a little more infrastructure.