Post reply

SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001]

  • December 1, 2010 at 11:49 am

    #241963

    The encryption flag on this server is set to NO. I have no certificates installed on the machine. Yet SQL Agent will no longer start because of this error. How can I disable all encryption on the SQL server?

  • December 1, 2010 at 1:25 pm

    #1257591

    have you tried setting the registry key:

    \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance_name>\SQLServerAgent\MsxEncryptChannelOptions(REG_DWORD)

    to '0' or '1'

  • November 17, 2011 at 10:07 pm

    #1409677

    Hi,

    I got the same problem---

    SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001]

    Solution--

    start -> programs -> Microsoft SQL Server 2008 -> Configuration Tools ->SQL Server Configuration Manager -> Expand SQL Server Network Configuration -> Right click on Protocols For MSSQLSERVER -> properties ->now make Force Encryption and Hide Instance both to 'NO' -> click OK ->restart the SQL Server(MSSQLSERVER) from services.msc -> now again go to SQL Server Configuration Manager ->Right click on SQL Native Client 10.0 Configuration -> properties -> now make Force Protocol Encryption and Trust Server Certificate both to 'NO' -> click OK -> restart the SQL Server(MSSQLSERVER) from services.msc ->now start your SQL Server Agent.

    Raghvendra Singh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply