Hi All,
I was trying to enable the Encryption with SQL Server. This was an extra thing that we are trying to do for an application which is Client-Server Based (IIS as WebServer & SQL Server 2005 Express as DatabaseServer). I am detailing the process
that I followed the the same. As per theory, this should work if we do the settings mentioned below. But, I'm getting some error message while connecting from SQL Server Management studio with encryption enabled.
The error message is - "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.)"
Step 1 - Create & Install Certificate (Tried in both Win 2003 & Win 7)
Installed OpenSS ...
Go to the complete details ...