I am new with SQL Server.
A while ago I installed SQL Server 2016 in Windows 2012 R2. I set up the maintenance plans to do daily backups of the database and transaction logs.
Those maintenance plans worked just fine.
I recently decided I wanted to a text file of the backups to get created. so I modified each maintenance plan to send a report (.txt) to the "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log" folder.
I did this by modifying the maintenance plan and clicking the icon for Reporting and Logging. Then selecting the checkbox for "Generate a Text file report", select Create a new file, then specified the path above.
Each time the maintenance plan runs, I see an error in the history:
Access to the path 'C:\\Program Files\\Microsoft SQL Server\\MSSQL13.MSSQLSERVER\\MSSQL\\Log\\Backup DBs_Subplan_1_20200207170004.txt' is denied.
I tried changing the path to the same one the backups go to but still got the same error.
Why would it be able to write all other logs to the "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log" folder but not the backup reports?