on the server that is running my cfmx, I can make an odbc connection from windows to the other server that is running the sql server, test the datasource and all is well. the sql server is setup for mixed mode auth, and I am using a user/pass that I have and can verify.
Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. is now the error I am getting....some trusted server bs, that wasn't there just 12 hours ago before we made the changes!!!!!!!!!!!!!! so its like, nothing make sense. the cfmx server connects to other db's, the only diff is that the other sql servers are sql2000 not sql7 and of course, that they are on different machines. what in the heck could this possibly be? this is really making no effing sense!!!!!! oh, and no matter what dsn or datasource or user/pass combo I try nothing to that machine comes out ok, I get the same error regardless of the datasource name, etc...i have tried this from 2 production servers and 2 development machines, all to no avail....and the same error, the 2 dev servers have cfmx updater 2, the production servers have cfmx updater 1, so its not that either. any ideas? ...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: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:14 PM To: CF-Talk Subject: Re: HELP!!!! jrun-resources.xml 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
