Azure-docs: Tags: Microsoft.Sql ManagedInstances / Databases should be "No" for not supported

[tameika]

Hi, this documentation says that tags are supported (marked "Yes) for Microsoft.Sql resource type "managedInstances / databases". However, I just worked with an Azure customer who could not apply it via Portal. I tested the scenario myself and applying tags for an individual Managed Instance database is not possible in Portal, CLI, or PowerShell (the output for the properties comes out blank). It is only supported for the Managed Instance not the MI DBs.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 66769e1b-720b-f1b1-a5e3-ed5cb24cd233
• Version Independent ID: b6272e61-58c1-3e2f-3e36-a9ee920c0915
• Content: Tag support for resources - Azure Resource Manager
• Content Source: articles/azure-resource-manager/management/tag-support.md
• Service: azure-resource-manager
• Sub-service: management
• GitHub Login: @tfitzmac
• Microsoft Alias: tomfitz

[BharathNimmala-MSFT]

@tameika Thanks a lot for bringing this to our notice, we will review and update the document accordingly.

[tfitzmac]

@tameika - I tested adding a tag to a managed instance database and it worked correctly. I used PowerShell and the following commands:

$tags = @{"Dept"="Finance"; "Status"="Normal"}
$resource = Get-AzResource -Name testdb -ResourceGroup dataGroup
New-AzTag -ResourceId $resource.id -Tag $tags

[tfitzmac]

A couple of follow-up items:

There are some caveats in the note that may interfere with applying tags to the database.

And, I have added a screenshot of the PowerShell command that retrieved the resource with its tags.

[tameika]

Hi Tom, I tried with the commands you shared and it was successful. The output showed the tag applied to the individual db. Not sure what I did wrong before. Seems the only place it updates the GUI is on the instance overview page and from there selecting the tag pulls up all resources under the tag--not on db's page though.

Thank you, Tom! I'm going to inform the customer and let him know about the functionality.

[BharathNimmala-MSFT]

Thank you @tfitzmac for helping on this thread.

Thank you @tameika for helping review it and confirming that it is working and also its being visible at the instance level from UI stand point. Will further see if there is any limitation to show it only at instance level and not at DB level and share any finding we might have.

At this point it appears that there's no further edits or updates needed to the documentation. We will go ahead and close this issue, however if you have any further queries please tag us in your reply and will be happy to reopen the thread and continue the conversation. Thank you