Articles
Sort by recent activity
Redgate SQL Toolbelt needs permission to access resources in your organisation that only an admin can grant.
If you're using Microsoft Entra ID authentication and seeing this window when trying to use your Redgate tools: Please refer to this article and ensure that the 'Admin consent requests' option is e...
SSMS 22 freezes while importing SQL Prompt settings for the first time
While importing settings from SSMS 21 (or older versions) into SSMS 22, SSMS freezes on the import screen and does not proceed if SQL Prompt is present on the machine.This import issue occurs only ...
SSO login failed: Your e-mail address domain didn't match your organization's domain
We use home realm discovery during login. After a successful login with your IdP the domain in the email claim must match the domain of the email address the login was initiated with. You may be ab...
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...
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\SqlHistoryIndexDelete the contents of the SqlHistoryIndex folderRe-open SSMS and open SQL History and try...
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...