Link to home
Start Free TrialLog in
Avatar of Carletto
CarlettoFlag for Italy

asked on

Encrypt MS sql traffic over the Internet

Hi to All of you,
I have the following configuration:
1) a virtual server (vps) running apache + php  on a cloud provider with a cms running on it,
2) a MS SQL server 2008 running inside my network.
The cms should perform queries to a DB on the MS sql server, all is working and port has correctly been opened on the firewall.
As you can imagine I would like to encrypt the traffic between both ends for the Ms-sql protocol.
Can you please tell me how to do that?
Thank you
Carlo
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Yes, set up all of your communications over SSL (using HTTPS protocol).  Your hosting provider can help you with this.
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Carletto

ASKER

Thank you both,
Dave , I will implement on a test enviroment and let you know .
will ssl work on the tcp port 1433 as well ?

Bye
CArlo
Yes, it can but I would suggest using a different port.