Articles
Sort by recent activity
Prompt+ AI failed to log in
If you’re seeing this error, it may be because you’re not running a version of SQL Prompt that includes the AI features. These features are available from version 11.1.0.18267 onwards. If you’re on...
How to move subscriptions to the organization
In the customer portal go to Licenses > Your subscriptions.Select the licenses you wish to add by checking the box, then click Give to organization.
Automatic License Provisioning for Redgate Apps
Automatic license provisioning (ALP) automatically allocates licenses of Redgate products to users based on groups synced from your identity provider, removing the need to manually allocate license...
Insufficient permissions error when setting up SSO
If you encounter the "insufficient permissions" error while setting up SSO for your organization, please check that you have done the following:Ensure the email address you’re using has OrgAdmin pe...
Support for SSMS 2022
Our add-on tools (SQL Prompt, SQL Source Control, SQL Test and SQL Search) are now fully compatible with SSMS 22.
WARNING: An expired Flyway license key was provided; fell back to Community Edition.
You have a supported Flyway license and you're seeing this error message:WARNING: An expired Flyway license key was provided; fell back to Community Edition.This is because you have supplied a stat...
SQL History is blank
Follow these steps to restore SQL History:
Navigate to %localappdata%\Red Gate\SQL Prompt 11\SqlHistoryIndex
Rename the SQLHistory.db file (for example, to SQLHistory_OLD)
Re-open SSMS and a new S...
Unable to access SQL Prompt AI features
If your licence is perpetual you won't be able to access the SQL Prompt AI features. These features are only available with a subscription license.Prior to version 11.1, Prompt AI was available thr...
An error has occurred in the script on this page
You're seeing the error message "An error has occurred in the script on this page".Here's some steps you can try to resolve it:
Open the tool
Using Chrome/Edge, navigate to http://localhost:22221/r...
Failed to fetch, decode or validate the licensing permit
You run into this error when activating your license:Ensure that all the endpoints in this article are added to your AllowList:Licensing & update URLs to add to your AllowList in firewall