Skip to main content
A
Anonymous
May 3, 2011
Question

I am having trouble connecting CF9 to a MSSQL 2008 R2 datasource

  • May 3, 2011
  • 1 reply
  • 3082 views

Hey all,

I am having a bear of a time trying to connect CF9 with a datasource in administrator. I have checked firewall and port 1433 is open.

Here is the error I am getting.


Connection verification failed for data source: DHDataWeb 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

I am just pulling my hair out. I am using windows 7 and am setting up a full dev platform.

Any ideas?

Thanks

Didger

This topic has been closed for replies.

1 reply

Owainnorth
Owainnorth
Inspiring
May 3, 2011

What have you put into the settings in CFAdmin? That error seems to suggest quite clearly that you've requested an instance that simply isn't available.

Is the instance you're connecting to on a local server? Remote server? Listening on the default port? In you're connecting to a named instance it's not impossible that it's not open on port 1433, but on an alternative port. Can you telnet to port 1433 from the CF box? Is the instance actually running?

A
Adam Cameron.
Inspiring
May 3, 2011

Equally, from the CF box, can you connect the the DB using its native client tools, using exactly the same network settings (domain/IP & port) and login credentials?

--

Adam

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices