Cannot find the Azure Active Directory object

Azure / azure-powershell

Microsoft Azure PowerShell

Other

4.11k stars 3.75k forks source link

Description

Unable to update azure sql server password with the below command when logging to azure using service principle Set-AzSqlServer -ResourceGroupName $DatabaseRg -ServerName $DatabaseServerName -SqlAdministratorPassword $dbapw Cannot find the Azure Active Directory object ''. Please make sure that the user or group or application you are authorizing is registered in the current subscription's Azure Active directory. To get a list of Azure Active Directory groups use Get-AzADGroup, or to get a list of Azure Active Directory users use Get-AzADUser or to get a list of Azure Active Directory applications use Get-AzADApplication.

Service principle has contributor access on sql server

This was working fine till az PowerShell version 6.1.0 and after that it is failing

Steps to reproduce

$azureAplicationId ="" $azureTenantId= "" $azurePassword = ConvertTo-SecureString "" -AsPlainText -Force $psCred = New-Object System.Management.Automation.PSCredential($azureAplicationId , $azurePassword) Connect-AzAccount -Credential $psCred -TenantId $azureTenantId -ServicePrincipal $ServerPassword = "" $SecureString = ConvertTo-SecureString $ServerPassword -AsPlainText -Force Set-AzSqlServer -ResourceGroupName -ServerName -SqlAdministratorPassword

if we add service principle as azure active directory admin on sql server then everything is working fine

Environment Name Value

PSVersion 7.1.4 PSEdition Core GitCommitId 7.1.4 OS Linux 5.4.0-1059-azure #62~18.04.1-Ubuntu SMP Tue Sep 14 17:53:18 UTC 2021 Platform Unix PSCompatibleVersions {1.0, 2.0, 3.0, 4.0…} PSRemotingProtocolVersion 2.3 SerializationVersion 1.1.0.1 WSManStackVersion 3.0

Az modules

