-
Title
How to determine permissions on a database? -
Description
Permissions to the system databases as well as LiteSpeed Local and LiteSpeed Central mus be adequate for LiteSpeed to run.
Error may be similar to: "failed to access xp_backup_database (or other SLS xp) extended stored procedure."
-
Resolution
See attached script to determine where permissions have been limited to the databases.
From the LiteSpeed Install Guide:
The user account that performs the LiteSpeed installation must have Windows administrator rights
and DBA privileges to:
l Install stored procedures and extended stored procedures
l Create databases, tables, and indexes
l Insert, update, and delete to/from the MSDB, LiteSpeedLocal, and LiteSpeedCentral databases
LiteSpeed requires the following privileges and grants:LiteSpeed for SQL Server 6.1Installation Requirements
Account Requirements:
SQL Server service account used to
l Push stats to local repository
l Back up or restore using extended stored procedures
l Access the registry
Sysadmin server role
Note: SQL Server Configuration Manager should always be used when changing SQL Server service accounts.
SQL Agent service account used to
l Execute a scheduled back up/restore job
l Start a back up/restore job manuallyWindows or SQL Server account specified during instance configuration.
If you select SQL Server authentication method, LiteSpeed uses SQL login details to retrieve data from local repository and to push to central repository:
Sysadmin server role
Note: If the central repository is located on another server, the Activity Service must have rights, including domain rights, for two-way communication between
the local and central repositories.
LiteSpeed for SQL Server 6.1 Installation RequirementsAccount Requirement
If you select Windows authentication method, LiteSpeed uses the service account to push data to central repository:
Windows or SQL Server account (File | SQL Server Registration...) used to
l Connect to SQL Server and retrieve SQL Server properties
l Back up or restore immediately using the Backup wizard
l Execute procedures, retrieve MSDB history
l Access repositories
l Query LiteSpeed configuration data from the registrySysadmin server role
Windows or SQL Server account used to retrieve data from the central repository (File | Repository Registration...)
Db_owner of central repositoryNotes:
l Power User privileges (or some equivalent) are required to run the LiteSpeed UI Console.
l When executing a double-click restore, Windows Vista, Windows Server 2003 and Windows Server 2008 require that the Windows user account is an administrator. -
Attachments
-
Additional Information
The script may be edited to query just the master, msdb, LiteSpeedLocal and LiteSpeedCentral, if necessary