"The logon account that was provided does not have the appropriate privileges to back up the SQL database" appears when attempting a test run job, or while running Resource Credential Test for SharePoint 2007/SharePoint 2010 resources

Article:TECH136779  |  Created: 2010-01-20  |  Updated: 2012-02-03  |  Article URL http://www.symantec.com/docs/TECH136779
Article Type
Technical Solution


Issue



"The logon account that was provided does not have the appropriate privileges to back up the SQL database" appears when attempting a test run job/resource credentials test for SharePoint 2007/SharePoint 2010 resources.


Error



The job failed with the following error: "The logon account that was provided does not have the appropriate privileges to back up the SQL database . Either assign the appropriate privileges to this logon account, or use another logon account", or while running resource credential test it says "The logon account that was provided does not have the appropriate privileges to back up the SQL database on SQL server.


Cause



The domain user account that was provided might not have appropriate privileges to backup the SharePoint server


Solution




 
When a domain user with local administrative rights attempts a test run job/resource credential test for SharePoint 2007/SharePoint 2010 resources, the job fails with the following message: "Status: UMI V-79-57344-39812 Error: e0009b84, The job failed with the following error: "The logon account that was provided does not have appropriate privileges to back up the SQL database. Either assign the appropriate privileges to this logon account, or use another logon account."
 

 
This error represents an expected behavior. The Backup Exec Agent for Microsoft SQL Server always checks for domain administrator rights during test run jobs. The account Backup Exec is using must have domain administrator rights for a test run job, even though the backup job may or may not require domain administrator rights.
 


Solution:

 
Ensure that the user account has domain administrator rights when creating a test run job for SharePoint 2007/SharePoint 2010 resources.
 


 

Supplemental Materials

SourceUMI
ValueV-79-57344-39812
Description

The logon account that was provided does not have appropriate privileges to back up the SQL database.


SourceETrack
Value1962335
Description

SPP:TestRun Job Or while running  Resource Credential Test  of SharePoint 2007/SharePoint 2010 fails if a user is a domain user with local admin rights on SharePoint machine.



Legacy ID



357807


Article URL http://www.symantec.com/docs/TECH136779


Terms of use for this information are found in Legal Notices