Another thing to check is that if the trusted connection you have created the table from (for example your NT username) is different from the login name that CF logs onto to run as a service (prob not your username), you have to preface the tablename as such:
username.settings unless that account is DBO then dbo.settings - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -----Original Message----- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 6:33 PM To: CF-Talk Subject: RE: SQL Server Login failed 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) ______________________________________________________________________ Get Your Own 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=coldfusionb 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
