Recent Posts.

Search site...
…

Redgate Sql Prompt Offline Activation

To activate Redgate SQL Prompt without an internet connection, you must use an offline permit or manual activation process. The specific steps depend on whether you are using the latest "user-based" licensing or an older serial key system. 🔑 Offline Permit (Modern Licensing)

If your version of SQL Prompt uses your Redgate ID for licensing, follow these steps to generate a permit: On the Offline Computer: Open SQL Server Management Studio (SSMS). Go to the SQL Prompt menu and select Manage License.

The software should automatically detect the lack of internet and offer to "Set offline permit".

Note down the six-character code (e.g., ABC123) displayed on the screen. On a Computer with Internet: Go to the Redgate Offline Portal. Enter the six-character code and accept the EULA. Download the generated permit text file. Back on the Offline Computer:

Copy the text from that file into the offline permit box in the licensing menu. Click Save to complete activation. 🛠 Manual Activation (Legacy/Serial Keys) If you have a serial number (e.g., versions prior to 11.2): Start Activation:

In the licensing menu, choose "Activate using fallback" or enter your serial number and wait for the automatic connection to fail. Click Activate Manually. Generate Request:

The software will display an Activation Request (a block of XML-like text). Copy this text and save it to a file. Get Response:

On an online device, go to the Redgate Manual Activation Page.

Paste your request into Step 1 and click Get Activation Response.

Copy the resulting response text and bring it back to your offline machine. Finish:

Paste the response into Step 2 on the offline device and click Finish. 💡 Quick Tips:

Permissions: Ensure the Redgate Client Service is running (search "Services" in Windows) to avoid activation errors.

Version Match: Ensure your serial key matches the version of SQL Prompt you have installed; older keys may not work with newer software. Activating - SQL Prompt 8 - Product Documentation

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 redgate sql prompt offline activation

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

Activating Redgate SQL Prompt offline is primarily done using offline permits, which allow you to license the software on machines without an internet connection or in air-gapped environments. Activation Steps 1. On the Offline Device

Open SQL Prompt: Launch SSMS or the Redgate product licensing menu by going to Help > Manage License.

Detect Offline Status: If the product cannot connect to the internet, it will automatically enter an offline state.

Generate Code: A "Set offline permit" option will appear. Copy the six-character code (e.g., ABC123) shown on this screen. 2. On a Device With Internet Access

Access the Portal: Open a web browser and navigate to the Redgate Offline Activation Portal.

Enter Details: Input the six-character code from the offline machine and accept the EULA terms.

Get the Permit: You can either copy the generated permit text to your clipboard or download it as a text file.

Transfer: Move this text file/permit info to the offline machine (e.g., via a USB drive). 3. Back on the Offline Device

Apply Permit: Open the permit text file using a simple editor like Notepad and paste the entire block of text into the offline permit box in the licensing menu. To activate Redgate SQL Prompt without an internet

Save: Confirm the permit is valid and click Save. The product is now licensed. Important Notes

Permit Expiry: Offline permits typically expire after one year (or sooner if your subscription ends), at which point you must repeat this process.

Legacy Manual Activation: Older versions (e.g., SQL Prompt 7, 8, 9) may use a different "Manual Activation" process involving an activation request string and a response code from Redgate Manual Activation.

CLI Support: You can also perform these steps via command line if you are using Redgate tools in an automated environment. If you'd like, I can: Help you find your serial key in the customer portal.

Provide troubleshooting for SOAP errors or invalid machine hashes.

Explain how to deallocate a license from an offline machine. Let me know how you'd like to proceed! How to activate using offline permits - Support

Redgate SQL Prompt offline activation process has evolved significantly with the introduction of the modern Offline Permits

system, replacing the older legacy serial key method. As of April 2026, this system is the standard for activating SQL Prompt on air-gapped or network-restricted devices. Activation Process Overview

The modern workflow uses a "challenge and response" system involving a separate internet-connected device to generate a license permit. Step 1: Obtain the Offline Code On your air-gapped machine, open SQL Prompt and navigate to Manage License

. The software will automatically detect the lack of internet and present a six-character code (e.g., "ABC123"). Step 2: Generate the Permit On a device with internet access, visit the Redgate Offline Portal

and enter the code. Log in with your Redgate ID to select the applicable license. Step 3: Apply the Permit

Download the generated permit text file and transfer it to the offline machine via USB or other secure means. Paste the permit content into the offline permit box in SQL Prompt to finalize activation. Critical Insights & Limitations Activating - SQL Prompt 7 - Product Documentation

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 Preparing for 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).

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

Preparing for offline activation

  • Know the SQL Prompt version and license type (individual, floating, or site).
  • Have admin privileges on the target machine.
  • Prepare a removable media (USB) or secure file-transfer channel.
  • If using a license server or centralized console (Redgate License Server/portal), ensure access to that from a machine with internet.

