Skip to main content
Participating Frequently
December 10, 2014
Question

CF 11: Configuration a datasources to MS SQL Backend with encryption enforced by SQL Server

  • December 10, 2014
  • 1 reply
  • 3154 views

Hello List;

I have the following problem: Configuration a datasources to MS SQL Backend with option encryption enforced (by SQL Server).

I goggled in the internet for the configuration of the datasource and find multiple articles/advices:

Configuration a datasource type other with jtds.jdbc.Driver and manual configuration of the connection string:

1. Downloading the driver and copy to the cfusion/lib directory: Done, the driver was recognized by coldfusion after a restart of the service.

2. Copying the ntlmauth.dll to the bin directory of jre/bin: Done

3. Configuration of the jdbc URL: jdbc:jtds:sqlserver://xxxx.xxx.xxx.net:1433/db: Works, I don’t  get a connection timeout

4. User and PW: Works: I don’T get a login failure.

5. Advanced settings: Connection String: Maybe here is something wrong: EncryptionMethod=SSL; TrustStore=Path\sqlstore.jks; TrustStorePassword=xxx; ValidateServerCertificate=true; HostNameInCertificate=xxx.xxx.xxx.net;


Error Message (Coldfusion logs/stack trace):  I/O Error: DB server closed connection. SQLException while attempting to connect: java.sql.SQLException: I/O Error: DB server closed connection..

Has anybody experiences with this topic/can give me advices/send me screenshots.


frank

This topic has been closed for replies.

1 reply

Inspiring
December 16, 2014

We just went through the same process.  All you need is to add is EncryptionMethod=SSL ValidateServerCertificate=false; to the connection string field in Advanced Settings.

Participating Frequently
December 16, 2014

Hi Stephen;

Thank's a lot.

We will try.

Would be wonderful,if the solution is so easy!!

frank