Summary
Procedure to configure Sharepoint users and permissions
Step By Step
Case 1: DC Windows 2012 Server, SharePoint 2013 and SQL Server 2012
DC and SharePoint 2013 with SQL 2012 on Windows 2012 (one node, standalone) permission configuration:
1. Create a new domain user: "(DC name)\spbkuser1" in the Active directory users and Computer window:
2. Add "(DC name)\spbkuser1" to the Administrator Group and SQL Group:
3. Start the "Central Administration" console, "Security > Manage the Farm Administrators Group" page and add "(DC name)\spbkuser1" to the Farm Administrators Group"
4. In the active directory users and Computers window, the user "(DC name)\spbkuser1"displays as a Member of the WSS_ADMIN_WPG group:
5. Start the SQL Server Management Studio console, add “(DC name)\spbkuser1” to the Login group, assign “sysadmin” role to “(DC name)\spbkuser1”. If various SQL instances are configured in SharePoint, the user must be manually added to all those SQL instances configured in the SharePoint farm:
6. Change "Catalogic CMAgent Service" account to “(DC name)\spbkuser1”:
7. Run Backup and Restore. DC and SharePoint 2013 with SQL Server 2012 on Windows
2012 (one node, standalone) permission configuration:
a. Within domain controller, create a new domain user: “(DC name)\spbkuser1” in the Active directory users and Computer window:
b. Within the SharePoint node, add “(DC name)\spbkuser1” to the Local Admin group
c. Within the SharePoint node, start the Central Administration console, security page, add “(DC name)\spbkuser1” to the Farm Administrators group:
d. Within SQL Server, start SQL management console, add “(DC name)\spbkuser1” to the Login group, assign the “sysadmin” role to “(DC name)\spbkuser1”. If various SQL instances are configured in SharePoint, the user must manually be added to all those SQL instances configured in the SharePoint farm:
e. Within the SharePoint control node, change the CMAgent Service account to
“(DC name)\spbkuser1”:
f. Test Sharepint browsing, backup, restore, etc.
Case 2: DC – Windows 2008 R2 Servers, SharePoint 2010 and
SQL Server 2008 R2
1. Within the domain controller, create a new domain user: “avg\spbkuser1” in the Active directory users and Computers window:
2. Within the Sharepoint node add "avg\spbackup1" to the local Admin group:
3. Within the SharePoint node start the Central Administration console, security page, add "avg\spbkup1" to the Farm Administration Group
4. Within SQL server, start the SQL Server Management Studio console, add “avg\spbkuser1” to the Login group, assign “sysadmin” role to “avg\spbkuser1”. If various SQL instances are configured in SharePoint, the user must manually be added to all those SQL instances configured in the SharePoint farm
5. Within the SharePoinbt control node, chnage the CMAgent Service account to the "avg\spbkuser1"
6. Test SharePoint browsing, backup, restore