D. Network-Based Offline Activation (Advanced)

In larger enterprises, you can host an internal license server using Redgate’s License Server product. This allows multiple offline machines to activate without individual file swapping. However, for small teams, the manual XML method is sufficient.

Tips and best practices

  • Keep a copy of the license key and activation response files in a secure place for future re-activation.
  • If you manage many offline machines, automate request/response handling with documented steps or scripts where supported.
  • For volume/enterprise licenses, contact Redgate support or your account representative for network-friendly licensing options (e.g., centralized license server or token-based approaches) that may simplify activation.
  • Record which license is applied to which machine to simplify audits and renewals.

Step 6: Transfer file back to offline machine

Plug the USB into the offline machine.

How Offline Activation Works (Official Process)

  1. On the offline machine, generate an activation request file (.rfx or similar) from SQL Prompt’s activation dialog.
  2. Transfer that file to an internet-connected machine.
  3. Visit Redgate’s offline activation portal, upload the file, and download a license response file.
  4. Transfer the response file back to the offline machine and complete activation.

Phase 2: Response Retrieval (Online Machine)

  1. Transport the removable media to a machine with internet access.
  2. Open a web browser and navigate to the official Redgate Activation Portal (typically found at red-gate.com/activation).
  3. Log in with the Redgate ID associated with the license purchase.
  4. Locate the interface for offline activation. Upload the request file generated in Phase 1.
  5. The portal will validate the request against the license entitlements.
  6. Upon successful validation, the portal will prompt the download of an activation response file (often named response.txt or similar).
    • Critical Step: Ensure the response file is saved and not renamed, as the client software expects a specific file format.

Machine Binding

Redgate licenses are generally per-user or per-seat. The offline activation ties the license to the machine's unique hardware profile. If the user performs significant hardware changes (e.g., replacing the motherboard or hard drive), the offline activation may become invalid, requiring a re-activation process. In an offline environment, this necessitates repeating the entire offline procedure.

Bonus: Offline License Health Check

  • SQL Prompt periodically checks license status and warns before it expires (e.g., “7 days left — generate renewal request now”).
  • Allows renewal without needing to reinstall or re-enter a key.

Would you like a mockup of the wizard steps or a technical spec for how the request/response files could be structured?

To activate Redgate SQL Prompt on a device without internet access, you must use an Offline Permit 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.

Title: Technical Analysis and Procedure for Offline Activation of Redgate SQL Prompt

Abstract

Redgate SQL Prompt is an industry-standard tool for SQL Server development, offering advanced IntelliSense, code formatting, and refactoring capabilities. In standard operational environments, the software validates its license through an online connection to Redgate’s licensing servers. However, development workflows in secure, air-gapped, or restricted network environments—such as those found in financial institutions, government agencies, and healthcare infrastructure—preclude direct internet access. This paper provides a technical examination of the offline activation architecture employed by Redgate SQL Prompt and outlines the procedural methodology for successfully licensing the software in disconnected environments.

To activate Redgate SQL Prompt without an internet connection, you must use an offline permit or manual activation process. The specific steps depend on whether you are using the latest "user-based" licensing or an older serial key system. 🔑 Offline Permit (Modern Licensing)

If your version of SQL Prompt uses your Redgate ID for licensing, follow these steps to generate a permit: On the Offline Computer: Open SQL Server Management Studio (SSMS). Go to the SQL Prompt menu and select Manage License.

The software should automatically detect the lack of internet and offer to "Set offline permit".

Note down the six-character code (e.g., ABC123) displayed on the screen. On a Computer with Internet: Go to the Redgate Offline Portal. Enter the six-character code and accept the EULA. Download the generated permit text file. Back on the Offline Computer:

Copy the text from that file into the offline permit box in the licensing menu. Click Save to complete activation. 🛠 Manual Activation (Legacy/Serial Keys) If you have a serial number (e.g., versions prior to 11.2): Start Activation:

In the licensing menu, choose "Activate using fallback" or enter your serial number and wait for the automatic connection to fail. Click Activate Manually. Generate Request:

The software will display an Activation Request (a block of XML-like text). Copy this text and save it to a file. Get Response:

On an online device, go to the Redgate Manual Activation Page.

Paste your request into Step 1 and click Get Activation Response.

Copy the resulting response text and bring it back to your offline machine. Finish:

Paste the response into Step 2 on the offline device and click Finish. 💡 Quick Tips:

Permissions: Ensure the Redgate Client Service is running (search "Services" in Windows) to avoid activation errors.

Version Match: Ensure your serial key matches the version of SQL Prompt you have installed; older keys may not work with newer software. Activating - SQL Prompt 8 - Product Documentation

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

Activating Redgate SQL Prompt offline is primarily done using offline permits, which allow you to license the software on machines without an internet connection or in air-gapped environments. Activation Steps 1. On the Offline Device

