8 Replies Latest reply: Oct 24, 2014 7:15 PM by ranger RSS

    Can't create datasource to SQL Server

    a440guy

      Hi Folks,

       

      I'm running ColdFusion 9 Trial Version (no hotfixes), SQL Express 2005, Windows XP SP3, IIS.

       

      Using ColdFusion Administrator, when I try to create a datasource to SQLExpress 2005 (SQL Server Express), using the SQL Server driver, I get the following error:

       

      Connection verification failed for data source: AMT
      java.sql.SQLException: [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]The requested instance is either invalid or not running.

       

      The "instance", which I take to mean the database instance, is "machinename\SQLExpress"  (This is a so-called "named instance".)  This is what I enter into the "Server" field of the form (Data & Services -> Datasources -> Microsoft SQL Server).

      On the other hand, I am able to create an ODBC datasource name in Windows using the Microsoft SQL Server Native Client Version 09.00.3042 driver and using the same instance, "machinename\SQLExpress".

       

      Does anybody have any ideas as to what's wrong?