bcp giving error "Encryption not supported on the client"

[vikram k]

I have SQL serve 2005 running on Win Server 2003 machine. To that, I am issuing a bcp command from my machine which is Win XP SP3. I get the error:

SQLState = 08001, NativeError = 21
Error = [Microsoft][SQL Native Client]Encryption not supported on the client.
SQLState = 08001, NativeError = 21
Error = [Microsoft][SQL Native Client]Client unable to establish connection
SQLState = 08001, NativeError = 0
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.


I tried to look for the solution, but ppl have got this error mostly while trying to install the server and not in bcp.

Any help greatly appreciated.

Thanks
Vikram

[Vikram K]

Found this link related to the error.

http://social.msdn.microsoft.com/For...c-0fa023b3295c

Even though they were not getting this error with bcp, their problem was resolved by adding the values to the registery. It worked for me like a charm.