Open SQL Prompt: Launch SSMS or the Redgate product licensing menu by going to Help > Manage License.

Detect Offline Status: If the product cannot connect to the internet, it will automatically enter an offline state.

Generate Code: A "Set offline permit" option will appear. Copy the six-character code (e.g., ABC123) shown on this screen. 2. On a Device With Internet Access

Access the Portal: Open a web browser and navigate to the Redgate Offline Activation Portal.

Enter Details: Input the six-character code from the offline machine and accept the EULA terms.

Get the Permit: You can either copy the generated permit text to your clipboard or download it as a text file.

Transfer: Move this text file/permit info to the offline machine (e.g., via a USB drive). 3. Back on the Offline Device

Apply Permit: Open the permit text file using a simple editor like Notepad and paste the entire block of text into the offline permit box in the licensing menu.

Save: Confirm the permit is valid and click Save. The product is now licensed. Important Notes

Permit Expiry: Offline permits typically expire after one year (or sooner if your subscription ends), at which point you must repeat this process.

Legacy Manual Activation: Older versions (e.g., SQL Prompt 7, 8, 9) may use a different "Manual Activation" process involving an activation request string and a response code from Redgate Manual Activation.

CLI Support: You can also perform these steps via command line if you are using Redgate tools in an automated environment. If you'd like, I can: Help you find your serial key in the customer portal.

Provide troubleshooting for SOAP errors or invalid machine hashes.

Explain how to deallocate a license from an offline machine. Let me know how you'd like to proceed! How to activate using offline permits - Support

Redgate SQL Prompt offline activation process has evolved significantly with the introduction of the modern Offline Permits

system, replacing the older legacy serial key method. As of April 2026, this system is the standard for activating SQL Prompt on air-gapped or network-restricted devices. Activation Process Overview

The modern workflow uses a "challenge and response" system involving a separate internet-connected device to generate a license permit. Step 1: Obtain the Offline Code On your air-gapped machine, open SQL Prompt and navigate to Manage License

. The software will automatically detect the lack of internet and present a six-character code (e.g., "ABC123"). Step 2: Generate the Permit On a device with internet access, visit the Redgate Offline Portal

and enter the code. Log in with your Redgate ID to select the applicable license. Step 3: Apply the Permit

Download the generated permit text file and transfer it to the offline machine via USB or other secure means. Paste the permit content into the offline permit box in SQL Prompt to finalize activation. Critical Insights & Limitations Activating - SQL Prompt 7 - Product Documentation

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).

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

Preparing for offline activation

D. Network-Based Offline Activation (Advanced)

In larger enterprises, you can host an internal license server using Redgate’s License Server product. This allows multiple offline machines to activate without individual file swapping. However, for small teams, the manual XML method is sufficient.

Tips and best practices

Step 6: Transfer file back to offline machine

Plug the USB into the offline machine.

How Offline Activation Works (Official Process)

  1. On the offline machine, generate an activation request file (.rfx or similar) from SQL Prompt’s activation dialog.
  2. Transfer that file to an internet-connected machine.
  3. Visit Redgate’s offline activation portal, upload the file, and download a license response file.
  4. Transfer the response file back to the offline machine and complete activation.

Phase 2: Response Retrieval (Online Machine)

  1. Transport the removable media to a machine with internet access.
  2. Open a web browser and navigate to the official Redgate Activation Portal (typically found at red-gate.com/activation).
  3. Log in with the Redgate ID associated with the license purchase.
  4. Locate the interface for offline activation. Upload the request file generated in Phase 1.
  5. The portal will validate the request against the license entitlements.
  6. Upon successful validation, the portal will prompt the download of an activation response file (often named response.txt or similar).
    • Critical Step: Ensure the response file is saved and not renamed, as the client software expects a specific file format.

Machine Binding

Redgate licenses are generally per-user or per-seat. The offline activation ties the license to the machine's unique hardware profile. If the user performs significant hardware changes (e.g., replacing the motherboard or hard drive), the offline activation may become invalid, requiring a re-activation process. In an offline environment, this necessitates repeating the entire offline procedure.

Bonus: Offline License Health Check

Would you like a mockup of the wizard steps or a technical spec for how the request/response files could be structured?

To activate Redgate SQL Prompt on a device without internet access, you must use an Offline Permit 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.

Title: Technical Analysis and Procedure for Offline Activation of Redgate SQL Prompt

Abstract

Redgate SQL Prompt is an industry-standard tool for SQL Server development, offering advanced IntelliSense, code formatting, and refactoring capabilities. In standard operational environments, the software validates its license through an online connection to Redgate’s licensing servers. However, development workflows in secure, air-gapped, or restricted network environments—such as those found in financial institutions, government agencies, and healthcare infrastructure—preclude direct internet access. This paper provides a technical examination of the offline activation architecture employed by Redgate SQL Prompt and outlines the procedural methodology for successfully licensing the software in disconnected environments.