Granting Additional Rights for Specific Tasks

If you need to use the logon account to Microsoft SQL Server 2005 Analysis Services (SSAS) 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.

See Also

Concepts

Choosing the Logon Account
Granting Network Resource Access Rights to the Logon Account

Help and Information

Getting SQL Server 2005 Assistance