Saturday, December 5, 2009

SQL error msg 20 state 16 Encryption not supported on SQL Server

SQL server 2000 client handshak not able to connect to server resulted in the following error :
[Microsoft][ODBC SQL Server Driver][Shared Memory]Encryption not supported on SQL Server
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
to overcome this problem for unknown reasons unForce protocol encryption under Client configration utilitiy ,by unchecking Force protocol encryption ,after that you should be able to connect to all your sql servers .

No comments:

Post a Comment