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

Posted on 2011-10-27
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.
Question by:dlabbadia01

    Author Comment

    Should be noted that "Force Encryption" is set to NO for this instance.

    Author Comment

    Sorry figured this out already.  My client was forcing encryption, not the server.  Problem resolved

    Accepted Solution

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    794 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