Are you authenticating using Windows trusted or by specifically passing in a sql server username and login? I had a similar problem and this was my savior. I believe the reason was that the JDBC drivers that the datasources are based on do not allow the "trusted" windows authentication option.
On 7/22/02 4:06 PM, "Brian Scandale" <[EMAIL PROTECTED]> wrote: > I just upgraded from CF5 to CFMX by Uninstalling CF5 and then Installing CFMX. > > For the last three hours I have been trying to re-establish datasource > connections to SQL server which is running on the same box without any luck. > > This is the error: > ------------------- > Connection verification failed for data source: cfusion_clientreg > []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to > connect, please check your username, password, URL, and other connectivity > info. > > > Any hints from anyone who has already done this? > > Thanks, > Brian > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
