Environments where outbound traffic on port 443 is heavily restricted or locked down to explicit whitelists.
Operating Redgate tools at scale across an air-gapped infrastructure requires proactive planning. Keep these strategies in mind to minimize friction:
: The serial number was mistyped or does not match the product version.
To activate Redgate SQL Prompt on a device without internet access, you must use an 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. redgate sql prompt offline activation
Before starting the manual activation process, ensure you have the following assets ready:
If you see this error, you may need to log into the Redgate License Management Portal on an internet-connected device to de-activate an old machine before you can activate the new one.
: A valid Redgate SQL Prompt serial number (typically formatted as a 16-digit alphanumeric code). Environments where outbound traffic on port 443 is
: Verify that you are copying the serial number exactly as provided in your Redgate ID portal. Check that your license covers the specific version of SQL Prompt you installed. "The Activation Request is Corrupted"
Bring the ActivationResponse.txt file back to your secure, offline workstation.
You’ll need the license key provided in your Redgate purchase confirmation email. To activate Redgate SQL Prompt on a device
Here’s a helpful feature idea for that addresses a common pain point with offline activation :
A screen will appear stating that an internet connection could not be established. Click on the link or button labeled . Step 3: Copy the Activation Request Text