Pre-requisites for the logon account used to backup Microsoft Office SharePoint Server MOSS 2007 / MOSS 2010.

Article:TECH75907  |  Created: 2009-01-23  |  Updated: 2013-08-26  |  Article URL http://www.symantec.com/docs/TECH75907
Article Type
Technical Solution


Issue



Pre-requisites for logon account for SharePoint backups and Backup Exec Service Account (BESA) to backup Microsoft Office SharePoint Server (MOSS) 2007 / MOSS 2010.


Solution



Following permissions and SQL Roles should be assigned to the Logon account for SharePoint and Backup Exec Service Account (BESA) to backup MOSS 2007.

1. Local Administrator on the WebServer and Database Server.

2. The account should be part Sharepoint Farm Administrators Group. To add the account to the Farm Administrators group please refer the document below.

   www.symantec.com/docs/TECH68711

3. The account should be "Site Collection Administrator" at the top-level site. To make the account a "Site Collection Administrator" refer the document below.

   www.symantec.com/docs/TECH70874

4. The account should have "db_owner" role on the Content databases. To provide "db_owner" role on the Sharepoint database refer the document below.

   www.symantec.com/docs/TECH66396

5. For disaster recovery it's recommended to backup the SQL instance, and the system databases along with the SharePoint DBs.

   www.symantec.com/docs/HOWTO24069

 

NOTE : Eventually only one account can be Site Collection Administrator [ Owner ] in Sharepoint . So, Locations might not prefer to change that account to BESA. Rather, add Site Collection Administrator in Backup Exec and then assign all the BESA privileges to that account and then accordingly add permissions on SQL server as well.


Supplemental Materials

SourceUMI
ValueV-79-40960-744
Description

Backup Exec cannot restore the security for Failed to set security on List item . Ensure that the logon account has the appropriate credentials, and then try again.



Legacy ID



336124


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


Terms of use for this information are found in Legal Notices