“Failed to write to local path from SQL server” when configuring the DLP Temporary Folder Location
- Article Number: 000012470
- Products: Data Security, Forcepoint DLP, TRITON AP-DATA
- Version: 8.7, 8.6, 8.5, 8.4, 8.3, 8.2, 8.1, 8.0, 7.8
- Last Published Date: September 16, 2020
Notes & Warnings
Note This is only relevant if SQL is located off-box and is not SQL Express.
While attempting to configure the Temporary File Location from the Forcepoint DLP installer, the system displays the error:
“Failed to write to local path "\\Path of backup folder" from SQL server”
This folder connection must be valid for incident partition management and DLP Backups and Restorations to be successful.
The temporary location shown in the screenshot under the From SQL Server section is the default folder where the Forcepoint Setup installer will place the archive file of the SQL database that will be transferred to the final location set in the Forcepoint Security Manager. The purpose of this location is to serve as a holding ground for SQL files between the Management Server and the SQL Server.
This folder needs to be accessible by the service account used by the SQL Server service, the account running the SQL services (MSSQL) on the server where SQL is installed. This account is often the local service or local system which might be limited by a Group Policy Object.
To isolate the issue, consider the following options:
The temporary location shown in the screenshot under the From Forcepoint (formerly known as TRITON) Management Server section should be the same folder as the first location. The Data Security Suite (DSS) service account will be used to access this location and move from the folder created in SQL server.
The following services will be used to complete the archiving/backup process:
Database Administrators should follow the Administering Databases Guide to ensure that permissions are set adhering to requirements.
Keywords: DSSBackup, Data DLP Backup; Backup Restore; SQL Server Issue; Management Server Issue; Service Account; SQL Database Permission; SQL Server Role; DB Configuration; DLP Upgrade Check; Pre-Upgrade; Server Migration; Temp Folder DLP MSI Modify; Archiving Archival Location; Temporary Folder;