Question
setting up datasource for MS SQL SERVER 2005 Express
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.
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.
AdChoices