Redgate Sql Prompt Offline Activation [updated] May 2026

Redgate SQL Prompt offline activation process has evolved significantly with the introduction of the modern Offline Permits

system, replacing the older legacy serial key method. As of April 2026, this system is the standard for activating SQL Prompt on air-gapped or network-restricted devices. Activation Process Overview

The modern workflow uses a "challenge and response" system involving a separate internet-connected device to generate a license permit. Step 1: Obtain the Offline Code On your air-gapped machine, open SQL Prompt and navigate to Manage License

. The software will automatically detect the lack of internet and present a six-character code (e.g., "ABC123"). Step 2: Generate the Permit On a device with internet access, visit the Redgate Offline Portal

and enter the code. Log in with your Redgate ID to select the applicable license. Step 3: Apply the Permit

Download the generated permit text file and transfer it to the offline machine via USB or other secure means. Paste the permit content into the offline permit box in SQL Prompt to finalize activation. Critical Insights & Limitations Activating - SQL Prompt 7 - Product Documentation

The feature for offline activation in Redgate SQL Prompt is called Manual Activation. This process allows you to activate the software on a computer that does not have an internet connection or is unable to make SOAP requests. How Manual Activation Works redgate sql prompt offline activation

The process requires a second computer that has internet access to act as a bridge:

Generate Request: On the offline computer, launch SQL Prompt and attempt to activate it with your serial key. When the connection fails, select the Activate Manually button to generate a unique activation request.

Get Response: Copy that request and paste it into the Redgate Activation Service on the computer with internet access to receive an activation response.

Finalize: Copy the response back to the offline computer and paste it into the activation dialog to complete the setup. Activating - SQL Prompt 8 - Product Documentation

Offline activation for Redgate SQL Prompt is primarily achieved through a system of offline permits. This feature is designed for environments with restricted internet access, such as air-gapped systems or secure data centers. 🛠️ Key Mechanism: Offline Permits

The core feature of offline activation is the generation and application of a unique permit code. Redgate SQL Prompt offline activation process has evolved

Automatic Detection: SQL Prompt automatically detects when a device cannot reach Redgate’s licensing services and triggers the offline workflow.

Permit Generation: A six-character code is generated on the offline machine. This code must be entered into the Redgate Offline Portal using a device with internet access.

Validity and Expiry: Permits typically remain valid for one year. If a license expires before the permit does, the permit's validity is shortened accordingly.

Support Range: This feature is supported across both the standard SQL Prompt User Interface (UI) and its Command Line Interface (CLI) tools. 📝 Activation Process Steps

The process involves a "bridge" between an offline device and an online device: On the Offline Device: Open the Manage License menu in SQL Prompt. Select Set offline permit when the connection fails. Note the provided six-character activation code. On the Online Device: Visit the Redgate Offline Activation portal. Input the code and accept the EULA. Download or copy the generated permit information. Finalize Activation: Transfer the permit text to the offline device.

Paste the text into the offline permit box in SQL Prompt and click Save. ⚠️ Important Considerations Activating - SQL Prompt 11 - Product Documentation Machine name / ID Date of offline activation

To activate Redgate SQL Prompt on a device without internet access, you must use an Offline Permit or Manual Activation. This process requires a second device that is connected to the internet to generate the necessary activation data. 🛠️ Activation Process Step 1: On the Offline Device Open SQL Server Management Studio (SSMS) or Visual Studio.

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

A. Centralized License Storage

Keep a spreadsheet or internal wiki tracking:

• Machine name / ID
• Date of offline activation
• Response file used (store a copy)
• Deactivation date when retired

When to contact Redgate support

• If offline activation fails after following the steps above.
• If you don’t receive a valid response file from the portal.
• For questions about enterprise licensing or migrating licenses between machines.

If you want, I can:

• Produce user-facing copy (email/template) for your IT team to perform the steps.
• Draft a short checklist for technicians to carry during offline activations. Which would you prefer?

If your computer is not connected to the internet, you can activate Redgate SQL Prompt

manually by generating an activation request and obtaining a response from a machine with web access. Offline Activation Guide Initiate Manual Activation SQL Prompt within your IDE (SSMS or Visual Studio). Navigate to

Here’s a helpful feature idea for Redgate SQL Prompt that addresses a common pain point with offline activation:

3. Companion Web Tool (Offline License Generator)

• Redgate provides a simple, no-login-required web page (accessible from any online device).
• User uploads the request file → receives a license response file.
• No Redgate account required for this step (just the license key).

Troubleshooting common problems

• “Request file not accepted” — Ensure the request file wasn’t altered, and that you uploaded the correct file for the correct license type and version.
• “Activation file invalid” — Confirm the activation file matches the request (file pairings are unique) and that the portal account has the right license entitlements.
• “License still shows trial” — Restart the host application and check for multiple installations of SQL Prompt (per-user and per-machine installs can conflict).
• Proxy/firewall issues on semi-connected machines — If a machine can reach an internal license server but not Redgate, use the site license approach.
• Expired licenses — Offline activation respects license expiry dates; you’ll need to renew and reapply a new offline activation before expiry.