At 01:21 PM 7/22/02, you wrote: >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)
I have SQL Admin rights. I deleted the DSN that lives in the Windows/Control Panel/Datasources dialog. Then in the SLQ Administrator I clicked to allow both SLQ and Window Logins. Next I Explicitly made a username associated with the particular database and assigned a password. > and you'll have to >put them in your datasource configuration or within USERNAME and PASSWORD >attributes of CFQUERY. I have been attempting to get the datasource configuration module of the CFMX Administrator to accept my configuration settings I made in the SQL Administrator... Not sure what to try next. I expect I have something bassakwards seeing as how I'm not really SQL server savvy. >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
