I have a small cluster of servers with two running ColdFusion
and two others running SQL. It turns out that SQL doesn't do a good
job of deleting old backups so I want to write a scheduled task
that will weekly delete all files on a folder on each SQL server
that are older than 32 days.
I marked the folders as shared on the DB servers with
administrative and system permissions for R/W and mapped them to
drives on the server running ColdFusion.
But when I run the scheduled task, it gets a connection
failure. My guess is that the <cfdirectory> and
<cffile> tags (which do work on this instance of CF) are
unable to access the shared folders on the mapped drives.
How do I set the permissions for this to work? Or, is there
another way to gain R/W access to folders on the SQL servers so
that I can control them using CF on one of the web servers?
Al Baker wrote:
> But when I run the scheduled task, it gets a connection
failure. My guess is
> that the <cfdirectory> and <cffile> tags
(which do work on this instance of CF)
> are unable to access the shared folders on the mapped
What user does your ColdFusion servers run under. The default
flavor of ColdFusion runs under a 'localSystem' user and this
usually does not have any permissions to write to resources
not on the
local server system. You just need to create or use a domain
has the write/delete permissions to the desired resources and
assign this user to be the one ColdFusion runs under.
Again, for the Windows flavor, you change the 'logon' user of
ColdFusion service in the Windows Services Panel.
Most likely the mappings you created where associated with
account and is not available to the ColdFusion server.
usually not neccessary and the prefered method is to just use
path of \\serverName\directory\file.ext once the necessary
are assigned to ColdFusion.