> 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' > You could do that, but I wouldn't recommend it; even though > you're not overly concerned about security, it's worth noting > that unless you trust everyone who has access to that > internal network, you're asking for trouble. You could create > an account which isn't a network administrator (or "Domain > Admin", I suppose), but that can connect to the SQL Server, > and make that account an administrator on the CF server > machine, and use that. 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. Thanks, Kay. ______________________________________________________________________ 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
