I am connecting to an Azure SQL managed instance with Active Directory through SQL Server Management Studio.

I'm trying to access system views, like:

SELECT * FROM sys.dm_db_missing_index_details
SELECT * FROM sys.dm_database_encryption_keys

I get the following error message in SQL Server Management Studio:

The module being executed is not trusted. Either the owner of the database of the module needs to be granted authenticate permission, or the module needs to be digitally signed.

SELECT CURRENT_USER says that I am logged in as "dbo".

These views work for an on-premises SQL server, so it must be an Azure Managed Instance issue.

How do I grant the SSMS user (dbo) the appropriate permissions to access system views?

  • What permissions does the login have on-premise vs. the managed instance, specifically, is the login a member of sysadmin on either, or been granted VIEW SERVER STATE on either? – HandyD May 15 '19 at 0:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.