Skip to content

New-AzSqlDatabaseExport Can't login with SQL administrator #9154

@HelloValue

Description

@HelloValue

Description

i want export azure sql-database to storage account.
i use the following command:
$exportRequest = New-AzSqlDatabaseExport -ResourceGroupName MyGroup -ServerName mytestdbserver1 -DatabaseName MyTestDb -StorageKeytype StorageAccessKey -StorageKey TGEdegtetQoHFgrgerer5S+LGwb+Ty2OPHxSHlloworldQhtest== -StorageUri https://test.blob.core.testcloudapi.cn/mytest-container/MyTestDb-2019-5-8-11-26.bacpac,
then input my login account and password.

Steps to reproduce

$exportRequest = New-AzSqlDatabaseExport -ResourceGroupName MyGroup -ServerName mytestdbserver1 -DatabaseName MyTestDb -StorageKeytype StorageAccessKey -StorageKey TGEdegtetQoHFgrgerer5S+LGwb+Ty2OPHxSHlloworldQhtest== -StorageUri https://test.blob.core.testcloudapi.cn/mytest-container/MyTestDb-2019-5-8-11-26.bacpac

Environment data

os:windows 10
azure powershell:2.0.0
power shell:5.1
azure location:china

Name Value


PSVersion 5.1.17134.590
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.17134.590
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

Module versions

ModuleType Version Name


Script 1.5.2 Az.Accounts
Script 1.9.0 Az.Sql
Manifest 3.1.0.0 Microsoft.PowerShell.Management
Manifest 3.0.0.0 Microsoft.PowerShell.Security
Manifest 3.1.0.0 Microsoft.PowerShell.Utility
Manifest 3.0.0.0 Microsoft.WSMan.Management
Script 1.2 PSReadline

Error output

New-AzSqlDatabaseExport : 0: There was an error that occurred during this operation : 'Error encountered during the service operation. ; Exception Microsoft.SqlServer.Man
agement.Dac.Services.ServiceException:Unable to authenticate request; Inner exception System.Data.SqlClient.SqlExceptio
n:Login failed for user 'DbAdmin'.; '
所在位置 行:1 字符: 18

  • ... rtRequest = New-AzSqlDatabaseExport -ResourceGroupName MyGroup ...
  •             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    
    • CategoryInfo : CloseError: (:) [New-AzSqlDatabaseExport],CloudException
    • FullyQualifiedErrorId : Microsoft.Azure.Commands.Sql.ImportExport.Cmdlet.NewAzureSqlDatabaseExport

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions