Post reply

How to Encrypt the communication between SQL Server and the Webserver. My Application uses SQL Server authentication to connect to MSSQL.

  • July 8, 2011 at 2:55 pm

    #240610

    How to Encrypt the communication between SQL Server and the Webserver??

    My Application uses SQL Server authentication to connect to MSSQL.

    Please let me know!

  • July 8, 2011 at 3:32 pm

    #1350670

    Best way would be using IPSec to encrypt the traffic between the nodes

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 8, 2011 at 7:30 pm

    #1350702

    i'm very eak on this, never implemented it, but i thought there was a "Force Encyption" property on the server that could do that; otherwise it's an optional client connection option, right?

    http://technet.microsoft.com/en-us/library/ms189067.aspx

    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!

  • July 9, 2011 at 1:26 am

    #1350712

    Lowell (7/8/2011)

    i'm very eak on this, never implemented it, but i thought there was a "Force Encyption" property on the server that could do that; otherwise it's an optional client connection option, right?

    http://technet.microsoft.com/en-us/library/ms189067.aspx

    The force encryption option is used when using SSL encryption. This is slow and requires you go spend a whole fist full of dollars on an SSL certificate (self signed are not recommended) from a trusted authority.

    IPSec is part of the windows OS and requires no SQL Server interraction, the encryption levels are more secure and offer better performance.

    This link[/u] provides an overview of IPSec

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply