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
Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Except that MS SQL Server doesn't use HTTP or HTTPS protocol.  It will use SSL: http://technet.microsoft.com/en-us/library/ms189067%28v=sql.100%29.aspx  However, the more important question is the driver that is available on the web server to connect with the SQL Server.  If you are running Linux, the 'php_mssql' driver is fairly crippled.  If you are running Redhat or CentOS, you can use the Microsoft PHP/SQL Driver for Linux.  http://msdn.microsoft.com/en-us/library/hh568451.aspx  If your VPS is on Windows, you can use the Microsoft PHP/SQL driver for Windows http://msdn.microsoft.com/en-us/library/jj730314.aspx or http://www.microsoft.com/en-us/download/details.aspx?id=20098
Ray PaseurCommented:
Yes, set up all of your communications over SSL (using HTTPS protocol).  Your hosting provider can help you with this.
CarloAuthor Commented:
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 ?

Dave BaldwinFixer of ProblemsCommented:
Yes, it can but I would suggest using a different port.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.