Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-08-25
6
Medium Priority
?
764 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 2000 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
Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

 

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

Cloud Training Guides

FREE GUIDES: In-depth and hand-crafted Linux, AWS, OpenStack, DevOps, Azure, and Cloud training guides created by Linux Academy instructors and the community.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

722 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