Error installing LiteSpeed Extended Stored Procedures to cluster:
" Failed to set data for "Working Directory" "
Then subsequent error displays " Error 1722. There is a problem with this Windows Installer package...."
Lack of Full Permissions on the registry for all nodes and/or remote service is not started
Verify that Remote Registry Service is started in the Control Panel | Administrative Tools | Services for all node in cluster.
Start | Run | Regedit (or regedit32) Select File | Connect Network registry to connect to the other node/box. Once connected, access registry and verify access permission to keys in HKEY_LOCAL_MACHINE\SOFTWARE\Imceda\SQLLiteSpeed\Engine.
IMPORTANT: Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs.
Installer log file may contain information similar to:
...
SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\CLUSTER reg key exists
Cluster Name Value Exists
...
Entering : InstallCluster
Installing to cluster machine <SERVERNAME64INSTANCEA>
Reading SQL Server CurrentVersion from SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\CurrentVersion
Entering : InstallFilesOnNode
Installing files to server <SERVERNAME64INSTANCEA>
\\SERVERNAME64INSTANCEA\e$\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn
Exiting : InstallFilesOnNode
Entering : CreateRegOnNode
Creating key SOFTWARE\Imceda\SQLLiteSpeed\Engine
Creating key SOFTWARE\Imceda\SQLLiteSpeed\Server
Writing to SOFTWARE\Imceda\SQLLiteSpeed\Server
Failed to set data for 'WorkingDirectory'
Exiting : CreateRegOnNode
