> > Maybe it's an MDAC problem. You might download and install > > the latest MDAC, which is 2.7, from http://www.microsoft.com/mdac/. > > > Or, maybe you're not specifying the other information in the > > CF Administrator properly, though that seems unlikely. You > > might try writing a page with a CFQUERY, and running that; > > it'll give you a more detailed error message than the CF > > Administrator will. > > OK, I ran a test page with a CFQUERY and I'm getting: > > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
OK. At this point, I'd try the MDAC upgrade, personally. > So is the LocalSystem account the problem? If I change the > account, I'm assuming I need to change the application server, > RDS, Executive and Graphing services as well? If I create a > new user on the network, I'm not sure what permissions I should > give it to ensure that it can connect to the SQL Server. You should be able to connect with an SQL login - a username and password created within the SQL Enterprise Manager. That would be the ideal solution. If that doesn't work, and an MDAC upgrade doesn't work either, then you could create that new account. You'd only have to run the CF server within that account, and could leave the other services alone. As for connection permissions for the account, that's a good question. Typically, if you're going to use Windows accounts within SQL Server, you'd map them within the SQL Enterprise Manager. For what it's worth, I've never had to use a trusted connection to connect to SQL Server if I didn't want to - I've always been able to simply create an SQL login and use that. The only place I use trusted connections is on my own personal machine, because I'm running both CF and SQL on it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
