asked on

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

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.

erikTsomik

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

ASKER CERTIFIED SOLUTION

JohnHowlett

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dteshome

ASKER

* 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

dteshome

ASKER

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

erikTsomik

try recreating the datasource . amke sure you can test the connection inide the CFAdmin

dteshome

ASKER

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!