?
Solved

The certificate chain was issued by an authority that is not trusted

Posted on 2011-10-27
3
Medium Priority
?
4,108 Views
Last Modified: 2012-05-12
I have a SQL 2008 server.  An application installs on remote machines and writes to this database.  I can successfully perform this installation on 3 of the 4 servers I need to, however on the 4th machine I receive the following error:

271011 17:33:14 ERRO: CheckDBCreation failed to create database. Error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

The SQL server has no certificates in it's personal computer folder to export and i don't even think it needs it.  I think the client thinks it's in a different network or smething and elevates security.  This is driving me nuts and is putting quite a bit of time sink into an overdue project.

Any suggestions?

P.S. I'm an admin, not a programmer.  i know a little SQL but not a ton.
0
Comment
Question by:dlabbadia01
  • 2
3 Comments
 

Author Comment

by:dlabbadia01
ID: 37040634
Should be noted that "Force Encryption" is set to NO for this instance.
0
 

Author Comment

by:dlabbadia01
ID: 37040952
Sorry figured this out already.  My client was forcing encryption, not the server.  Problem resolved
0
 

Accepted Solution

by:
EE_AutoDeleter earned 0 total points
ID: 37174032
Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.

EE_AutoDeleter
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

807 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