Query Question

[Dino Buljubasic]

Hi,

I am building an application that querries a remote server.

I am concerned about traffic sniffing and would like to know how can I
protect my querries issued by my application (written in VB.net) to
the server?

This includes server qeuries but also connection string that contains
username and password to connect to the server.

Thank you,
_dino_

 

[Mark Ashton]

With SqlServer you can use 'encrypt=true' in the connection string so that
all communication is encrypted.
With Sql Server 2005 there is a setting on the server that you can set would
require all clients to use encryption.

 

[Val Mazur \(MVP\)]

Hi Dino,

You could encrypt communication with SQL Server and also could use SSL.
Check next link with the description about what you need

http://msdn.microsoft.com/library/d...-us/dnnetsec/html/secnetlpMSDN.asp?frame=true