Granting Additional Rights for Specific Tasks
If you need to use the logon account to Microsoft SQL Server Analysis Services either to access a backup file or to work with the query log table in a specific Microsoft SQL Server database, there are additional rights that you must grant to the logon account.
Granting the Rights Required to Write to or Read from a Backup File
The Analysis Services logon account requires the following permissions to access a backup file:
To perform a database backup, the Analysis Services logon account must have file level permissions to create the backup file in the specified location.
To perform a database restoration, the Analysis Services logon account must have read permissions to the backup file.
Additionally, use the NTFS file system to help secure the storage location for the backup file and to help make sure that unauthorized users do not have access to the backup file.
Granting the Rights Required to Write to and Create the Query Log Table
The Analysis Services logon account must have write permissions to the query log table in the designated SQL Server database. If this table does not already exist and needs to be created, the Analysis Services logon account must also have create table permissions within the designated SQL Server database.
Note
Security on the query log table is the responsibility of the SQL Server database administrator.
Granting the Rights Required to Write to the Writeback Table
If writeback is enabled within any dimension or cube, the Analysis Services logon account must have write permissions to the writeback table in the designated SQL Server database. If this table does not already exist and needs to be created, the Analysis Services logon account must also have create table permissions within the designated SQL Server database.
Note
Security on the writeback table is the responsibility of the SQL Server database administrator.