Ken Ketsdever said: > > I am now trying to move it to the new server, Windows 2003, IIS 6, > ColdFusion 7.x Enterprise. I cannot get the DSN to work. I have > created a user for the ColdFusion Instance service, given it local > admin rights on the box coldfusion sits on and provided it with > modify rights to the folder on the other server where the DB > resides. > > I have two questions: > > #1. Here is the error message I get in the Coldfusion Administrator > when I try to verify the DSN. Does anyone have any ideas of where I > am going wrong?
If you are using the ODBC bridge, you need to give the ODBC Service permissions on the database, not the CF Service. > #2. When creating a windows user account to be used with the > ColdFusion service what rights does that user account need? I > believe that > ColdFusion uses the Local System account by default. "Log on as a Service", Change on the CF / JRun installation dir, RX on the webroot (more if you want to write files too). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239173 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54