Are you using NTAuth or SQL auth to get in? As a quick test, create a datasource that uses the sa -- that verifies that SQL Auth is working correctly and the db is accessible. Then try connecting using NTAuth with whatever account you personally use to connect to the database (through things like Enterprise Manager or Query Analyzer).
That login "\" usually means something is messed up with NTAuth. Another quick check, you can do an admin-level share between the web server to the sql box using an account with sql permissions -- that will handle a bad set of credentials. Note that none of these are long-term solutions -- just ways to check/address the connectivity -- you want to isolate problem and of course fix it -- leaving CF connecting as SA can be bad news! Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 11:58 AM Subject: RE: HELP!!!! jrun-resources.xml > in my odbc connection, system dsn that I am setting up through windows > I am using my correct login info, not "\" as the username....WTF!!!! > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 11:56 AM > To: CF-Talk > Subject: RE: HELP!!!! jrun-resources.xml > > > excellent jochem, now here is what I get.... > > > Connection verification failed for data source: Platypus > []java.sql.SQLException: SQLException occurred in JDBCPool while > attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC > Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login > failed for user '\'.. > The root cause was that: java.sql.SQLException: SQLException occurred in > JDBCPool while attempting to connect: java.sql.SQLException: > [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server > Driver][SQL Server]Login failed for user '\'.. > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 11:48 AM > To: CF-Talk > Subject: Re: HELP!!!! jrun-resources.xml > > > Tony Weeg wrote: > > thanks dina, but this is now what im getting.... > > > > Connection verification failed for data source: platypus > > []java.sql.SQLException: SQLException occurred in JDBCPool while > > attempting to connect, please check your username, password, URL, and > > other connectivity info. > > The root cause was that: java.sql.SQLException: SQLException occurred > in > > JDBCPool while attempting to connect, please check your username, > > password, URL, and other connectivity info. > > http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full > > And if you get a 'cannot establish socket' error use telnet to verify > the SQL server is actually listening. > > Jochem > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
