Return
-
Title
Error: "Msg 22002, Level 16, State 1, Line 0"
-
Description
When running Litespeed jobs or maintenance plans, error below displays:
Msg 22002, Level 16, State 1, Line 0
RegCreateKeyEx() returned error 5, 'Access is denied.' -
Resolution
Give SQL Server Service account full control of the following registry key hives;
HKEY_LOCAL_MACHINE\SOFTWARE\Imceda\SQLLiteSpeed\Engine\ActivityServers\Instance_NameHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\SQLServerAgent