Situation: The client us running SQL 2008 R2 and failed to use SQL Backup. The event view shows this message:
Log Name: Application
Source: MSSQL$CRM
Date: 10/21/2018 10:45:03 PM
Event ID: 18204
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: SQLserver03
Description:
BackupDiskFile::CreateMedia: Backup device ‘\\backupnas\backups\SQLServer03.bak\SQLDATA\SQL_Backup\distribution_backup_201810212245.bak’ failed to create. Operating system error 5(Access is denied.).
Troubleshooting: this is permission issue. Please make sure the computer login account has full permissions to access \\backupnas\backups\SQLServer03.bak\SQLDATA. For a test, you can assign full permissions to everyone.
