When SQL Prompt cannot detect an internet connection, it automatically triggers the manual (offline) activation workflow. Follow these steps to complete the process. Step 1: Access the Activation Dialog Open or Visual Studio . Navigate to the top menu and click on SQL Prompt .
Because your machine lacks an internet connection, SQL Prompt will fail its initial automated check and offer an option for manual activation. Open or Visual Studio . Locate the SQL Prompt menu in the top toolbar.
When your workstation lacks an active internet connection, standard online activation will fail. This comprehensive guide walks you through the step-by-step process of activating Redgate SQL Prompt offline, managing activation errors, and deactivating licenses when migrating workstations. Prerequisites Before You Begin
The text block was copied incorrectly or truncated during transfer.
Click or save the text into a .txt file onto your USB flash drive. Do not alter any characters in this block. Step 4: Generate the Activation Response Online
Copy this new block of text or save it to your USB flash drive. Step 5: Apply the Response to SQL Prompt
Click on within the SQL Prompt dropdown, then select Manage License (or Activate depending on your specific version).
Before rolling out SQL Prompt to a large number of offline machines, test the entire activation workflow on a single device. Verify that installation, permit generation, and activation all complete successfully. This prevents widespread issues during production deployment.
Before the introduction of the modern permit system, Redgate offered a manual activation process via the www.red-gate.com/activate page. This method is still available for older product versions and certain scenarios, though the offline permit workflow is now preferred.
The software must already be installed on the target offline machine.
Copy this new response text, paste it into a new text file named ActivationResponse.txt , and save it to your removable media. Step 5: Finalize Activation on the Offline Machine
You will need a secondary device (like a smartphone, a laptop on an unrestricted network, or a jump box) that can access the Redgate activation website to exchange validation keys. Step 1: Navigate to the Activation Menu
Click on and select Manage License (or Activate depending on your specific version build).
: Launch SSMS or the Redgate product licensing menu by going to Help > Manage License .
The offline activation process relies on the generation of a "license request" file and the subsequent retrieval of an "activation response." This process bypasses the need for a live socket connection by using the user as a data mule between the two endpoints.