LiteSpeed requires the following privileges and grants:
| Account | Requirement |
|---|---|
|
User account that performs the LiteSpeed installation |
Windows administrator rights and DBA privileges required to
|
| User account that runs the LiteSpeed UI Console |
Power User privileges (or some equivalent). NOTE: When executing a Double Click Restore, Windows Vista, Windows Server 2008, and higher require that the Windows user account is an administrator. |
|
SQL Server service account |
Sysadmin server role privileges required to
TIP: The SQL service account needs at least read\write access to the following directory and all its contents: NOTE: SQL Server Configuration Manager should always be used when changing SQL Server service accounts. |
| SQL Agent service account (or a proxy account) | |
|
Windows or SQL Server accounts specified during instance configuration (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration) |
If you select SQL Server authentication, the SQL Server account must have sysadmin server role privileges, while the Activity Manager service account must have the Log on as a service permission. If you select the Windows authentication method for both the local and central repository, then the Activity Manager service account specified on the Service Account page must have the sysadmin privileges and the Log on as a service permission. NOTE: If the central repository is located on another server, the LiteSpeed Activity Manager service account must have domain rights for two-way communication between the local and central repositories. |
|
Windows or SQL Server account (Application Button | Repository Registration...) For more information, see About Collecting Statistics in Repositories. |
Db_owner of the central repository (required to retrieve data from the central repository) |
|
Windows or SQL Server account (Application Button | SQL Server Registration...) |
Sysadmin server role privileges required to
|
|
TSM with LiteSpeed |
If using TSM, its recommended that the following line be added to the dsm.opt file used by LiteSpeed.
|
Use the options pages to customize settings in LiteSpeed. There is a General options page to select basic settings, and a separate options page for each main feature in LiteSpeed.
To set General options
Review the following for additional information:
|
Use this option... |
To... |
Default |
|---|---|---|
|
Select central repository |
Select a central repository to view statistics in the LiteSpeed UI Console. You must register the repository before you can select it. For more information, see Register Central Repositories. |
Not Selected |
|
Display properties in dockable window |
View properties about the item selected in the navigation pane in a dockable window. |
Cleared |
| Show confirmation message | View confirmation message when exiting the LiteSpeed UI Console or wizards. |
Cleared |
| Show background task complete notification | View background task complete notification messages. |
Cleared |
|
Log the LiteSpeed UI Console activity |
Select a logging level to define what events to log for the console. You can find the log events in the Application Event Log. |
Errors only |
| Show database status |
View if a database has been backed up recently using LiteSpeed The instance tree view displays databases icons of the following colors:
NOTE: Database status can only be displayed for LiteSpeed backups and if the local repository is configured. |
Cleared |
To set Backup Manager options
Click the Application Button and select Options (Keyboard: ALT+F+O).
Select the Backup Manager tab. Review the following for additional information:
|
Use this option... |
To... |
Default |
|---|---|---|
|
View content timeout |
Enter the connection timeout for when you view the backup file content. |
30 seconds |
|
TSM device retry time |
Select the amount of time to wait for the device to become available, or not to retry. |
No retries |
| Show TimeLine on LiteSpeed Activity tab |
View database backups in a timeline at the server and database level. |
Selected |
| Use UTC time for LiteSpeed Activity | If selected LiteSpeed Activity will use UTC time to display and sort activities on the list. Useful in case of several Sql Server instances in different time zones. If not selected the local Sql Server instance time used. | Not selected |
| Ask for confirmation when making changes to the Central View |
Display a confirmation message before you are able to edit central repository instances. |
Selected |
| Ask to import instances when switching from Local to Central View. |
Display a confirmation message about importing registered SQL Server instances when switching from the Local to Central View. |
Selected |
| Automatic refresh Overview every. |
Refresh the Overview and LiteSpeed Activity screens a configurable amount in increments from 1 to 30 minutes. |
Not selected |
| Specify proxy settings if needed to set up cloud storage connection. |
Specify proxy settings for the LiteSpeed console. Select the Proxy Settings link and enter the following.
|
Not selected |
To set Log Shipping options
Click the Application Button and select Options (Keyboard: ALT+F+O).
Select the Log Shipping tab. Review the following for additional information:
|
Use this option... |
To... |
Default |
|---|---|---|
|
Read subscriber information |
View subscriber information on the Monitoring tab. |
Selected |
|
Display detailed status information on the Monitoring tab |
Show the details panel on the Monitoring tab. The details panel displays tips if there is something wrong with the log shipping plan. |
Selected |
| Load log shipping plan statuses... |
View current statuses of all log shipping plans when connecting to the server instance and when refreshing the Log shipping plans tab at the instance level. If this option is off, plan status is only loaded when you double-click a plan. |
Cleared |
| Show "Continue shipping logs without full backup" option... |
Have the Continue shipping logs without full backup checkbox shown when the Perform full backup and then restore to initialize subscriber(s) option is unchecked in the Change Role Wizard under the Backup Options step. If this option is off, the Continue shipping logs without full backup checkbox will be completely unavailable and will not be shown. |
Cleared |
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center
