You can see this help file re configuring ODBC DSN's in the CFStudio
help........
Use Trusted Connection -- Allows SQL Server to authenticate on the user's
Windows NT login. You can use this option if the SQL Server database is
using an Integrated or Mixed security mode. Integrated security uses NT
authentication schemes for all connections. Only trusted connections are
allowed to connect to SQL Server. It's not necessary to populate the
ColdFusion username and password fields because SQL Server ignores these
values. Mixed security allows both trusted and nontrusted connections. If
the username and password are left blank, SQL Server will use NT domain
credentials. However, if you do pass a username and password, SQL Server
tries to authenticate using the passed information.
-----Original Message-----
From: Rob Sherman [mailto:[EMAIL PROTECTED]]
Sent: 17 August 2000 15:07
To: [EMAIL PROTECTED]
Subject: RE: Login Failed For User '/'
Try to go into the web server / cold fusion server's Control Panels, pop
open the ODBC control panel and manually edit the System DSN you created on
the SQL 7 server. I've had similar troubles trying to get the right odbc
settings through the Cold Fusion Administrator and this way you'll be able
to see additional settings and test the connection in the control panel.
Sincerely,
Rob Sherman
President
CFDude, Inc. http://www.cfdude.com
Allaire Certified Developer & Instructor
------------------------------------------------------
<Office> (310) 543-1622 <Fax> (310) 543-0512
<Email> [EMAIL PROTECTED] <ICQ> 3266081
<AIM> RobSSherm <Yahoo!> RobSherman_CFDev
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
