Permissions problem - Warning 200

• 
  Does the SQL Backup Agent service startup account have rights to read and write to the "f:\db\backup\" folder?
  
  What is the result when you run the following:
  

  EXEC master..sqbutility 999, 'RWE', 'f:\db\backup\'
  

  petey May 04, 2011 21:59

  - 0 +
• 
  Two scenarios -- when I explicitly grant the startup account full rights to the backup folder, I get:
  
  <SQBUTILITYRESULT>:1:
  
  When I grant full rights to the group "sql users" and add the startup account to that group, I get:
  
  <SQBUTILITYRESULT>:0:Insufficient rights to read folder : The operation completed successfully. Insufficient rights to create files : Cannot create file "f:\db\backup\sql backup test 20110505110029228.txt". Access is denied.
  
  
  It appears my group level permissions aren't persisting through to the startup account ...

  DanMoran May 05, 2011 14:04

  - 0 +
• 
  When permission was explicitly granted to the startup account, were you able to run a backup successfully?
  
  Thanks.

  petey May 05, 2011 20:44

  - 0 +
• 
  I have a similar issue. When I run the sqbutility command this is the output.
  
  <SQBUTILITYRESULT>:0:Insufficient rights to read folder : The operation completed successfully. Insufficient rights to create files : Cannot create file "\\NAS\<share>\not displayed for security purposes". Access is denied.
  
  I have verified with out network administrators that the service account has full control permissions to the destination.
  
  Thanks,
  Greg

  AtoxGreg December 14, 2011 17:01

  - 0 +
• 
  A simple test is to grant 'Everyone' full read-write access to that network share, and run the test. If SQL Backup is able to access that folder, then it's still a permissions issue on that share in relation to the SQL Backup Agent service account.

  petey December 15, 2011 01:15

  - 0 +

Add comment

Please sign in to leave a comment.