Read/write files on shared folder in cluster

[Al_Baker]

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?

[Newsgroup_User]

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 drives.

What user does your ColdFusion servers run under. The default Windows
flavor of ColdFusion runs under a 'localSystem' user and this user
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 user that
has the write/delete permissions to the desired resources and this
assign this user to be the one ColdFusion runs under.

Again, for the Windows flavor, you change the 'logon' user of the
ColdFusion service in the Windows Services Panel.

Most likely the mappings you created where associated with your personal
account and is not available to the ColdFusion server. Mappings are
usually not neccessary and the prefered method is to just use an UNC
path of \\serverName\directory\file.ext once the necessary permissions
are assigned to ColdFusion.