If you prefer to combine installation and activation, you can use the MSI installer with command‑line parameters. This approach embeds your serial number directly into the installation process:
The website will process your request against Redgate’s licensing database and output a new block of text: the .
Log into the online Redgate ID portal from an internet-connected device to de-allocate an old machine before retrying. Missing Manual Option Cause: Outdated installer versions. redgate sql prompt offline activation
While older versions may accept a product key, this method has drawbacks: keys are device-specific, use up license allocations quickly, and often break during major version upgrades.
msiexec /i "RedGate_SQL_Prompt.msi" /IAgreeToTheEula RG_LICENSE=XXX-XXX-XXXXXX-XXXX If you prefer to combine installation and activation,
Ensure the version of SQL Prompt you have installed matches the version your serial number supports. Perpetual licenses are version-specific.
Redgate's modern licensing system primarily uses a Redgate ID for online activation. However, for offline environments, you typically have two choices: Missing Manual Option Cause: Outdated installer versions
Open SQL Server Management Studio (SSMS) or Visual Studio where SQL Prompt is installed. Go to the menu in the top toolbar. Select Help > Enter Serial Number . Enter your serial number and click Activate . 2. Trigger the "Manual Activation" Mode
