go to your "Client network Utility" (under your SQL Server program group). add the name of the database, and select TCP/IP as your connection library.
christopher olive, cto, vp of web development, vp security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:49 PM To: CF-Talk Subject: OT: SQL Server Login failed This is my first foray into working with CF and SQL Server. With the ISP's help, I've been able to connect to the remote site's SQL Server and copy the database to my local development box. I can read the tables, etc., locally, but I am now having trouble setting this up as a datasource in the ODBC manager of the Control Panel in Win2K. I keep getting an error "Not associated with a trusted SQL Server connection". Here's the error I get when I run the connectivity test: "Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxxxxx'. Reason: Not associated with a trusted SQL Server connection." I've confirmed the SQL login info for this database so it must be something else. Can anyone suggest where to go from here? I need to be able to hit the datasource from my ColdFusion app but it's not letting me login. TIA, Chris Montgomery (SQL Server newbie) ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