Script 6.5.0 Az Script 2.5.4 Az.Accounts Script 1.1.1 Az.Advisor Script 2.4.0 Az.Aks Script 1.1.4 Az.AnalysisServices Script 2.3.0 Az.ApiManagement Script 1.0.0 Az.AppConfiguration Script 1.2.0 Az.ApplicationInsights Script 1.0.0 Az.Attestation Script 1.7.1 Az.Automation Script 3.1.0 Az.Batch Script 2.0.0 Az.Billing Script 1.8.1 Az.Cdn Script 1.9.0 Az.CognitiveServices Script 4.17.1 Az.Compute Script 2.1.0 Az.ContainerInstance Script 2.2.3 Az.ContainerRegistry Script 1.3.1 Az.CosmosDB Script 1.1.0 Az.DataBoxEdge Script 1.1.0 Az.Databricks Script 1.15.0 Az.DataFactory Script 1.0.2 Az.DataLakeAnalytics Script 1.3.0 Az.DataLakeStore Script 1.0.0 Az.DataShare Script 1.1.0 Az.DeploymentManager Script 3.0.0 Az.DesktopVirtualization Script 1.0.2 Az.DevTestLabs Script 1.1.2 Az.Dns Script 1.3.0 Az.EventGrid Script 1.8.0 Az.EventHub Script 1.9.0 Az.FrontDoor Script 3.1.0 Az.Functions Script 0.10.8 Az.GuestConfiguration Script 4.3.0 Az.HDInsight Script 1.3.1 Az.HealthcareApis Script 2.7.3 Az.IotHub Script 3.6.0 Az.KeyVault Script 2.0.0 Az.Kusto Script 1.5.0 Az.LogicApp Script 1.1.3 Az.MachineLearning Script 1.2.0 Az.Maintenance Script 2.0.0 Az.ManagedServices Script 1.0.2 Az.MarketplaceOrdering Script 1.1.1 Az.Media Script 1.1.1 Az.Migrate Script 2.7.0 Az.Monitor Script 4.12.0 Az.Network Script 1.1.1 Az.NotificationHubs Script 2.3.0 Az.OperationalInsights Script 1.4.1 Az.PolicyInsights Script 1.1.2 Az.PowerBIEmbedded Script 1.0.3 Az.PrivateDns Script 4.7.0 Az.RecoveryServices Script 1.5.0 Az.RedisCache Script 1.0.0 Az.RedisEnterpriseCache Script 1.0.3 Az.Relay Script 1.0.0 Az.ResourceMover Script 4.4.0 Az.Resources Script 1.0.0 Az.Security Script 1.1.0 Az.SecurityInsights Script 1.5.0 Az.ServiceBus Script 3.0.1 Az.ServiceFabric Script 1.3.0 Az.SignalR Script 3.5.1 Az.Sql Script 1.1.0 Az.SqlVirtualMachine Script 3.12.0 Az.Storage Script 1.6.1 Az.StorageSync Script 2.0.0 Az.StreamAnalytics Script 1.0.0 Az.Support Script 1.0.4 Az.TrafficManager Script 2.8.3 Az.Websites Script 0.0.0.10 AzureAD.Standard.Preview Script 0.9.3 AzurePSDrive Script 17.0.4716… EXOPSSessionConnector Binary 0.1.1 Microsoft.Po Manifest 1.0.867 MicrosoftPowerBIMgmt Binary 1.0.867 MicrosoftPow Binary 1.0.867 MicrosoftPow Binary 1.0.867 MicrosoftPowerBIMgmt.Data Binary 1.0.867 MicrosoftPow Binary 1.0.867 MicrosoftPow Binary 1.0.867 MicrosoftPow Script 2.6.0 MicrosoftTeams Binary 1.1.6 MicrosoftTeams Script 0.9.3 PSCloudShellUtility Binary 0.8.1 SHiPS Script 21.1.18229 SqlServer Core,Desk Core,Desk {Disable-AzDataCollection, Disable-AzContextAutosave, Enable-AzDataCollection, Enable-AzCo… Core,Desk {Get-AzAdvisorRecommendation, Enable-AzAdvisorRecommendation, Disable-AzAdvisorRecommendat… Core,Desk {Get-AzAksCluster, New-AzAksCluster, Remove-AzAksCluster, Import-AzAksCredential…} Core,Desk {Resume-AzAnalysisServicesServer, Suspend-AzAnalysisServicesServer, Get-AzAnalysisServices… Core,Desk {Add-AzApiManagementApiToGateway, Add-AzApiManagementApiToProduct, Add-AzApiManagementProd… Core,Desk {Get-AzAppConfigurationStore, Get-AzAppConfigurationStoreKey, New-AzAppConfigurationStore,… Core,Desk {Get-AzApplicationInsights, New-AzApplicationInsights, Remove-AzApplicationInsights, Updat… Core,Desk {New-AzAttestation, Get-AzAttestation, Remove-AzAttestation, Get-AzAttestationPolicy…} Core,Desk {Get-AzAutomationHybridWorkerGroup, Remove-AzAutomationHybridWorkerGroup, Get-AzAutomation… Core,Desk {Remove-AzBatchAccount, Get-AzBatchAccount, Get-AzBatchAccountKey, New-AzBatchAccount…} Core,Desk {Get-AzBillingInvoice, Get-AzBillingPeriod, Get-AzEnrollmentAccount, Get-AzConsumptionBudg… Core,Desk {Get-AzCdnProfile, Get-AzCdnProfileSsoUrl, New-AzCdnProfile, Remove-AzCdnProfile…} Core,Desk {Get-AzCognitiveServicesAccount, Get-AzCognitiveServicesAccountKey, Get-AzCognitiveService… Core,Desk {Remove-AzAvailabilitySet, Get-AzAvailabilitySet, New-AzAvailabilitySet, Update-AzAvailabi… Core,Desk {Add-AzContainerInstanceOutput, Get-AzContainerGroup, Get-AzContainerInstanceCachedImage, … Core,Desk {New-AzContainerRegistry, Get-AzContainerRegistry, Update-AzContainerRegistry, Remove-AzCo… Core,Desk {Get-AzCosmosDBSqlContainer, Get-AzCosmosDBSqlContainerThroughput, Get-AzCosmosDBSqlDataba… Core,Desk {Get-AzDataBoxEdgeJob, Get-AzDataBoxEdgeDevice, Invoke-AzDataBoxEdgeDevice, New-AzDataBoxE… Core,Desk {Get-AzDatabricksVNetPeering, Get-AzDatabricksWorkspace, New-AzDatabricksVNetPeering, New-… Core,Desk {Set-AzDataFactoryV2, Update-AzDataFactoryV2, Get-AzDataFactoryV2, Remove-AzDataFactoryV2…} Core,Desk {Get-AzDataLakeAnalyticsDataSource, New-AzDataLakeAnalyticsCatalogCredential, Remove-AzDat… Core,Desk {Get-AzDataLakeStoreTrustedIdProvider, Remove-AzDataLakeStoreTrustedIdProvider, Remove-AzD… Core,Desk {New-AzDataShareAccount, Get-AzDataShareAccount, Remove-AzDataShareAccount, New-AzDataShar… Core,Desk {Get-AzDeploymentManagerArtifactSource, New-AzDeploymentManagerArtifactSource, Set-AzDeplo… Core,Desk {Disconnect-AzWvdUserSession, Expand-AzWvdMsixImage, Get-AzWvdApplication, Get-AzWvdApplic… Core,Desk {Get-AzDtlAllowedVMSizesPolicy, Get-AzDtlAutoShutdownPolicy, Get-AzDtlAutoStartPolicy, Get… Core,Desk {Get-AzDnsRecordSet, New-AzDnsRecordConfig, Remove-AzDnsRecordSet, Set-AzDnsRecordSet…} Core,Desk {New-AzEventGridTopic, Get-AzEventGridTopic, Set-AzEventGridTopic, New-AzEventGridTopicKey… Core,Desk {New-AzEventHubNamespace, Get-AzEventHubNamespace, Set-AzEventHubNamespace, Remove-AzEvent… Core,Desk {New-AzFrontDoor, Get-AzFrontDoor, Set-AzFrontDoor, Remove-AzFrontDoor…} Core,Desk {Get-AzFunctionApp, Get-AzFunctionAppAvailableLocation, Get-AzFunctionAppPlan, Get-AzFunct… Core,Desk {Get-AzVMGuestPolicyStatus, Get-AzVMGuestPolicyStatusHistory} Core,Desk {Get-AzHDInsightJob, New-AzHDInsightSqoopJobDefinition, Wait-AzHDInsightJob, New-AzHDInsig… Core,Desk {New-AzHealthcareApisService, Remove-AzHealthcareApisService, Set-AzHealthcareApisService,… Core,Desk {Add-AzIotHubKey, Get-AzIotHubEventHubConsumerGroup, Get-AzIotHubConnectionString, Get-AzI… Core,Desk {Add-AzKeyVaultCertificate, Update-AzKeyVaultCertificate, Stop-AzKeyVaultCertificateOperat… Core,Desk {Add-AzKustoClusterLanguageExtension, Add-AzKustoDatabasePrincipal, Get-AzKustoAttachedDat… Core,Desk {Get-AzIntegrationAccountAgreement, Get-AzIntegrationAccountAssembly, Get-AzIntegrationAcc… Core,Desk {Move-AzMlCommitmentAssociation, Get-AzMlCommitmentAssociation, Get-AzMlCommitmentPlanUsag… Core,Desk {Get-AzApplyUpdate, Get-AzConfigurationAssignment, Get-AzMaintenanceConfiguration, Get-AzM… Core,Desk {Get-AzManagedServicesAssignment, New-AzManagedServicesAssignment, Remove-AzManagedService… Core,Desk {Get-AzMarketplaceTerms, Set-AzMarketplaceTerms} Core,Desk {Sync-AzMediaServiceStorageKey, Set-AzMediaServiceKey, Get-AzMediaServiceKey, Get-AzMediaS… Core,Desk {Get-AzMigrateDiscoveredServer, Get-AzMigrateJob, Get-AzMigrateProject, Get-AzMigrateRepli… Core,Desk {Get-AzMetricDefinition, Get-AzMetric, Remove-AzLogProfile, Get-AzLogProfile…} Core,Desk {Add-AzApplicationGatewayAuthenticationCertificate, Get-AzApplicationGatewayAuthentication… Core,Desk {Get-AzNotificationHub, Get-AzNotificationHubAuthorizationRule, Get-AzNotificationHubListK… Core,Desk {New-AzOperationalInsightsAzureActivityLogDataSource, New-AzOperationalInsightsCustomLogDa… Core,Desk {Get-AzPolicyEvent, Get-AzPolicyState, Get-AzPolicyStateSummary, Get-AzPolicyRemediation…} Core,Desk {Remove-AzPowerBIWorkspaceCollection, Get-AzPowerBIWorkspaceCollection, Get-AzPowerBIWorks… Core,Desk {Get-AzPrivateDnsZone, Remove-AzPrivateDnsZone, Set-AzPrivateDnsZone, New-AzPrivateDnsZone… Core,Desk {Get-AzRecoveryServicesBackupProperty, Get-AzRecoveryServicesVault, Get-AzRecoveryServices… Core,Desk {Remove-AzRedisCachePatchSchedule, New-AzRedisCacheScheduleEntry, Get-AzRedisCachePatchSch… Core,Desk {Export-AzRedisEnterpriseCache, Get-AzRedisEnterpriseCache, Get-AzRedisEnterpriseCacheData… Core,Desk {New-AzRelayNamespace, Get-AzRelayNamespace, Set-AzRelayNamespace, Remove-AzRelayNamespace… Core,Desk {Add-AzResourceMoverMoveResource, Get-AzResourceMoverMoveCollection, Get-AzResourceMoverMo… Core,Desk {Get-AzProviderOperation, Remove-AzRoleAssignment, Get-AzRoleAssignment, New-AzRoleAssignm… Core,Desk {Get-AzSecurityAlert, Set-AzSecurityAlert, Get-AzSecurityAutoProvisioningSetting, Set-AzSe… Core,Desk {Get-AzSentinelAlertRuleAction, New-AzSentinelAlertRuleAction, Remove-AzSentinelAlertRuleA… Core,Desk {New-AzServiceBusNamespace, Get-AzServiceBusNamespace, Set-AzServiceBusNamespace, Remove-A… Core,Desk {Add-AzServiceFabricClientCertificate, Add-AzServiceFabricNode, Add-AzServiceFabricNodeTyp… Core,Desk {New-AzSignalR, Get-AzSignalR, Get-AzSignalRKey, New-AzSignalRKey…} Core,Desk {Get-AzSqlDatabaseTransparentDataEncryption, Get-AzSqlDatabaseTransparentDataEncryptionAct… Core,Desk {New-AzSqlVM, Get-AzSqlVM, Update-AzSqlVM, Remove-AzSqlVM…} Core,Desk {Get-AzStorageAccount, Get-AzStorageAccountKey, New-AzStorageAccount, New-AzStorageAccount… Core,Desk {Invoke-AzStorageSyncCompatibilityCheck, New-AzStorageSyncService, Get-AzStorageSyncServic… Core,Desk {Get-AzStreamAnalyticsCluster, Get-AzStreamAnalyticsClusterStreamingJob, Get-AzStreamAnaly… Core,Desk {Get-AzSupportService, Get-AzSupportProblemClassification, Get-AzSupportTicket, Get-AzSupp… Core,Desk {Add-AzTrafficManagerCustomHeaderToEndpoint, Remove-AzTrafficManagerCustomHeaderFromEndpoi… Core,Desk {Get-AzAppServicePlan, Set-AzAppServicePlan, New-AzAppServicePlan, Remove-AzAppServicePlan… Desk {Remove-AzureADUser, Get-AzureADUserExtension, Remove-AzureADDevice, Get-AzureADGroupOwner… Desk Desk Connect-EXOPSSession werShell.UnixCompleters Core {Import-UnixCompleters, Remove-UnixCompleters, Set-UnixCompleter} Desk erBIMgmt.Admin Desk {Add-PowerBIEncryptionKey, Get-PowerBIEncryptionKey, Get-PowerBIWorkspaceEncryptionStatus,… erBIMgmt.Capacities Desk Get-PowerBICapacity Desk {Add-PowerBIDataset, Set-PowerBITable, New-PowerBIDataset, New-PowerBITable…} erBIMgmt.Profile Desk {Connect-PowerBIServiceAccount, Disconnect-PowerBIServiceAccount, Invoke-PowerBIRestMethod… erBIMgmt.Reports Desk {Get-PowerBIReport, New-PowerBIReport, Export-PowerBIReport, Get-PowerBIDashboard…} erBIMgmt.Workspaces Desk {Get-PowerBIWorkspace, Get-PowerBIWorkspaceMigrationStatus, Add-PowerBIWorkspaceUser, Remo… Core,Desk {Add-TeamUser, Connect-MicrosoftTeams, Disconnect-MicrosoftTeams, Get-MultiGeoRegion…} Core,Desk {Add-TeamUser, Connect-MicrosoftTeams, Disconnect-MicrosoftTeams, Get-CsPolicyPackage…} Desk {Enter-AzVM, Get-AzCommand, Invoke-AzVMCommand, Enable-AzVMPSRemoting…} Desk Desk {Add-RoleMember, Add-SqlAvailabilityDatabase, Add-SqlAvailabilityGroupListenerStaticIp, Ad…

Directory: /opt/microsoft/powershell/7/Modules

ModuleType Version PreRelease Name PSEdition ExportedCommands

Manifest 1.2.5 Microsoft.PowerShell.Archive Desk {Compress-Archive, Expand-Archive} Manifest 7.0.0.0 Microsoft.PowerShell.Host Core {Start-Transcript, Stop-Transcript} Manifest 7.0.0.0 Microsoft.PowerShell.Management Core {Add-Content, Clear-Content, Clear-ItemProperty, Join-Path…} Manifest 7.0.0.0 Microsoft.PowerShell.Security Core {Get-Credential, Get-ExecutionPolicy, Set-ExecutionPolicy, ConvertFrom-SecureString…} Manifest 7.0.0.0 Microsoft.PowerShell.Utility Core {Export-Alias, Get-Alias, Import-Alias, New-Alias…} Script 1.4.7 PackageManagement Desk {Find-Package, Get-Package, Get-PackageProvider, Get-PackageSource…} Script 2.2.5 PowerShellGet Desk {Find-Command, Find-DSCResource, Find-Module, Find-RoleCapability…} Script 2.0.5 PSDesiredStateConfiguration Core {Configuration, New-DscChecksum, Get-DscResource, Invoke-DscResource} Script 2.1.0 PSReadLine Desk {Get-PSReadLineKeyHandler, Set-PSReadLineKeyHandler, Remove-PSReadLineKeyHandler, Get-PSRe… Binary 2.0.3 ThreadJob Desk Start-ThreadJob

Author:	DivyaKalikiri
Assignees:	-
Labels:	`SQL`, `Service Attention`, `question`, `customer-reported`, `needs-triage`
Milestone:	-

Author:

DivyaKalikiri

Assignees:

Labels:

`SQL`, `Service Attention`, `question`, `customer-reported`, `needs-triage`

Milestone:

Azure / azure-powershell

Cannot find the Azure Active Directory object #16069

Description

Steps to reproduce