Redgate Sql Prompt Offline Activation Guide

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

The exact UI and filenames may vary by SQL Prompt version and whether you use individual or site/volume licensing. redgate sql prompt offline activation

Manual activation is the standard protocol for air-gapped environments or servers behind strict corporate proxies. It ensures that your productivity isn't hindered by network security policies, allowing you to use features like advanced IntelliSense, code formatting, and refactoring regardless of your connectivity status. Here’s a helpful feature idea for Redgate SQL

• Insert the USB drive or access the shared folder containing the response XML file.

If your serial number is valid and has available seats, the website will generate a new block of XML text called the "Activation Response." Insert the USB drive or access the shared

Example B — Site/Floating license via license server (centralized offline activation)

For organizations using a Redgate License Server or central license management:

Note the Machine Identifier

1. A valid Redgate SQL Prompt license – Purchased or trial. You need the serial key (format: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX).
2. Internet access on another machine – You will use a separate, internet-connected computer to complete part of the activation.
3. SQL Prompt installed – If not, download the installer from Redgate’s website and install it on the offline machine. The offline machine does not need internet for installation, only for activation.
4. Permissions to transfer files – Ability to move small text files (via USB drive, network share, or secure copy) between the offline machine and the online machine.
5. Account on Redgate’s website – Optional but helpful for managing licenses.

1. On the machine where SQL Prompt is installed, open the SQL Prompt activation dialog (usually found in the SQL Prompt menu).
2. Select the "Offline Activation" option.
3. Browse to the location of the offline activation file and select it.
4. Click on the "Activate" button.