0
setting up datasource for MS SQL SERVER 2005 Express
Participant
,
/t5/coldfusion-discussions/setting-up-datasource-for-ms-sql-server-2005-express/td-p/181512
Jul 03, 2008
Jul 03, 2008
Copy link to clipboard
Copied
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.
TOPICS
Getting started
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advisor
,
/t5/coldfusion-discussions/setting-up-datasource-for-ms-sql-server-2005-express/m-p/181513#M16343
Jul 03, 2008
Jul 03, 2008
Copy link to clipboard
Copied
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...
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...
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Dax_Trajero
AUTHOR
Participant
,
LATEST
/t5/coldfusion-discussions/setting-up-datasource-for-ms-sql-server-2005-express/m-p/181514#M16344
Jul 03, 2008
Jul 03, 2008
Copy link to clipboard
Copied
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!
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!
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

