setting up datasource for MS SQL SERVER 2005 Express

[Dax_Trajero]

Can anyone offer me a little help

I have SQL 2005 Express Edition installed on the same machine as CF
I've been into it and enabled TCP/IP and NAMED PIPES
I've set TCP port to 1433
I've created a login account called CF and enabled both SQL and Windows authentication
I've created a database called coldfusionDB
I've set windows firewall to make an exception for that port

In CF Administrator I'm using the supplied Microsoft SQL driver. Can someone tell me what to put in the fields for the datasource ? I have the following:

Port = 1433
DATABASE = coldfusionDB
SERVER = DESKTOP\SQLEXPRESS

the Error I'm getting back from CF Administrator is:

* Connection verification failed for data source: cfclientstore
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.

[JR__Bob__Dobbs-qSBHQ2]

Try:

Server = localhost\sqlexpress
Database = coldfusionDB
Port = 1433

Also verify that the SQL server service has started.

These links may also help:
http://www.adobe.com/go/kb400255

http://www.mattwoodward.com/blog/index.cfm?event=showEntry&entryID=01930619-FD0A-4F02-31B1BFC7D1D9A4...

[Dax_Trajero]

server 127.0.0.1
database coldfusionDB

this did the trick - many thanks for your advice!

my client variables are working too!!! I'll never use MS Access 2007 again!