Question:
I am trying to back up a database to a disk backup device over a network. When I attempt my backup, I encounter an error 5 ? Access denied. According to Microsoft, I need to have domain access rights. However, I seem to have full rights on all machines involved: my client, the server being backed up, and the server I am backing up to. Do you have any idea what I can do to fix this?
Answer:
Although you might have full rights, the ID that SQL Server is running under might not. Go to the services item in control panel and check who SQL Server is running under. In many cases it executes under the local system account. You can either change this to run under your account or, better yet, create an account just for this purpose.