This is known problem with using SQL and NT authentication. Create a SQL user and create it normally without using a ODBC socket. ----- Original Message ----- From: "Corey Yiap" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 2:02 PM Subject: newbie---SQL server help
> Can someone help me on adding Data Source in CF MX administrator section? > All my Access db are connecting fine, but my (local) SQL server would not > connect. I keep on getting this error: > Connection verification failed for data source: BHS > []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. > I added the new db in ODBC Data Source Administrator under System DSN and > the test connection is working properly. I don't know why CFMX could not > connect to it. Any help would be great. > Corey > > > > ______________________________________________________________________ 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 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
