Issue implementing SSL authentication to use SQL force encryption

2013-12-05 Thread Gregory Grays

All,

I am having an issue when I add the suggested SSL connection string via 
adobe\Cold Fusion website (EncryptionMethod=SSL; TrustStore=path to 
keystore; TrustStorePassword=trustStorePassword; 
ValidateServerCertificate=true|false; HostNameInCertificate) and when I restart 
the Cold Fusion services or reboot the server the neo-databasesource file loses 
it's structure causing no access to the database unless I remove the connection 
string and cut of SQL force encryption. Anyone with any insight on this type of 
issue. Please advise? 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357308
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Issue implementing SSL authentication to use SQL force encryption

2013-12-05 Thread Dave Watts

 I am having an issue when I add the suggested SSL connection string via 
 adobe\Cold Fusion website
 (EncryptionMethod=SSL; TrustStore=path to keystore; 
 TrustStorePassword=trustStorePassword;
 ValidateServerCertificate=true|false; HostNameInCertificate) and when I 
 restart the Cold Fusion services or reboot
 the server the neo-databasesource file loses it's structure causing no access 
 to the database unless I remove the
 connection string and cut of SQL force encryption. Anyone with any insight on 
 this type of issue. Please advise?

It's not clear to me whether you're having the problem only after a
restart, or whether you were never able to connect to the database via
TLS/SSL at all. If it's the latter, have you added the SQL Server's
certificate chain to the CF keystore?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357309
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm