| Author |
SQL 2005 Express backup device '\\.\tape0' failed to open.
|
|
| jerryonnet 2006-10-24, 6:28 pm |
| hi
When I use Network Service account to startup SQL Server. I can not use My
tape to backup database. I got error message backup device '\\.\tape0' failed
to open. Operating system error 5 Access is denied.
I known use LocalSystem to startup SQL Server can reslove this problem.
can i use Network Service to startup SQL Server and I can use Tape ?
thanks for any help
| |
| Roger Wolter[MSFT] 2006-10-24, 6:28 pm |
| Look in the security Windows event log on the system where the backup files
are and find out the user who is trying to log in and then grant that user
permissions on the backup. Depending on your domain settings, that may not
work in which case you either need to backup locally and use a domain user
to copy the back file or run SQL Express as a user who has the necessary
permissions.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"jerryonnet" < jerryonnet@discussio
ns.microsoft.com> wrote in message
news:CA479E38-6E23-4878-AEC2- 076D01260A5E@microso
ft.com...
> hi
> When I use Network Service account to startup SQL Server. I can not use My
> tape to backup database. I got error message backup device '\\.\tape0'
> failed
> to open. Operating system error 5 Access is denied.
>
> I known use LocalSystem to startup SQL Server can reslove this problem.
>
> can i use Network Service to startup SQL Server and I can use Tape ?
>
> thanks for any help
>
| |
| jerryonnet 2006-10-24, 6:28 pm |
| thank you, the problem is reslove.
I Join the Network Service to Backup Operator Group.
"Roger Wolter[MSFT]" wrote:
> Look in the security Windows event log on the system where the backup files
> are and find out the user who is trying to log in and then grant that user
> permissions on the backup. Depending on your domain settings, that may not
> work in which case you either need to backup locally and use a domain user
> to copy the back file or run SQL Express as a user who has the necessary
> permissions.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "jerryonnet" < jerryonnet@discussio
ns.microsoft.com> wrote in message
> news:CA479E38-6E23-4878-AEC2- 076D01260A5E@microso
ft.com...
>
>
>
|
|
|
|