Error: "Cannot load the DLL C:\Program Files\Imceda\Sqllitespeed\Engine\xpSLS.DLL, or one of the DLLs it references. Reason: 5(Access is denied.)."
This error may also displayed for the following .dll files: xpLogShipping.dll, xpSLSImportStats.dll, xpLogShipping.dll and may display when user initiates any LiteSpeed activity i.e., backup, restore, object level recovery, etc.
Incorrect permissions to LiteSpeed folders, files or registry entries.
1. Verify that the account logging into SQL Server has access to the LiteSpeed DLLs and the LiteSpeed registries in HKEY_LOCAL_MACHINE\SOFTWARE\Imceda registry key. The account must also be a local admin of the server as well as a sysadmin of SQL Server. The Agent must be running.
This T-SQL script should be run in SQL Server Query Analyzer. The SQL Server Account has to have access to LiteSpeed DLLs, Registry Keys as well as the LiteSpeed folder and files. The output should be the path to the error logs.
SET NOCOUNT ON
DECLARE @output varchar(255)
DECLARE @rc int
EXEC @rc = master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Imceda\SQLLitespeed\Engine',
@value_name='ErrorLogPath',
@value=@output OUTPUT
IF @rc <> '0'
PRINT 'Error Reading Registry'
PRINT @output
EXEC @rc = master..xp_cmdshell 'dir "C:\Program Files\Imceda\LiteSpeed\SQL Server\Engine"',
NO_OUTPUT
IF @rc <> '0'
PRINT 'Error Reading Directory'
EXEC @rc = master..xp_cmdshell 'dir "C:\Program Files\Imceda\LiteSpeed\SQL Server\Engine\SLSRegkey.dll"',
NO_OUTPUT
2. Using regedit32, ensure that the MSSQLServer service logon account has full control permissions to the following system resources:
* At the Registry key Imceda, open permissions and push down inherited rights from that key to all subkeys
* At the Imceda\SQLLiteSpeed\Engine key, give explicit permissions as well to the SQL Server Service account
Using windows explorer ensure that the MSSQLServer service logon account has full control permissions to:
* At the Imceda folder, open the properties and set the security to push inherited from parent down to all subdirectories "\sqllitespeed\engine"
For additional information, see Solutions:
https://support.quest.com/eSupport/solution.asp?WAid=268460904
https://support.quest.com/eSupport/solution.asp?WAid=268467023
https://support.quest.com/eSupport/solution.asp?WAid=268472835
Applies to all versions of Microsoft SQL Server and LiteSpeed.
