where does this TYPE IV driver come from where can I get it? or is it just the sql server driver that comes in the drop down?
thanks ...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:46 PM To: CF-Talk Subject: Re: HELP!!!! jrun-resources.xml I second Joachem -- use the Type IV driver -- not the ODBC/JDBC bridge. But that aside, if you're getting trusted server errors, it's all about permissions. Try sharing a drive using the sql admin account (domain admin is optimal) from the cfmx box to the sql server. That should create a trusted connection. I'd check to make sure that all the relevant services are still running as you originally had them -- that if you ran CF and SQL as named users, that the scripts on install didn't flip them back to LocalSystem for some crazy reason. Another thing you could check -- log onto the CFMX box as the account you're using to connect to SQLServer (assuming NTauth) or running the SQL Server service as (assuming standard auth) and make sure you can validate against the domain. Not a likely thing to have changed, but I've seen weirder. 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 12:26 PM Subject: RE: HELP!!!! jrun-resources.xml > 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 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
