question

Naren avatar image
Naren asked

Getting error by using SSL(Security Socket Layer) ?

Error: A connection was successfully established with the server, but then an error occurred during the pre-login hands. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"} System.Exception {System.Data.SqlClient.SqlException} DB Server – OS – Windows 2008 (VM) SQL – SQL SERVER 2008
sql-server-2008dba
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
You should provide more details about your environment. Have you just recently configure your server to accept encrypted connections? Have you followed the instructions provided in this article http://support.microsoft.com/default.aspx?scid=kb;EN-US;316898 Are you using self-signed certificates (by default with SQL server 2005/2008 if no appropriate certificate is provided)? You must know that If you want full client side forced SSL encryption to work properly with SQL Server, you need to configure a real SSL certificate that the client trusts. The self-signed certificate is only useful for encrypting login packets and is not fully trusted by the client since it does not have a trusted root authority
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.