Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSL SQL Connection String

Posted on 2011-02-25
3
Medium Priority
?
776 Views
Last Modified: 2012-05-11
Hello Experts,

I have a VPS that is fully managed by a third party hosting company, and I just had them install a SSL Certificate on the SQL 2008 server which resides on it. My question is how do I adjust my cinnection string that indicates that is a secured and encrypted SSL connection?

Online I found:

TrustedServerCertificate='true';

however, when I run this on my test server which have no SSL, it works also, but I would imagine that I should have received an error that says "No SSL installed", or something along those lines.

If the above is correct and if I should not get an error even though I have no SSL, then how can I tell if my connection is encrypted?
0
Comment
Question by:APD_Toronto
  • 2
3 Comments
 
LVL 15

Expert Comment

by:pateljitu
ID: 34983056
Encrypt=yes; option also needs to be connection string to transport data over SSL. Also try going through these articles would help

http://support.microsoft.com/kb/316898

http://www.sqlservermart.com/HowTo/MSSQL_Over_SSL.aspx

0
 

Author Comment

by:APD_Toronto
ID: 34988757
Hello,

Ok, I did include Encrypt=yes; and also left TrustedServerCertificate=true; , but ended up with

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

Secondly, when I use my local SQL Server Management Studio and place a check mark under “Encrypt Connection”, I get

"ERROR: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The requested name is valid and was found in the database, but it does not have the correct associated data being resolved for.)"

With a bit of a research I'm getting the feeling that I need to install something (I am not sure what) on the client computer (the computer that is trying to connect to the SQL Server)? Maybe the same SSL?

I have not installed an SSL before but  FYI the SSL is not self-signed, but rather purchased from GoDaddy.

Any ideas?
0
 
LVL 15

Accepted Solution

by:
pateljitu earned 2000 total points
ID: 34998253
You would need to install certificate on server:

Configuring SSL for SQL Server:
http://msdn.microsoft.com/en-us/library/ms189067.aspx

Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager):
http://msdn.microsoft.com/en-us/library/ms191192.aspx

Article explaining SSL:
http://blogs.msdn.com/b/jorgepc/archive/2008/02/19/enabling-certificates-for-ssl-connection-on-sql-server-2005-clustered-installation.aspx
0

Featured Post

New Tabletop Appliances Blow Competitors Away!

WatchGuard’s new T15, T35 and T55 tabletop UTMs provide the highest-performing security inspection in their class, allowing users at small offices, home offices and distributed enterprises to experience blazing-fast Internet speeds without sacrificing enterprise-grade security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Getting to know the threat landscape in which DDoS has evolved, and making the right choice to get ourselves geared up to defend against  DDoS attacks effectively. Get the necessary preparation works done and focus on Doing the First Things Right.
In this article, we’ll look at how to deploy ProxySQL.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question