Solved

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

Posted on 2010-08-25
6
720 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
  • 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
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Website URL redirection 10 75
code conversion assistance required 1 33
How to generate a JSON response in coldfusion 4 61
Create sub domain on windows dedicated server. 13 74
PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

821 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