Skip to main content

Missing Managed Identity on Azure Synapse Analytics

 There was a case when the Azure Subscription was moving from one owner to another. It was accidentally move another tenant's subscriptions. There was interesting thing happened. Azure Synapse System Assigned Manage Identity (MID) was missing. All other linked jobs were failed to connected to Synapse.

Usually MID missing is easy to fix. But since Synapse is managed by Microsoft and there's not simple way to just apply back MID.

So I contacted Microsoft Technical Support. Initial troubleshooting was not straight forward, the support guy was trying to help using existing Microsoft Documentation. But all were outdated, later on he managed to find internal article which is not published yet in Public Microsoft Documentation.

So here is the command to fix the missing MID.

Firstly, Delete all identities on the Synapse Analytics.

az rest --method patch --url https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}?api-version=2021-06-01 --headers Content-Type=application/json  --body '{ \"identity\":{\"type\":\"None\"}}'

Next recreate the system assigned managed identity

 az rest --method patch --url https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}?api-version=2021-06-01 --headers Content-Type=application/json  --body '{ \"identity\":{\"type\":\"SystemAssigned\"}}'

That's all.
Labels:

Comments

Post a Comment

Popular posts from this blog

Unable to launch IPMI with Java version 1.8.131

I have issue with launching IPMI after java JRE version update 1.8.131. "Error: unsigned application requesting unrestricted access to system the following resource is signed with a weak signature algorithm MD5withRSA and is treated as unsigned" The resolution is you can comment out java.security under C:\Program Files\Java\jre1.8.0_131\lib\security #jdk.jar.disabledAlgorithms=MD2, MD5, RSA keySize < 1024 you will able to launch JNLP file without issue.
Post a Comment
Read more

How to extend multiple Windows VM's HDD in VMware vCenter with PowerShell PowerCLI

If you want to extend multiple VM's HDD drive in one go, below script is useful. I've extended 10 Windows VM's HDD in 4 minutes.  Create below script in notepad and save as "extendhdd.ps1". At the same time create another text file and put all servers line by line. eg. in host.txt server1 server2 server3 So if you want to run the script, open your PowerCLI from one of the servers and put two files " ___extendhdd.ps1____ $GuestUser="domain\account" $GuestPassword="xxxx" $hosts = get-content hosts.txt foreach ($server in $hosts) { Get-HardDisk -vm $server | where {$_.Name -eq "Hard Disk 2"} | Set-HardDisk -CapacityKB 15728640 -Confirm:$false Invoke-VMScript -VM $server -ScriptText "ECHO RESCAN > F:\DiskPart.txt && ECHO SELECT Volume F >> F:\DiskPart.txt && ECHO EXTEND >> F:\DiskPart.txt && ECHO EXIT >> F:\DiskPart.txt && DiskP...
Post a Comment
Read more

Fixing Acer Aspire Z3-605 All-in-one speaker buzzing noise - Part 1

 My Acer Aspire Z3-605 AIO PC speaker has buzzing noise. So I decided to replace the speaker. Unscrew 8 screw from the back side. Total 8 screw at back side Pry up starting from below silver color area. Take out speaker You can see the vibrating membrane or sound film has melted. I search in ebay and the price is about USD $19. So I decided to open and see whether I can just replace the speaker only.  The size of the speaker is 24mm diameter and 10mm thickness. I don't see any label or model no on the back side. I search in google about the wattage of the speaker found it's 3 watts. Then I measured with multimeter and it's 4 ohm. So I searched in China site and found the speaker about SGD $2.  So I just purchased 2 pieces and approximately 2 weeks time to reach to Singapore.  To be continued
1 comment
Read more