Solved

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

Posted on 2010-09-23
2
876 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In this article I will describe the Detach & Attach 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.
SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 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