Try setting up an ODBC connection with the Windows Control Panel first. If you can
connect to a remote SQL server that way it will work with ColdFusion as well.
In this case, the problem is that you've got is that the connection type set to
"Trusted Connection", which means you would have to be logged in to Windows as the
username/password combo that the remote server expects. Since ColdFusion normally
runs as a system account, it wouldn't be able to pass along the correct
username/password combo to the remote SQL server for authentication.
Also, the remote SQL server must be setup to allow SQL-based authentication.
---mark
========================================Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
========================================
-----Original Message-----
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 10:10 AM
To: CF-Talk
Subject: Connecting to the SQL server remotely
Hello,
I am trying to connect to my SQL box remotely - it works fine when the
server is sitting on a private (192.168.x.x) IP, but when I switch the box
to be visible on the net, I get a message ("not associated with a trusted
SQL connection...") when trying to register the server in the EM. Thanks for
any help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists