Redgate Sql Prompt Offline 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:

1. A valid license key for Redgate SQL Prompt
2. The latest version of SQL Prompt installed on your machine
3. A computer with internet access (to generate an offline activation code)

Step-by-Step Offline Activation Process

Here's how to activate Redgate SQL Prompt offline:

Step 1: Generate an Offline Activation Code redgate sql prompt offline activation

1. On a computer with internet access, go to the Redgate website and sign in to your account.
2. Click on the "Licenses" tab and select the license key for SQL Prompt.
3. Click on the "Offline Activation" link.
4. Fill in the required details, including your license key, name, and email address.
5. Click on the "Generate Offline Activation Code" button.

Step 2: Create an Offline Activation File

1. Save the offline activation code in a file (e.g., offline_activation_code.txt).
2. Copy the file to a USB drive or transfer it to the machine where SQL Prompt is installed (using a secure method, such as a secure file transfer protocol).

Step 3: Activate SQL Prompt Offline

1. On the machine where SQL Prompt is installed, open the SQL Prompt activation dialog (usually found in the SQL Prompt menu).
2. Select the "Offline Activation" option.
3. Browse to the location of the offline activation file and select it.
4. Click on the "Activate" button.

Step 4: Verify Activation

1. Once the activation is complete, verify that SQL Prompt is activated by checking the license details in the SQL Prompt menu.

Troubleshooting Tips

If you encounter issues during the offline activation process, here are some troubleshooting tips:

• Make sure you have a valid license key and that it's not already in use on another machine.
• Ensure that the offline activation code is generated correctly and that the file is not corrupted.
• Check that the machine where SQL Prompt is installed meets the system requirements.

Conclusion

Redgate SQL Prompt (and other user-based tools), offline activation is handled through Offline Permits

. This process allows you to license devices with restricted internet access by using a separate machine that is connected to the web to generate a permit. Activation Prerequisites User Allocation : You must be an allocated user of the license in the Redgate Customer Portal

. Even license owners or admins must specifically allocate themselves to a "seat" to use the tool. : You need a device with no internet (the Offline Device ) and a device with a web browser and internet (the Online Device Step-by-Step Activation Process Generate a Request Code (Offline Device) Open the Redgate product (e.g., within SSMS) and go to the menu, then select Manage License Activating Redgate SQL Prompt Offline: A Step-by-Step Guide

The software will attempt to connect to the licensing service. When it fails, it will offer the option to Set offline permit Note down the six-character request code (e.g., "ABC123") displayed on the screen. Generate the Permit (Online Device) Navigate to the Redgate Offline Activation Portal six-character code from the offline machine and accept the EULA.

The portal will generate permit information. You can either copy this text to a file or download it as a

Transfer this file to the offline device (e.g., via a USB drive or internal network share). Apply the Permit (Offline Device) Set offline permit

screen of the Redgate product, paste the entirety of the permit text into the provided box. . The product status should update to "Licensed". Key Maintenance Details Activating - SQL Prompt 11 - Product Documentation

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: A valid license key for Redgate SQL Prompt

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

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

Cons / Pain Points (from user reviews)

• Clunky & manual – especially if you have many machines or frequent reactivations (e.g., after hardware changes or VM rebuilds).
• Time-consuming – requires USB stick or secure file transfer each time.
• Error-prone – mismatched request/response files or expired activation links cause frustration.
• No trial reset – offline activation for trials can be problematic; full license required.
• Support delay – occasionally the portal fails, requiring a support ticket (and waiting for business hours).

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

When to use offline activation

• Machines have no internet access (air-gapped systems).
• Corporate firewalls or proxies block activation traffic.
• Compliance or audit rules prohibit external activation calls.
• You need to deploy licenses on systems that cannot reach Redgate activation servers.