I was creating sql backup via an ASP.NET application. On running the code written for creating backup I was getting the following exception:
Backup Failed for Server 'xxxxx' Operating system error 5: Access is denied
The error represents that we do not have permission to create backup at desired destination. But the question was to which account we should give permissions on the desired destination. To investigate that I went to Services >> SQL Server location:
From the above screen I was able to detect the account under which SQL server was running and it was "Network Service". SO the solution was to give write permissions to "Network Service" account. Below is the screenshot how to do that:
After giving the abover highlighted permissions my issue was fixed and was able to create the backup file via ASP.NET.