Solved

Setting up a ColdFusion 8 datasource with a SQL Server 2008 box using SSL

Posted on 2010-09-23
2
872 Views
Last Modified: 2013-12-24
Has anybody out there successfully set up a datasource in the coldfusion 8 administrator that connects to a sql server 2008 instance with SSL?

It's the SSL part that is turning out to be a problem. The SQL Server I'm trying to connect to must use ssl but I can not connect to it.

I have all the info for the SQL Server login I'm just not able to successfully create the datasource name in the CF Admin.

I tried using the native SQL Server driver and also using a JDBC driver jTDS.

Has anybody done this?
0
Comment
Question by:FastEddie___
2 Comments
 
LVL 15

Accepted Solution

by:
MohammedU earned 500 total points
ID: 33749929
Have you tried MS JDBC driver? if not try it..
Are you using windows or sql authentication to connect to sql?
0
 

Author Comment

by:FastEddie___
ID: 33754299
I'll try the MS JDBC driver today. I'm using SQL Server authentication for the connection.
I'm guessing it's kind of unusual to connect to a SQL Server via SSL.
There really isn't too much info about it online.
 
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now