Forum Discussion
A connection was successfully established...error occurred during the login process
It is solved.
The values in the thumbprint of the certificate in "Protocols for MSSQLSERVER" of SQL Server Network Configuration must be the same that appears in the registry in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.<INSTANCENAME>{=html}\MSSQLServer\SuperSocketNetLib in the Certificate value.
Super UserHi David_54 ,
There is no unencrypt option. however, I am thinking that the problem is more likely what the message states - that the certificate has an issue. Have you confirmed that the certificate has not recently been changed/updated/modified/renewed? If you go to "options" in the Dataflow, does it look right on all of those to you?
It is solved.
The values in the thumbprint of the certificate in "Protocols for MSSQLSERVER" of SQL Server Network Configuration must be the same that appears in the registry in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.<INSTANCENAME>{=html}\MSSQLServer\SuperSocketNetLib in the Certificate value.