Make sure they defined a username and password for the connection in CF SETTINGS of the CFAdmin ODBC (OR OLEDB) interface.
-----Original Message----- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 16:54 To: CF-Talk Subject: first SQL server datasource on ISP Hi, I'm trying to get my first SQL server site up on Intermedia. I'm getting this error: OLEDB Error Code = 18456 Login failed for user '(null)'. None of my CFQUERY tags pass a login. On our staging server, where everything works, the database was created with Windows authentication, whereas the Intermedia database was created with SQL server authentication(as specified by Intermedia). What am I doing wrong? TIA, Doug Jordon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists