Solved

SSL SQL Connection String

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
Examines three attack vectors, specifically, the different types of malware used in malicious attacks, web application attacks, and finally, network based attacks.  Concludes by examining the means of securing and protecting critical systems and inf…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 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