Home Forums SQL Server 2005 Administering Encrypt connection to SQL Server 2005 RE: Encrypt connection to SQL Server 2005

  • February 8, 2010 at 5:29 am

    #1115400

    SSL is an https connection for a web page, using port 443 by default. in theory, i can go to your web page via https, but your web server goes to a different server for SQL data via the default of port 1443. so the data between your Web server and your SQL server is not encrypted. , but when the data is passed back to me via https SSL on the web connection, it is encrypted.

    The same thing for when you connect directly to the SQL Server via SSMS or your application or whatever...the traffic passed back and forth is not encrypted.

    That is the SQL specific info we were giving you, so you can easily force the traffic to and from the SQL server to be encrypted.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!