Error - SQL Server requires Encryption On

Hello All,

I have a commercial application built for Pocket PC's that connects to SQL Server 2005 via TCP/IP over wireless networks. In installations for our sales people we installed SQL 2005 Express on their notebooks for demonstrations. In one of these installs we are getting the following error message: "An error occurred - SQL Server requires Encryption On". We do not use encrypted connections and I have verified encryption is turned off in the Options tab in SQL 2005 login screens.

Here is the connection string we use in the app.config file on the Pocket PC's:
<add key="connStr" value="Data Source=192.168.0.19,1433;Initial Catalog=SQL0018;User ID = User01;Password=PW01"/>

Other apps on the notebook are connecting to this same SQL Server without any issues. Thank you in advance for any help here,

Jack

Hi Jack,

The registry key that controls this behaviour is below (assuming express is the first SQLServer you installed on the machine). If that key is set to 1, then set it to 0 and it should fix your problem.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\ForceEncryption

If it was set to 1, I am not sure how that came to pass. I also do not know where the gui component that manipulates this key resides, maybe someone can offer insight here.

Of course the real fun starts if it isn't set to 1.

I hope this helps!

John (MSFT)

|||http://msdn.microsoft.com/msdnmag/issues/01/06/sqlce/ fyi too.|||

Thank you John, that was it. I apologize for taking so long to respond but my sales person is in L.A. and I am in Florida and with the long weekend we couldnt connect until late yesterday.

Would love to know how that got set in the first place though. That was a tough one to find. Thanks again.

Jack