Solved

SSL SQL Connection String

Posted on 2011-02-25
3
761 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 500 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Union 2 queries to a cte (temp table perhaps) 9 41
SQL Improvement  ( Speed) 14 33
Insert Button on a table 16 36
Display SQL 2008 last modified/update Database 11 8
The use of stolen credentials is a hot commodity this year allowing threat actors to move laterally within the network in order to avoid breach detection.
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.

808 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