How to set up a SQL Server login to use LiteSpeed
LiteSpeed does not grant privileges to any object but does require users to have certain grants assigned to them.
Grants required for install:
The user must be able to install extended stored procedures, stored procedures, create databases, tables, and indexes. Requires permission to insert, update, and delete from MSDB and the local/central repositories. Permission to write to HKEY_Current_User/Software/Imceda and HKEY_Current_User/Software/Imceda
Grants required to run
The user must be a sysadmin to do a backup using LiteSpeed. If you use a SQL Authentication, the windows account must be a power user. The user account owning the LiteSpeed 2005 Activity Service must have permission to insert, update, and delete from MSDB and the local/central repositories. The job�s owner is the creator, by default. The Job Step �Run as� user and the owner must be sysadmin and have permission to run the SQL Server Agent. The user must be assigned the master database as its default database in the SQL Server Login Properties (see attached). Test by running the backup/restore processes from Enterprise Console Backup Database Wizard, a Maintenance Plan and a LiteSpeed backup via script in SQL Server Query Analyzer.
Windows Rights:
Assigns the service logon right to the user account the statistics replication service runs under (LiteSpeed 2005 Activity Service). The installer needs to be run by an Administrator. If using Remote Desktop access, verify that permissions are also of an Administrator. To run, user must be designated as a Power User. The LiteSpeed user requires Read and Write access to:
- HKEY_Current_User/Software/Imceda
- HKEY_Local_Machine/Software/Imceda registry key
- <Install Dir>:\Imceda\LiteSpeed directory.
- %\Program Files\Microsoft SQL Server\MSSQL\Binn
- %\Program Files\Microsoft SQL Server\MSSQL\Data
It is recommended that a specific LiteSpeed user be created with a password that does not expire.
Additional Information:
Terminal Services has two modes of operation: Remote Administration mode and Application Server mode.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center