Redgate Sql Prompt Offline Activation May 2026

Here’s a concise review of Redgate SQL Prompt offline activation based on common user experiences and the official process.

Step 1: Install SQL Prompt on the offline machine

Run the installer normally. At the activation screen, select: redgate sql prompt offline activation

“Activate manually (offline)”

You will see a Machine Identifier – a long string of characters. Here’s a concise review of Redgate SQL Prompt

Phase 1: Request Generation (Offline Machine)

  1. Launch SQL Server Management Studio (SSMS).
  2. Navigate to the Redgate SQL Prompt menu and select Manage License or Activate Product.
  3. When prompted for the license key, enter the valid key provided upon purchase.
  4. The activation wizard will attempt to contact the server. Upon failure, a dialog will appear stating that the connection could not be established.
  5. Select the option labeled "Activate manually" or "Offline activation."
  6. The software will generate a license request file. The user must save this file to a location accessible via removable media (e.g., USB drive).
    • Note: This file contains unique identifiers for the specific machine. It cannot be reused for a different workstation.

Phase 2: Response Retrieval (Online Machine)

  1. Transport the removable media to a machine with internet access.
  2. Open a web browser and navigate to the official Redgate Activation Portal (typically found at red-gate.com/activation).
  3. Log in with the Redgate ID associated with the license purchase.
  4. Locate the interface for offline activation. Upload the request file generated in Phase 1.
  5. The portal will validate the request against the license entitlements.
  6. Upon successful validation, the portal will prompt the download of an activation response file (often named response.txt or similar).
    • Critical Step: Ensure the response file is saved and not renamed, as the client software expects a specific file format.

6. Alternative – Silent offline activation (for admins)

For multiple offline machines, you can use command line: “Activate manually (offline)”

SQLPrompt.exe /quiet /norestart /offlineactivation /machineid "YOUR_MACHINE_ID" /licensekey "YOUR_KEY" /activationfile "C:\path\to\activation.bin"

This is useful for scripting via GPO or SCCM in air-gapped environments.

4. Technical Considerations and Troubleshooting