For a deeper look at the windows permissiosn refer to the article DocLink: Sage Paperless Construction: Required Windows Permissions and review the Sage Paperless Construction Setup Guide, both linked below.
For error "Operating system error 3(The system cannot find the path specified.)"
Confirm the path to your local folder and correct this for the backup job.
- Start Sage Paperless Construction
- Login as a user with full admin rights.
- Select Administration and navigate to Job Poll Configuration.
- Select the job with Job Type of DB Maintenance (prior to 2021 deployment this was named DB Backup).
- Click Edit and correct the Path in the Parameters (in the top right corner). The default location is C:\Sage Paperless Construction\Database\SQL Backups.
Note: This must be a local path on the server where SQL resides. - Click OK.
- Click Run Now.
- Review the Log Viewer to watch for the task to be added to the queue and complete.
For error "Operating system error 5(Access denied.)"
Correct the Security permissions on your Sage Paperless Construction Database folder and .bak file.
- On the server open Windows Explorer.
- Navigate to the location of your Database folder. The default location is C:\Sage Paperless Construction\Database.
- Right-click and select Properties.
- Select Security.
- Click Edit.
- Add the user NT Service\MSSQL$SAGEPAPERLESS.
Note: This is the default user configured with the default installation and must have Full Control for the MDF, LDF and .bak. If your IT has set different permissions you will need to consult with them. This permission also needs to be set for the Database folder and the SQL Backups subfolder. - Click OK.
- Click OK.
- Start Sage Paperless Construction
- Login as a user with full admin rights.
- Select Administration and navigate to Job Poll Configuration.
- Select the job with Job Type of DB Backup.
- Click Run Now.
- Review the Log Viewer to watch for the task to be added to the queue and complete.
User does not have sufficient permissions.
Have your SQL administrator ensure that in Microsoft SQL Server Management Studio that the user paperless has sufficient permissions.
- Expand Security, Logins.
- Select paperless, right-click Properties
- Select Server Roles, ensure diskadmin, public, securityadmin and serveradmin are selected.
- Click OK.
DocLink: