Connecting to SQLExpress

[Dave Miller]

How can I create a Data Source to SQLExpress?
I opened up SQLExpress to TCP/IP, should I be using named pipes instead?
I show the service running and I can create an ODBC DSN to it.
However, I want a Native Connection. SQLExpress has a "SQL Native Client" and
I can also create an ODBC connection to it as well.

I receive the following error:
Connection verification failed for data source: TestDB
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.

[rjsimonson]

I'm having the same issues as well and have followed many different solutions. I have found none. If you get answers or figure it out please let me know. I will return the favor.

[Dave Miller]

HI,
Here is how I did it.

(1) Go into SQL Server Configuration Manager: SQL Server 2005 Network
Configuration -> Protocols fro SQLEXPRESS -> TCP/IP -> Properties -> IP
Addresses -> IP 127.0.0.1 set the port to 1433.
You need to activate TCP/IP as well

(2) In the ColdFusion Datasources specify SQL Server, and specify the server
as 127.0.0.1\SQLEXPRESS.

[mpwoodward *TMM*]

Dave Miller wrote:

> HI,
> Here is how I did it.
>
> (1) Go into SQL Server Configuration Manager: SQL Server 2005 Network
> Configuration -> Protocols fro SQLEXPRESS -> TCP/IP -> Properties -> IP
> Addresses -> IP 127.0.0.1 set the port to 1433.
> You need to activate TCP/IP as well
>
> (2) In the ColdFusion Datasources specify SQL Server, and specify the server
> as 127.0.0.1\SQLEXPRESS.
>

Some additional info:
[url]http://mattwoodward.com/blog/index.cfm?commentID=211[/url]

In the comments you'll see a trackback to some further info with screen
shots. I personally didn't have to specify the instance name after the
IP address; I just used localhost and it worked for me.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[rjsimonson]

Thanks that did it. :)

[rjsimonson]

I get the following error in Coldfusion MX Admin any ideas?

Connection verification failed for data source: ULD
[]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.

[karma007]

OK rj

This is an alternative method for those of us who have CFMX6.1, whose support
for JDBC does not work; instead of downgrading to CFMX6, you can create an ODBC
System DSN; here goes:

1) Carry out the instructions that Matt Woodward posted at the top of this
thread ie Go into SQL Server Configuration Manager: SQL Server 2005 Network
Configuration -> Protocols fro SQLEXPRESS -> TCP/IP -> Properties -> IP
Addresses -> IP 127.0.0.1 set the port to 1433.You need to activate TCP/IP as
well. Also make sure that SQL Server 2005 Express is an exception in Windows
Firewall (XP SP2) or any other firewall software

2) Go to Control Panel -> Administrative Tools -> Data Sources (ODBC) ->
System DSN -> Add :
a) Select SQL Server driver; finish
b) Type in a name for your datasource
c) Select an SQL Server ie the name of your server instance; next
d) Select your authentication set-up; next
e) Check the 'change the default database to' whatever database you are trying
to connect to; next
f) No need to change anything in the next panel
g) Finish

3) Then go to your Coldfusion Administrator data sources area & type in the
name of the CF DSN you want to use & choose driver of 'ODBC socket' type from
the drop down below; press 'add'.
You should be able to choose the system DSN, you have just created from the
drop down, entitled 'ODBC DSN'.
Then press 'submit'. Voila!