1. The scheduled PEI-DB Transaction Log Backup failed to execute.

2. Logs indicated an error: Operating system error 5 (Access is denied.).

3. Neither the PEI-DB Database Backup nor the PEI-DB Transaction Log Backup could be initialized successfully.

The execution of the jobs "PEI-DB Transaction Log Backup" and "PEI-DB Database Backup" failed due to the inability to access to the backup folder. The error message specified "Operating system error 5 (Access is denied.)", indicating a permissions issue. The database backup process encountered a permissions issue, preventing access to the specified network share folder. 

1. Product: VESTA Analytics.

2. Affected Jobs: PEI-DB Database Backup and PEI-DB Transaction Log Backup.

3. Backup Location: Network shared folder.

Troubleshooting Steps

Step 1: View Job History in SQL Server Management Studio (SSMS) -- Reference KB0033136 

1. Open SSMS and Connect:
- Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.

2. Navigate to SQL Server Agent Jobs:
- Navigate to SQL Server Agent -> Jobs.

3. Locate the Jobs:
- Find the job named "PEI-DB Database Backup."
- Find the job named "PEI-DB Transaction Log Backup."

4. View Job History:
- Right-click on one of the jobs and select View History.
- In the Job History window, observe the list of job executions. Look for the most recent failure, which will be indicated by a red X.
- Click on the failed job execution to see more detailed information about what went wrong during Step 1.

Step 2: Verify SQL Server Service Account

1. Open SQL Server Configuration Manager:

2. Navigate to SQL Server Services:
- In the left pane, expand the SQL Server Services node.

3. Identify SQL Server Service:
- Locate the SQL Server service for your instance (e.g., SQL Server (MSSQLSERVER) for the default instance).

4. Find the Service Account:
- Right-click on the SQL Server service and select Properties.
- In the Log On tab, note the account under which the SQL Server service is running. This may be a built-in account like Local System, Network Service, or a specific domain account.

example Result/Current Status:

• The service is currently using a built-in account like Local System.
• Account name and password are used. 

Step 3: Ensure Access to Network Share

1. Network Share Permissions:
- The analytics server needs access to \\192.168.168.227\backups\ using either the Local System account or configured account.
- Ensure the shared folder \\192.168.168.227\backups\ has "Read/Write" permissions for the current configured user.

2. Update Permissions:
- Connect to the portal via 192.168.168.227:5000.

- Log into NAS:
    UN: Administrator           VESTAADMIN
    PW: P@33word!               P@33word!
- On the portal, connect to the server and modify access permissions so that the configured account can gain access to the folder.

3. Verify Access:
- Check if the permissions have been correctly applied and access is permitted.

Step 4: Test the Backup Jobs

1. Run the Backup Jobs:
- Return to the database and start the jobs on both PEI-DB Database Backup and PEI-DB Transaction Log Backup.

2. Verify Success:
- Ensure both jobs run successfully without errors.

3. The SQL logs and job history were reviewed to ensure no further errors were present.

Conclusion 

After updating the permissions, both the "PEI-DB Database Backup" and "PEI-DB Transaction Log Backup" jobs executed successfully. The issue has been resolved.