Link to home
Create AccountLog in
Avatar of BHR
BHRFlag for United States of America

asked on

SQL 2005 permissions for tape drive

I have an AIT-3 tape drive that I have connected to a Windows 2003 server running SQL2005.  I can successfully backup to the tape drive using Windows backup.  I have set this tape drive up as a backup device within SQL 2005, however it isn't working.  When I try to go into the properties of the drive, it gives me the error:

===================================

System.Data.SqlClient.SqlError: Cannot open backup device 'AIT3(\\.\Tape0)'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteWithResultsAndMessages(String cmd, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSqlWithResults(Server server, String cmd)
   at Microsoft.SqlServer.Management.Smo.Restore.ReadMediaHeader(Server srv)
   at Microsoft.SqlServer.Management.SqlManagerUI.BakDevMediaContents.InitMediaInfo(Restore sqlRestore)
   at Microsoft.SqlServer.Management.SqlManagerUI.BakDevMediaContents.InitProp()


I have given every applicable user permissions to the drive under the Removable Storage area of Computer Management (I even tried giving everyone permissions to it) but still no luck.  Is there somewhere else I need to be checking permissions to the drive at?
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Avatar of BHR

ASKER

cs97jjm3
I created a backup device which backs up to a file, & everything works fine.  It is only the tape drive backup device that is giving me the permission errors.
ASKER CERTIFIED SOLUTION
Avatar of BHR
BHR
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account