Webmaster Forum / ColdFusion / Getting Started / July 2008

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.