Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am using coldfusion 9 and SQL Server 2008 R2. It is set up as sqlexpress When I try to add a data source (sql) I get this error:

Connection verification failed for data source: test_cursor
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.

Any ideas?

share|improve this question

1 Answer 1

If you are accessing SQL Server Express remotely, ensure that the TCP/IP protocol has been enabled by using the "SQL Server Configuration Manager", which is in the "Configuration Tools" folder.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.