ColdFusion SQL encrypted connection (in pipe)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DennBen - 18 Nov 2009 16:56 GMT

I am looking for documentation about what if any encryption support is
available for Coldfusion MSSQL datasource connections on the
ColdFusion server.

There is a setting in MSSQL that forces client applications to encrypt
data sent to it called ForceEncryption. There is also a checkbox
setting in ODBC configuration "Use strong encryption for data".

Is there an equivalent setting somewhere in Coldfusion that would
apply to MSSQL DSNs?

Reply to this Message

KKC - 21 Nov 2009 12:42 GMT

> I am looking for documentation about what if any encryption support is
> available for Coldfusion MSSQL datasource connections on the
[quoted text clipped - 6 lines]
> Is there an equivalent setting somewhere in Coldfusion that would
> apply to MSSQL DSNs?

Although I have not personally used it I have seen the setting in the
MSSQL JDBC drivers, a search on google brought this up

http://msdn.microsoft.com/en-us/data/cc325721.aspx

9. Question: Does the Microsoft JDBC Driver support Secure Sockets
Layer (SSL) encryption?
Answer: The Microsoft SQL Server 2005 JDBC Driver version 1.2 or later
supports Secure Sockets Layer (SSL) encryption. For more information,
see Using SSL Encryption.

You might want to try tinkering with that...

Hope that helps... good luck

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / November 2009

ColdFusion SQL encrypted connection (in pipe)