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

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
Most helpful Newest Oldest

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.