> I haven't had much luck trying use the SQL Server Drivers > from CF. I think it has something to do with using trusted > connections. I'm not sure how to set up SQL Server to accept > logins via a username and password. I have changed the default > account SQL Server is running under, and created a "login" > which I then try to use when connecting via CF, but the > connection always fails. I'm sure its something obvious > I'm missing, but I'm no SQL Guru :)
I don't think you'll be able to use trusted connections at all with CF MX. You'll need to set up SQL Server to allow "mixed mode" connections using either Windows authentication (which won't work with CF MX) or SQL Server usernames and passwords (which will work). To do this, open the SQL Server Enterprise Manager, right-click on the server entry, select "Properties", go to the "Security" tab, and make sure "SQL Server and Windows" is selected for authentication instead of "Windows only". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ 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
