> I have a SQL Server database and I want to make it accessible > to CF. I can connect successfully to the datasource in CFIDE > using the sa account, but I cannot do the same using a New > Login with SQL Server Authentication. The error I receive is > "Login failed for user 'theuser'" which is incidentally the > same error I receive when using an incorrect password. > > What permissions does a SQL Server 2005 Login need in order > for CF to use it to access a SQL Server database? Thanks in > advance. I'm using CF 7.0.2
I'll bet you actually have the incorrect password. There's nothing special you have to to create logins that you can use from CF. Try changing the password. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
