-
Title
Permissions required to install StoragePoint -
Description
Permissions required for a proper StoragePoint installation. -
Resolution
Permissions required for Content Database
The service account used for installation purposes needs to have db_owner permissions for all SharePoint Content Databases.
Permissions required on File Shares
The service account used on all shared folders needs to have Full Control NTFS and Shared permissions, that will be used to configure Storage Endpoints and the System Cache.
Verify File Share and Content Database Permissions (OPTIONAL)When using the File Share adapter, an additional check may be seen when saving the profile:
This screen displays when editing an existing profile if:
·the Externalize Content BLOBs setting is Yes;
·there is at least one FileSystem endpoint;
·and the Web Application in the scope of the profile has at least one connected SharePoint (IIS Web) Service Application account that cannot access one of the FileSystem endpoints.
·The Web Application is connected (through proxy) to at least one service application, i.e. User Profile Service.
This screen displays when creating a NEW profile or copying a profile if:
·there is at least one FileSystem endpoint;
·The Web Application is connected (through proxy) to at least one service application, i.e. User Profile Service;
·All service accounts associated with profile web application do not have file system access permissions (Read, Write, Modify, Delete, DeleteSubdirectoriesAndFiles, CreateDirectories, CreateFiles) on all FileSystem endpoints AND “db_owner” role on all content databases associated with the profile.
When a new Content Database Profile is created, the associated web application pool account registered on SQL server will get two additional Database Role memberships:
·For SharePoint 2010, the web application pool account will get Public and db_owner.
·For SharePoint 2013 - SharePoint 2019, the web application pool account will get Public and SPDataAccess.
This check can be run manually by clicking the Check File share and Content Database Rights button beneath the list of endpoints on the profile.
Correct any permission issues before externalizing data. Use the Copy to Clipboard button to note which accounts need permission. The Storage Profiles page will be displayed with the newly-created storage profile showing up in the list.
