ColdFusion Administrator - Secure DNS

[CTR]

We have a webserver connected to an old database. The old database server is end of life. When we set that up we did not need a secure connection. Now we have a new database on a new database server. Our IT department is requiring this to be a secure connection (even though it's an intranet).

Using ColdFusion Administrator I tried simply editing the URL of the server, but I get this error:
[highlight #FCE94F]Connection verification failed for data source: xxxxxxxx
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.[/highlight]

That's when I heard from my IT people that it needs to be a secure connection.

I have no idea how to do that, and Google didn't offer me any help, probably because I don't know what to search for.

Could one of you wonderful people please offer a suggestion on how to create a secure connection from ColdFusion Administrator 10 to MS SQL 2008?

Thank you

_____________

Cliff

 

[LyndonOHRC]

Start here:

http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WS70f0d54f063b9b08238ab6dc122b1a20785-8000.html

Here is an example CF 10 ssl connection string:
EncryptionMethod=SSL; TrustStore=path to keystore; TrustStorePassword=trustStorePassword; ValidateServerCertificate=true|false; HostNameInCertificate=host_name|#SERVERNAME#;

Find the example string here:

http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WS50260aa90e50c24b-32f8955c122c2720693-7fff.html

This should get you going...


Lyndon

 

[CTR]

Thank you!

_____________

Cliff