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

  • February 6, 2010 at 1:56 pm

    #1115075

    river1 (2/6/2010)

    But there is no problem with encrypting a connection because it uses SQL Server authentication instead of windowns authentication, correct?

    Or i can only encrypt connection if they use windows authentication to connect to the server?

    Thank you.

    the encryption is for all the packets transferred to and from SQL Server, regardless of any authentication protocols or any other settings; so it's fast and cheap to just make the server require encryption.

    you cannot be selective and make only one authentication type require encryption; about hte only option might be that you could make an application always use encryption even if the server did not require encryption by default, by adding to the connection string.

    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!