Ok, enabling trusted connections and entering the database's login info in the CF Administrator let me log in thru CF, but now I'm getting a SQL base table not found error:
"Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Settings'. SQL = "SELECT * FROM Settings" The table is there, I've viewed/edited it in Enterprise Manager. Any idea what could be causing this? The query seems pretty simple. Chris Montgomery [EMAIL PROTECTED] Web Development & Consulting, Software Sales http://www.astutia.com Macromedia Sales & Consulting Partner 210-490-3249/888-745-7603 Fax 210-490-3249 > -----Original Message----- > From: Chris Montgomery [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 27, 2002 1: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) ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
