search

microsoft / azuredatastudio

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.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.55k stars 899 forks source link

Cannot add account when publishing project to new Azure server #19448

Open zijchen opened 2 years ago

zijchen commented 2 years ago

Steps to Reproduce:

  1. Publish database project that targets Azure
  2. Select "Publish to new Azure SQL logical server"
  3. Prompts me to "Add Account", but when I click on it, it takes me to a localhost page that fails to load

image

llali commented 2 years ago

this might be related https://github.com/microsoft/azuredatastudio/issues/15342

dsv-brazil-user-0 commented 2 years ago

I have the exact same issue. Is there another way to publish a DB project in Azure?

llali commented 2 years ago

Hi @dsv-brazil-user-0 you can always create the server in Azure portal and use the option" publish to existing server" to deploy the project.

llali commented 2 years ago

the other workaround is to change the authentication method of Azure Active Directory in settings to DeviceCode. Using that authentication, user will be able to login to Azure even if the default auth type doesn't work image