Backup device '\\.\Tape0' failed to open. Operating system error 5(Access is denied.).

  • Hi everyone.

    Im running into an issue trying to configure my new LTO drive inside SQL.

    I've verified that the tape drive is functional using the HP tools, but all of the resources I can find list fixing this issue by granting the service account access when the target is a file not a tape drive.

    Where do i need to grant the service account access so it can use the physical device?

    Any help is greatly appreciated!

    Thanks,

    Josh

  • Usually you need a system level account. Can you post the OS error and service account permissions?

  • There can be more than one reason for this error, ie. wrong path specified, insufficient permissions, destination marked read only or not enough space at the destination.

    😎

  • I went ahead and changed the service account to a domain account which resolved the issue.

    Thanks for the idea!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply