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

From the description and the error message that you copied, the failure seems to be coming from the client (Pocket PC software).

It seems like you are indeed trying to connect to a SQL Server instance that requires encryption, it may be possible that the settings on that particular instance were changed but the service was not restarted.

I would also recommend asking on the SQL Server data access forum in case they have a better answer: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

|||

Thanks for the reply Raul, but the problem turned out to be a boolean in the registry on the machine running SQL Express. Here is the post in SQL Server Data Access forum that solved it.

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

Thanks to John for that post.

Jack