> I'm trying to set up a datasource in the cf administrator. > > I'm on WinXP Pro with CF 6.1 and MSSQL 2000. > > Here's the error: > > Connection verification failed for data source: ventura > []java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver][SQLServer]Login failed for user 'vsw00\cf'. > Reason: Not associated with a trusted SQL Server connection. > The root cause was that: java.sql.SQLException: > [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed > for user 'vswsp200\cf'. Reason: Not associated with a trusted > SQL Server connection. > > I've tried lots of things ... set up a SQL Server group, > created a user CF and assigned that user to that group. In > Enterprise manager, I gave that user every conceivable > permission I could find.
You'll have to use native SQL logins, rather than Windows Authentication (which is what SQL Server uses by default. Within SQL Server's Security tab, enable both sorts of authentication. Then, create a native SQL login and password, make sure it has rights to the database in question, and use that within your datasource configuration within the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137772 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm