SSL Provider RRS feed

  • Question

  • Hi all

    We are opening connection to a SQL 2005 server .  This connection was established and working for days and with no apparent changes to the firewall or SQL Server, we started to get the following exception.


    System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake.(provider: ssl ,error 0-the certificate chain was issued by an authority that is not trusted )(microsoft sql server)



    Has anyone run into this issue?


                                                                            Neeraj shukla

    • Edited by neeraj msrit Thursday, April 30, 2009 3:32 AM error msg has change now
    Tuesday, April 28, 2009 5:54 AM

All replies

  • Hi neeraj,

    In some scenarios, an application may use non-approved algorithms or processes while the application operates in a FIPS-compliant mode. For example, the use of non-approved algorithms may be allowed in the following scenarios:
    • Some internal processes stay within the computer.
    • Some external data is to be additionally encrypted by a FIPS-compliant implementation.

    For more details check the following URL: http://support.microsoft.com/kb/811833/


    Tarek Ghazali
    SQL Server MVP

    Tuesday, April 28, 2009 6:50 AM
  • Did you restart/failover the SQL server?
    Is the browser service still running?
    • Marked as answer by neeraj msrit Friday, May 1, 2009 8:54 PM
    • Unmarked as answer by neeraj msrit Wednesday, December 23, 2009 9:35 AM
    Wednesday, April 29, 2009 8:28 AM