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
CarloAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray PaseurCommented:
Yes, set up all of your communications over SSL (using HTTPS protocol).  Your hosting provider can help you with this.
0
Dave BaldwinFixer 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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 ?

Bye
CArlo
0
Dave BaldwinFixer of ProblemsCommented:
Yes, it can but I would suggest using a different port.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.