I think the issue was by ths following , It's quite a common error with a variety of causes: start here with KB 811889 What version of SQL Server? And Windows on client and server? Local or network SQL instance? Domain or workgroup? Provider? Changing password Local windows log errors? Any other apps affected?
Compilable C++ code to implement a secure SLL/TLS client using MS SSPI