Solved

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

Posted on 2010-09-23
2
889 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___
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

738 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