> 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.
In CF 5, you could use trusted connections via Windows authentication to talk to SQL Server. In CF MX, you can't do that; your SQL Server will need to allow "native" SQL logins (usernames and passwords) and you'll have to put them in your datasource configuration or within USERNAME and PASSWORD attributes of CFQUERY. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
