Connection to SQL Server 2005 with encryption from a CF 2.0 device.

  • Thread starter Thread starter Kay-Christian Wessel
  • Start date Start date
K

Kay-Christian Wessel

Is it possible to make a connection from the CF 2.0 using the SQLClient to a
SQL Server 2005 where encryption is enabled and a SSL certificate is
installed ?

If so, which versions of SQL Server 2005 supports this ?

Do I need a special SSL certificate to do this ?

Kay
 
I've tried to use the following in my connectionstring :

Encrypt=Yes;TrustServerCertificate=Yes

It fails and says :

Unknown connection option in connection string: encrypt.


So, I guess it is not possible then.

The only safe way to connect to a SQL Server 2005 through the internet must
be to use a webservice using SSL, exposing the stored procedures there, or
using VPN ?

Or any other way ?

Kay
 
This component looks promising. I will test it.

Anyone using this component with some user experience ?

I don't understand why Micosoft disabled encryption for SQL servers in the
compact framework. This is the place were it is most important. Must be one
of the biggest security holes in the compact framework.

Why ?

Kay
 
Back
Top