Solved

SSL SQL Connection String

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

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now