• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 797
  • Last Modified:

SSL SQL Connection String

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
APD Toronto
Asked:
APD Toronto
  • 2
1 Solution
 
pateljituCommented:
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
 
APD TorontoAuthor Commented:
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
 
pateljituCommented:
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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now