While modern software licensing heavily favors online connectivity, the offline activation workflow provided by Redgate SQL Prompt ensures that secure development environments remain fully supported. By understanding the request-response architecture and the necessity of manual file transport, database administrators and developers can maintain compliance and functionality within isolated networks. Proper management of activation tokens and awareness of subscription renewal cycles are essential to prevent service interruption in air-gapped infrastructures.
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
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
Here is the information regarding the offline activation process for Redgate SQL Prompt.
Note: Redgate products generally require an internet connection to validate the license start date during activation. The "Offline" method is typically used for secured environments that cannot connect to the internet at all, but it requires the manual transfer of files between the server and an internet-connected workstation.
On the offline machine, in the SQL Prompt activation dialog:
✅ Success message confirms activation.
| Error | Likely cause | Solution | |-------|--------------|----------| | “Invalid machine identifier” | Copied incorrectly or from wrong version | Copy exactly, ensure no extra spaces. | | “License key not found” | Key entered incorrectly or expired | Verify key in Redgate account. | | “Activation file expired” | File not used within 48 hours | Generate a new file. | | “Already activated” | License already used on another machine | Deactivate the other machine first. | redgate sql prompt offline activation
Let’s break the process into two main phases: generating the request file on the offline machine and applying the response file.
Offline activation for Redgate SQL Prompt is a robust, secure method for equipping developers in isolated environments. While the process involves a few manual steps—generating a request file, transferring it, getting a response, and applying it—those steps are straightforward and well-supported by Redgate’s licensing portal.
By following this guide, you can unlock the full power of SQL Prompt—instant T-SQL suggestions, intelligent formatting, and refactoring—even on the most restricted networks. Remember to plan for license renewals, maintain an inventory of activations, and leverage Redgate’s website to deactivate old machines when they retire.
If you encounter persistent issues, Redgate Support offers dedicated assistance for offline activation scenarios. Their knowledge base also provides version-specific screenshots and command-line methods.
Now enjoy faster, cleaner SQL development—completely offline.
About the Author – This guide was compiled from Redgate’s official documentation, community forums, and enterprise deployment experience. Always refer to the latest SQL Prompt release notes for any changes to the offline activation workflow.
Activating Redgate SQL Prompt on a device with restricted internet access—such as a secure server or an air-gapped environment—is primarily achieved through offline permits. This process allows you to bridge the gap between an offline machine and Redgate's licensing servers using a second, internet-connected device. Overview of Offline Activation
SQL Prompt automatically detects when a connection to the Redgate licensing service cannot be established. Once detected, the software enters an offline state and provides an interface for manual permit entry. Step-by-Step Activation Process
To complete the activation, follow these steps on both your offline and online devices: 1. On the Offline Device
Launch SQL Prompt: Open the application (usually within SQL Server Management Studio). ✅ Success message confirms activation
Activating Redgate SQL Prompt Offline: A Step-by-Step Guide
As a database developer or administrator, you rely on tools like Redgate SQL Prompt to streamline your workflow and improve productivity. However, sometimes you may find yourself in a situation where you need to activate SQL Prompt offline, without an internet connection. This could be due to various reasons such as working in a secure environment, traveling to a remote location, or simply having a slow internet connection.
In this post, we'll walk you through the process of activating Redgate SQL Prompt offline, so you can continue to work efficiently even without an internet connection.
Why Offline Activation is Needed
Redgate SQL Prompt is a popular tool for SQL Server database development, offering features like code completion, code analysis, and database scripting. To use SQL Prompt, you need to activate it with a valid license key. Typically, activation is done online, which requires an internet connection. However, in some cases, an offline activation may be necessary.
Prerequisites for Offline Activation
Before you start the offline activation process, make sure you have the following:
Step-by-Step Offline Activation Process
Here's how to activate Redgate SQL Prompt offline:
Step 1: Generate an Offline Activation Code | Error | Likely cause | Solution |
Step 2: Create an Offline Activation File
Step 3: Activate SQL Prompt Offline
Step 4: Verify Activation
Troubleshooting Tips
If you encounter issues during the offline activation process, here are some troubleshooting tips:
Conclusion
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.
For organizations using a Redgate License Server or central license management:
Transfer the license file securely to the internal license server (which may be on the intranet).
On client machines:
This model scales better for large deployments and avoids repeating offline activations per machine.