Redgate Sql Prompt — Offline Activation

Redgate SQL Prompt Offline Activation — Guide

Redgate SQL Prompt activation can be done offline when the machine running SQL Server Management Studio (SSMS) or Visual Studio has no internet access. Below is a concise, practical guide for performing an offline activation and troubleshooting common issues.

Key Functionality:

Step 5: Download the activation file

Save the generated .bin activation file (e.g., activation.bin) to the same USB drive. redgate sql prompt offline activation

Example walkthrough (concrete filenames and steps)

1. Offline machine generates: C:\Temp\SQLPromptRequest_20260324.req
2. Copy to USB → upload via licensing portal → receive SQLPromptResponse_20260324.act
3. Copy .act back to C:\Temp\ and in SQL Prompt: Help → License → Offline Activation → Apply Response → select C:\Temp\SQLPromptResponse_20260324.act
4. Restart SSMS; verify via Help → License shows license name and expiry.

Step-by-step offline activation

1. On the offline machine, open SSMS or Visual Studio where SQL Prompt is installed.
2. Open SQL Prompt’s Licensing dialog:
   • In SSMS: SQL Prompt → Configure → Licensing (or Help → About → Licensing, depending on version).
3. Choose the “Activate offline” or “Activate using activation file” option.
4. The dialog will produce an activation request file (often an XML or .req file). Save this file to removable media.
5. Move the request file to the internet-connected machine.
6. On the internet-connected machine, go to Redgate’s activation portal (or the licensing page indicated by the product) and upload the request file, or sign in to your Redgate account and use the “Offline activation” flow.
7. Download the activation response file (often .rsp or .xml).
8. Transfer the response file back to the offline machine.
9. In SQL Prompt’s Licensing dialog on the offline machine, import the response file to complete activation.
10. Confirm activation status in the Licensing dialog; restart SSMS/Visual Studio if required.