Yes, but CF probably isn't running under your logon account. It usually runs under some kind of system account that doesn't have access to network resources. You can use the same connection details but if the underlying account doesn't have access then the connection will fail.

This is my understanding of M$ Windows based systems anyway...

Brett
B)


Tim Donovan wrote:
yes thats the thing...with the same connection details I can connect
remotely using ODBC or enterprise manager with no problems at all.

"Brett Payne-Rhodes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]

Does the account that CF is running under have the right access

permissions?

B)

--
Brett Payne-Rhodes
Eaglehawk Computing
t: +61 (0)8 9371-0471
f: +61 (0)8 9371-0470
m: +61 (0)414 371 047
e: [EMAIL PROTECTED]
w: www.ehc.net.au

Tim Donovan wrote:

nah...no luck
I reinstalled from scratch (with the patch this time) and its still the

same

error.

Connection verification failed for data source: ReefStateDB
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error
establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer

JDBC

Driver]Error establishing socket. Connection refused: connect

I'll beers at MXDU for whoever can solve it :)

"Robin Hilliard" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]


Tim Donovan wrote:



Connection verification failed for data source: ReefStateDB
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error
establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer

JDBC


Driver]Error establishing socket. Connection refused: connect

Hi Tim,

Glad to hear you guys are still operating :-)  If you have access to
JRun you could add -verbose to the jvm.config, start the server from the
command line and see if there was any more exception info in the trace.
There were also a few SQL server specific patches to CFMX 6.1, assume
they're installed?

Cheers,
Robin
http://www.rocketboots.com.au







--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/



--
Brett Payne-Rhodes
Eaglehawk Computing
t: +61 (0)8 9371-0471
f: +61 (0)8 9371-0470
m: +61 (0)414 371 047
e: [EMAIL PROTECTED]
w: www.ehc.net.au

---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to