MappedClassType: unknown property. when using New-DbaCredential

[MrJackDuaner]

Good morning,

I want to migrate one or more databases from SQL Azure to SQL Server by using a temporary Azure storage for the backup.
I found this detailed article on how to do it : Automate migration to SQL Managed Instance using Azure PowerShell and DbaTools

The connections to the databases are running fine, same for the creation of the resource group, the storage account and storage container.
But when the New-DbaCredential occurs, the error "MappedClassType: unknown property." is displayed.

Here is a short version of my script for debugging :

cls

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

Install-Module -Name dbatools

$STORAGE_LOCATION = "francecentral"
$STORAGE_TEMP_RESOURCE_GROUP = "tmpsqlmigrationgroup"
$STORAGE_TEMP_ACCOUNT_NAME = "tmpsqlmigrationstorage"
$STORAGE_TEMP_CONTAINER_NAME = "tmpsqlmigrationcontainer"

Connect-AzAccount -Tenant "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" -Subscription "SUBSCRIPTIONNAME"

$oisaCredentials = $Host.UI.PromptForCredential(
    "SQL Azure credentials (origin instance)",
    "SQL Azure credentials (origin instance) - Please enter valid SQL user admin privileges credentials.",
    "",
    "",
    [System.Management.Automation.PSCredentialTypes]::Generic,
    [System.Management.Automation.PSCredentialUIOptions]::None
)

New-AzResourceGroup -Name $STORAGE_TEMP_RESOURCE_GROUP -Location $STORAGE_LOCATION

$storageAccount = New-AzStorageAccount -ResourceGroupName $STORAGE_TEMP_RESOURCE_GROUP -Name $STORAGE_TEMP_ACCOUNT_NAME -Location $STORAGE_LOCATION -SkuName Standard_LRS -Kind StorageV2
$storageCtx = $storageAccount.Context

New-AzStorageContainer -Name $STORAGE_TEMP_CONTAINER_NAME -Context $storageCtx -Permission Container

$sasTokenOrigin = (New-AzStorageAccountSASToken -Service Blob -ResourceType Object -Permission "rw" -Context $storageCtx).TrimStart('?')

$instanceOrigin = Connect-DbaInstance -SqlInstance "INSTANCENAME.database.windows.net" -SqlCredential $oisaCredentials

$storageCredentialsOrigin = New-DbaCredential -SqlInstance $instanceOrigin -Name "https://$($STORAGE_TEMP_ACCOUNT_NAME).blob.core.windows.net/$($STORAGE_TEMP_CONTAINER_NAME)" -Identity "SHARED ACCESS SIGNATURE" -SecurePassword (ConvertTo-SecureString $sasTokenOrigin -AsPlainText -Force) -Force -EnableException

And here is the output of the PowerShell console :

Account            SubscriptionName TenantId                             Environment
-------            ---------------- --------                             -----------                                    
MYACCOUNT          SUBSCRIPTIONNAME xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx AzureCloud
ResourceGroupName : tmpsqlmigrationgroup
Location          : francecentral
ProvisioningState : Succeeded
Tags              :
TagsTable         :
ResourceId        : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/tmpsqlmigrationgroup
ManagedBy         :

AVERTISSEMENT : Upcoming breaking changes in the cmdlet 'New-AzStorageAccount' :
Default value of AllowBlobPublicAccess will be changed from True to False in a future release. When
AllowBlobPublicAccess is False on a storage account, it is not permitted to configure container ACLs to allow anonymous
 access to blobs within the storage account.
Cmdlet invocation changes :
    Old Way : AllowBlobPublicAccess is set to True by defult.
    New Way : AllowBlobPublicAccess is set to False by default.
Note : Go to https://aka.ms/azps-changewarnings for steps to suppress this breaking change warning, and other
information on breaking changes in Azure PowerShell.

CloudBlobContainer      : Microsoft.Azure.Storage.Blob.CloudBlobContainer
Permission              : Microsoft.Azure.Storage.Blob.BlobContainerPermissions
AccessPolicy            :
PublicAccess            : Container
LastModified            : 03/05/2023 08:54:18 +00:00
ContinuationToken       :
IsDeleted               :
VersionId               :
BlobContainerClient     : Azure.Storage.Blobs.BlobContainerClient
BlobContainerProperties : Azure.Storage.Blobs.Models.BlobContainerProperties
Context                 : Microsoft.WindowsAzure.Commands.Storage.AzureStorageContext
Name                    : tmpsqlmigrationcontainer

MappedClassType: unknown property.
Au caractère Ligne:151093 : 9
+         throw $records[0]
+         ~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: ([https://tmpsql...ationcontainer]:Credential) [], Exception
    + FullyQualifiedErrorId : dbatools_New-DbaCredential

I have searched for days a solution on the Web, but I didn't succeed.
The error comes from New-DbaCredential function when creating new object Microsoft.SqlServer.Management.Smo.Credential :

$credential = New-Object Microsoft.SqlServer.Management.Smo.Credential -ArgumentList $server, $Name
$credential.MappedClassType = $mappedClass

I thought the error occured because I didn't have SMO on my computer, so I've downloaded NuGet Package Microsoft.SqlServer.SqlManagementObjects and loaded the file Microsoft.SqlServer.Smo.dll in my script, but it didn't fix the issue.

Any help on how I can solve this issue is welcome and thanks in advance for the answers.

[potatoqualitee]

I can repro this when New-Object Microsoft.SqlServer.Management.Smo.Credential is an array (like New-Object Microsoft.SqlServer.Management.Smo.Credential -OutVariable a; $a.MappedClassType = 1)

I'll take a look and see how i can fix it 👍🏼

[MrJackDuaner]

Good morning. Did you find a solution on how to fix this? Best regards.