Unable to remove/update license key (“Failed to store valid product license”) (96389)

Unable to remove/update license key – xp_sqllitespeed_licenseinfo fails with “Failed to store valid product license”

The extended stored procedure is executed in context of SQL Server service account. If SQL Server service account has no Administrator or SYSTEM (local system) rights, the execution fails.

Solution #1:

1. Run SQL Server service under Administrator or SYSTEM account (if it does not conflict with security policy).
2. Run extended stored procedure to update the license:

EXEC master.dbo.xp_sqllitespeed_licenseinfo

@licensekey = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-xxx-xxx-xxx-xx'

, @sitemessage = 'xxxx'

, @store = 1

Solution #2:

1. Run License Registration utility. Go to Start | All Programs | Quest Software | LiteSpeed for SQL Server | License Registration.
2. Click “Change” and enter your license key and site message to update the license.

Solution #3:

1. Register using the command-line utility (LicenseInfoCmd.exe)
2. To use the utility, run the command line and change the directory until you are in the LiteSpeed installation directory (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server).
3. Register the supplied license key

LicenseInfoCmd.exe -l “licensekey” -m "sitemessage” -s

Solution #4:

1. Create a license file manually using Notepad.exe

The file structure is (example for v7.1.0)

<?xml version="1.0" encoding="utf-8"?>

<LicenseFile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<Licenses>

<License ProductName="LiteSpeed for SQL Server" ProductVersion="7.1.0" KeySaveDate="41129.2548337732">

<LicenseKey> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-xxx-xxx-xxx-xx</LicenseKey>

<SiteMessage>xxxx</SiteMessage>

</License>

</Licenses>

<Cumulative>false</Cumulative>

</LicenseFile>

2. Copy (or replace) this file to C:\Documents and Settings\All Users\Application Data\Quest Software

Or if it is Windows 7, Windows 2008: C:\ProgramData\Quest Software

You can check if license has been properly updated by running extended stored procedure:

EXEC master.dbo.xp_sqllitespeed_licenseinfo

License file name is ProductLicenses.xml.

Note: It can be used by multiple Quest Software products. If you have licenses for other products on this file, you should update "LiteSpeed for SQL Server" license info manually (using Notepad.exe) and then copy this file over other servers if needed.

The file structure is

<Licenses>

<License ProductName="LiteSpeed for SQL Server" ProductVersion="x.x.x" KeySaveDate="xxxx">

<LicenseKey>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-xxx-xxx-xxx-xx</LicenseKey>

<SiteMessage>xxxx</SiteMessage>

</License>

…

</Licenses>

It is located on:

C:\Documents and Settings\All Users\Application Data\Quest Software - Windows 2000, Windows XP, Windows 2003

C:\ProgramData\Quest Software – Windows 7, Windows 2008