dteshome
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][SQLSer ver JDBC Driver]The requested instance is either invalid or not running.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLSer ver JDBC Driver]The requested instance is either invalid or not running.
Connection verification failed for data source: mmsi_update
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLSer
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLSer
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
try recreating the datasource . amke sure you can test the connection inide the CFAdmin
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!
JohnHowlett, thanks for the link, it was very helpful!