Share via

Azure Managed Instance - Security Roles Removed

Mark Gordon 926 Reputation points
2022-12-06T17:34:08.663+00:00

Fellow SQL dbas
I am trying to find out which Server Level Roles have been REMOVED when you migrated to Azure SQL MANAGED INSTANCE.
I see links about what they have and how some of them kind-of do the same thing as regular NONAzure server roles.

I just need to know which ones are truly gone and not being able to be mapped to something else.

Any links would be helpful.
Thx
MG

Azure SQL Database
0 comments No comments

Answer accepted by question author

Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
2022-12-06T22:52:38.75+00:00

The following list of server roles are not present on Azure SQL Managed Instance:

"##MS_DatabaseConnector##"
"##MS_LoginManager##"
"##MS_DatabaseManager##"
"##MS_ServerStateManager##"
"##MS_ServerStateReader##"
"##MS_ServerPerformanceStateReader##"
"##MS_ServerSecurityStateReader##"
"##MS_DefinitionReader##"
"##MS_PerformanceDefinitionReader##"
"##MS_SecurityDefinitionReader##"

All other fixed server roles are present on both SQL Server and Managed Instance. Please read here.

Was this answer helpful?


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.