SSL on SQL 2005 Express

40 pts.
Tags:
SQL 2005
SSL
Windows Forms
Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Form application that call to the data store. Any assistance will be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Getting SQL to work over SSL is pretty tough. What’s the end result that you are trying to get?

If you enable SSL connections to the SQL Server then all connections will need to be made over SSL. SQL won’t accept any non-encrypted connections.

This <a href=”http://support.microsoft.com/kb/316898″>MSKB article </a>covers setting up SSL encryption for a SQL Server.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kevin Beaver
    Yeah, you have to ask yourself what you're trying to accomplish. I'd be willing to be that someone could get into your data at rest more easily than they could your data in transit. Check out the following two articles I wrote for some more thoughts on this: Securing data at rest vs. data in transit http://searchstorage.techtarget.com/tip/1,289483,sid5_gci1116263_mem1,00.html How insiders hack SQL databases with free tools and a little luck http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1316271_mem1,00.html Hope this helps!
    17,130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following