Carletto
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
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
Yes, set up all of your communications over SSL (using HTTPS protocol). Your hosting provider can help you with this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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.