Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
Is your feature request related to a problem? Please describe.
I am trying to use azure migration from a local SQL Server to Azure SQL Database. My local computer has a required policy that I have to use 2FA (smart card) to log into the computer.
When I try to run migration, I end up with
Schema Migration for database 'my-database' failed in state 'MonitorSqlSchemaCopy'. See migration status details for more information.
Summary of errors: Failed to migrate schema. 'Smartcard logon is required and was not used'
[
{
"errorCode": 0,
"message": "Failed to migrate schema due to 'Smartcard logon is required and was not used'",
"details": []
}
]
It would be best if the migration didn't require smart card login. I am already logged in using smart card, so policy should be satisfied.
At worst, either the message or the links from the message should contain actionable help that describes the problem and offers potential solution. I didn't know what part exactly requires smart card, what failed. Was it trying to log into the Azure or what component does require it?
Describe alternatives you've considered
I convinced our IT Service to disable required smart login on my computer and that is enough. But that requires sign-off and exception, which most departments don't like to give and is only granted for limited time.
Additional context
I am using following versions:
Azure Data Studio
Version: 1.49.1 (system setup)
Commit: 2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd
Date: 2024-08-13T18:12:38.831Z (3 wks ago)
VS Code: 1.82.0
Electron: 25.9.8
Chromium: 114.0.5735.289
Node.js: 18.15.0
V8: 11.4.183.29-electron.0
OS: Windows_NT x64 10.0.22631
Is your feature request related to a problem? Please describe.
I am trying to use azure migration from a local SQL Server to Azure SQL Database. My local computer has a required policy that I have to use 2FA (smart card) to log into the computer.
When I try to run migration, I end up with
Describe the solution or feature you'd like
It would be best if the migration didn't require smart card login. I am already logged in using smart card, so policy should be satisfied.
At worst, either the message or the links from the message should contain actionable help that describes the problem and offers potential solution. I didn't know what part exactly requires smart card, what failed. Was it trying to log into the Azure or what component does require it?
Describe alternatives you've considered
I convinced our IT Service to disable required smart login on my computer and that is enough. But that requires sign-off and exception, which most departments don't like to give and is only granted for limited time.
Additional context I am using following versions:
Azure Data Studio Version: 1.49.1 (system setup) Commit: 2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd Date: 2024-08-13T18:12:38.831Z (3 wks ago) VS Code: 1.82.0 Electron: 25.9.8 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.22631
Azure SQL Migration v1.5.4