To activate Redgate SQL Prompt on a device without an internet connection, you can use the Offline Permit system . This process involves generating a permit on a device with internet access and transferring it to your offline machine. Offline Activation Steps Activating - SQL Prompt 11 - Product Documentation
Here’s a detailed breakdown of offline activation for Redgate SQL Prompt , including when it’s needed, prerequisites, step-by-step instructions, and important limitations.
1. When is offline activation required? Offline activation is used when the machine running SQL Prompt has no internet connection (or is on a highly restricted network) and cannot reach Redgate’s licensing server directly. Typical scenarios:
Secure development environments (air-gapped networks) Production database servers without internet access Virtual machines with no outbound HTTPS allowed redgate sql prompt offline activation
2. Prerequisites Before starting offline activation:
A valid SQL Prompt license key (purchased or trial). Redgate SQL Prompt installer (offline MSI or EXE) – available from Redgate’s website using another internet-connected machine. A USB drive or network share to transfer files between offline machine and an internet-connected machine. Administrator rights on the offline machine.
3. Step-by-step offline activation process Step 1: Install SQL Prompt on the offline machine Run the installer normally. At the activation screen, select: To activate Redgate SQL Prompt on a device
“Activate manually (offline)”
You will see a Machine Identifier – a long string of characters. Step 2: Save the machine identifier Copy the Machine Identifier to a text file (e.g., machine_id.txt ) and save it to a USB drive. Step 3: Go to an internet-connected machine Open a browser and go to: 👉 https://licensing.red-gate.com/OfflineActivation Step 4: Enter your details On that page:
Paste the Machine Identifier . Enter your license key . Enter your email address (the one used to purchase/register the license). including when it’s needed
Click “Generate activation file” . Step 5: Download the activation file Save the generated .bin activation file (e.g., activation.bin ) to the same USB drive. Step 6: Transfer file back to offline machine Plug the USB into the offline machine. Step 7: Apply activation in SQL Prompt On the offline machine, in the SQL Prompt activation dialog:
Choose “Load activation file” . Browse to activation.bin . Click Activate .