Home > IT Answers > SQL Server > SSL on SQL 2005 Express
ETCGMan
35 pts.
 SSL on SQL 2005 Express
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.

Software/Hardware used:
ASKED: January 15, 2009  5:17 PM
UPDATED: January 29, 2009  9:14 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  January 16, 2009  10:30 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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!

Kevin Beaver
 11,040 pts.