SQL Server 2008 running on Win2k3.
I am trying to connect to SQL locally on the Enterprise Manager on the machine but
I get this error:
“A Connection could not be established to local Reason: Encryption not supported in sql server
Connectionopne (prelogin(handshake)).”
Solution
We just need to uncheck the Encryption support in Client Network Utility.
Start-> run -> cliconfg -> Uncheck " Force protocol encryption "