I have a SQL server here for development, and all the other datasources that the CF Admin are pointing to that reside on that server are coming back as good (Verify all Connections...ok) but one is throwing an error. I deleted it, and tried to reinstall the datasource, but I got the following error:
Connection verification failed for data source: JMH []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. I don't understand...*what* instance is either invalid or not running? The SQL Server is there, it's running, the database is there, it's okay, the tables are there, they have data in them...*other* tables are there and are working...where should I go next? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
