Solved

Urgent help needed - Cold Fusion Cold Fusion Admin - Data Source - to SQL Server 2005 named instance

Posted on 2010-08-25
6
748 Views
Last Modified: 2013-12-24
I get the following error when connecting to SQL Server from Cold Fusion Admin - Data Source -


Connection verification failed for data source: mmsi_update
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
0
Comment
Question by:dteshome
[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
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:erikTsomik
ID: 33523197
make sure that the datasource exist. And you can test the connection. To test that log into the cfAdmin and go to datasource and click on the test connection
0
 
LVL 4

Accepted Solution

by:
JohnHowlett earned 500 total points
ID: 33523230
Just a quick suggestion to double check the port number for the instance / datasource.

http://decipherinfosys.wordpress.com/2008/01/02/finding-the-port-number-for-a-particular-sql-server-instance/
0
 

Author Comment

by:dteshome
ID: 33523356

* Yes the Data Source exists
* Yes, the error I am getting is when I do a verify on the DS
* SQl Server is using the default port 1422 and the DS states that

Any help will be appreciated
0
Three Considerations for Containers

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read our article on Experts Exchange.

 

Author Comment

by:dteshome
ID: 33523364
CORRECTION!

PLEASE READ 1422 AS 1433 - IT WAS A TYPO

* SQl Server is using the default port 1433 and the DS states that

Any help will be appreciated
0
 
LVL 19

Expert Comment

by:erikTsomik
ID: 33523827
try recreating the datasource . amke sure you can test the connection inide the CFAdmin
0
 

Author Comment

by:dteshome
ID: 33524349
Thank you, everyone.  It turned out that the DS in  Cold Fusion was using the wrong port.  Once I figured out what port SQL was listening on and changed that it worked - I also had to use the IP of the SQL server the instance is running on, does not work with FQDM  only.  

JohnHowlett, thanks for the link, it was very helpful!
0

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

Today, I was working on some optimization and spam-stopping techniques when I encountered Ben Nadel's post to reduce spam feature using Math (http://www.bennadel.com/blog/197-How-I-Stop-Spammers-On-My-ColdFusion-Blog.htm). While this method is not o…
What You Need to Know when Searching for a Webhost Provider
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

628 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