Ran into this error message yesterday with SQL Server 2000.
If your box is SQL Server 2000, you need to check to see what authentication
it is using. SQL 2K uses NT authentication by default, and to use it for the
web, you have to enable Mixed authentication (NT & SQL Server). Mixed was the
default in previous versions.
There's an article in Microsoft's technet website with exact instructions on
how to do this.
"stas"
<stas@newdel. To: CF-Talk <[EMAIL PROTECTED]>
net> cc:
Subject: Connecting to the SQL server
remotely
07/25/01
12:09 PM
Please
respond to
cf-talk
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
- Connecting to the SQL server remotely stas
- Re: Connecting to the SQL server remotely stas
- RE: Connecting to the SQL server remotely Mark Warrick
- erica . vitina
