register sql server to azure arc but failed with errors. please follow below steps to try and if it still not work please let me know, we can setup a remote session next time.
Before starting our next teams session, I would like to confirm if you have fully meet the Prerequisites:
https://learn.microsoft.com/en-us/sql/sql-server/end-of-support/sql-server-extended-security-updates?view=sql-server-ver16#register-instances-for-esus
1. How to assign Azure Connected SQL Server Onboarding roles in azure portal:
https://learn.microsoft.com/en-us/azure/role-based-access-control/role-assignments-portal?tabs=current
2. How to Assign Microsoft.AzureArcData under your subscription :
Subscriptions->subscription name->settings-> Resource providers->search arc->make sure the status is registered
If Microsoft.AzureArcData is not registered, please follow below steps to register resource provider:
https://learn.microsoft.com/en-us/powershell/module/az.resources/register-azresourceprovider?view=azps-8.3.0
# Run with powershell with administrator
# install az.resource module
PS C:\WINDOWS\system32> Install-Module -Name Az.Resources -RequiredVersion 2.5.0
# connect to your azure account
PS C:\WINDOWS\system32> Connect-AzAccount
# register the resource provider
PS C:\Users\hubo> Register-AzResourceProvider -ProviderNamespace Microsoft.AzureArcData
# Check register status
PS C:\Users\hubo> Get-AzResourceProvider -ProviderNamespace Microsoft.AzureArcData
After above steps, you should be fully prepared to register sql server to azure arc. then you can follow below steps to register to azure arc:
https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/connect?view=sql-server-ver16&tabs=azure%2Cwindows
if you still have any register issues , please feel free to let me know. have a nice day.