SQL Prompt now uses a dedicated Microsoft Entra ID application to authenticate users to Azure SQL Database instances.
The permissions requested are limited to those required to access the database as your user, and your data remains within your infrastructure at all times. Redgate do not have any access to your databases, and SQL Prompt does not have access to any other services beyond Azure SQL Database.
Depending on your organization's Microsoft Entra ID policies, you may require approval from your Microsoft Entra ID administrator to grant SQL Prompt access when you first connect to an Azure SQL Database. They can review and approve this request by visiting Enterprise Applications, then Admin Consent Requests, in the Microsoft Azure portal.
Was this article helpful?
Articles in this section
- Entra ID MFA Authentication
- Add SQL History to a shared folder
- Error: Something went wrong while signing in. Authentication failed.
- Migrating snippets, styles and SQLHistory to another installation
- Why SQL Prompt?
- About SQL Prompt
- SQL Prompt Requirements
- Installing and running SQL Prompt
- Installing/Activating SQL Prompt from the .msi File
- Managing SQL Prompt behavior