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

[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

 

[Kay-Christian Wessel]

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

 

[nobody]

Hi,

See this site http://www.udaparts.com/document/articles/dialupdb.htm

With help of SocketPro, you are able to directly access a remote database
with SSL/TLS certificate from a smart device.

Cheers

 

[Kay-Christian Wessel]

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