encrypting connections to sql server 2005

can you please tell me how can i encrypt data sent between client application and sql server 2005.Hi,

thats quite easy, you can do this on the protocol layer:

http://support.microsoft.com/kb/316898/en-us

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||can i not enable encryption without installing any certificate?|||

No, a certificate is needed in order to use SSL. I am including additional links that may be useful.

· Encrypting Connections to SQL Server http://msdn2.microsoft.com/en-us/library/ms189067.aspx

· SSL Certificates http://msdn2.microsoft.com/en-gb/library/aa364691.aspx (This one makes reference to SSL for HTTP connections, but the main explanation and description of how SSL uses certificates are common)

· Configuring Certificate for Use by SSL http://msdn2.microsoft.com/en-us/library/ms186362.aspx

I hope this information will be useful.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Hi,

there is no must to buy a public trusted certificate if you don′t need it somewhere outside your company and that fits your secuirty needs, you can also create a certificate on your own.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

sql