BC21 Encryption Keys for SQL Server Authentication Error

[sami3187]

if (!$RestartingInstance) {

Write-Host „Use custom user to access database“
$DatabaseUserName = „DBAdmin“
$DatabasePassword = „D$1234567“
$EncryptionPassword = „abc123ABC$%&abc123“
$TrustSQLServerCertificate = $true
$ServiceTierFolder = „C:\Keys\“
$DatabaseServer = „sqlxx.database.windows.net“
$DatabaseSecurePassword = ConvertTo-SecureString -String $DatabasePassword -AsPlainText -Force
$DatabaseCredentials = New-Object PSCredential -ArgumentList $DatabaseUserName, $DatabaseSecurePassword
$DatabaseName = „BC210-DB“
$EncryptionKeyPath = Join-Path $ServiceTierFolder ‚BC.key‘
$EncryptionSecurePassword = ConvertTo-SecureString -String $EncryptionPassword -AsPlainText -Force
New-NAVEncryptionKey -KeyPath $EncryptionKeyPath -Password $EncryptionSecurePassword -Force | Out-Null

Write-Host „Import Encryption Key“

Import-NAVEncryptionKey -ServerInstance DAF
-ApplicationDatabaseServer $DatabaseServer
-ApplicationDatabaseCredentials $DatabaseCredentials
-ApplicationDatabaseName $DatabaseName
-KeyPath $EncryptionKeyPath
-Password $EncryptionSecurePassword
-WarningAction SilentlyContinue
-Force

Set-NAVServerConfiguration -ServerInstance „DAF“ -KeyName „EnableSqlConnectionEncryption“ -KeyValue „true“ -WarningAction SilentlyContinue
Set-NAVServerConfiguration -ServerInstance „DAF“ -KeyName „TrustSQLServerCertificate“ -KeyValue $TrustSQLServerCertificate.Tostring().ToLowerInvariant() -WarningAction SilentlyContinue
Set-NavServerConfiguration -serverinstance „DAF“ -databaseCredentials $DatabaseCredentials
}

Any Suggestions for the below error cause.

Error :

[KennieNP]

The error message suggests that you check which permissions the user running the PoSh script has on the database. Did you doublecheck that?

[samimsc]

Thanks for your reply .
how to check that "check which permissions the user running the PoSh script has on the database."

[samimsc]

Do we need App Registrations in Azure Portal ?

[samimsc]

@KennieNP Could you please advise. thanks.

[KennieNP]

Thanks for your reply . how to check that "check which permissions the user running the PoSh script has on the database."

You can use SSMS to see users and their permissions