If you haven’t specified your Azure Account in Azure Data Studio before, you will need to add a new Azure AD account to authenticate with (this will only need to be done once):Īdding an Azure AD account to Azure Data Studio You can see that we didn’t have to specify a password, and instead selected the Azure AD Account we wanted to use.Īdding an Azure AD account in Azure Data Studio Here we’ve filled this out so we’re authenticating with our personal username in my case), and we’re connecting to the Postgres database that we previously provisioned. This changes our connection menu with new options:Ĭonnection dialog with Azure Active Directory authentication type selected
AZURE DATA STUDIO POSTGRESQL INSTALL
If you haven’t already, make sure you install the latest version of the PostgreSQL extension to Azure Data Studio.Īnd we’ll select the new Authentication type, Azure Active Directory:Īuthentication type choice - selecting "Azure Active Directory" Signing into PostgreSQL using Azure Data Studio Once the operation has completed, we can now sign-in with our user to the database: There, we will set our own user account as the administrator:Īzure Portal: Configure Azure Active Directory administrator for your Azure Database for PostgreSQL server We’ll start with a fresh Azure Database for PostgreSQL - Single Server database we just created and navigate to the Azure AD administrator view.
AZURE DATA STUDIO POSTGRESQL PASSWORD
Here is the quick version of how this works in Azure Data Studio - no password required!Ĭonfiguring the Azure AD Administrator in the Azure Portal Sign-in with Azure AD to Azure Database for PostgreSQL, using Azure Data Studio Today we’re happy to announce a new, simpler, way to sign-in to your Azure Database for PostgreSQL server: Using Azure Data Studio 1.16.0 ( March 2020 release) and the latest PostgreSQL extension, you can now seamlessly sign-in to your Postgres database on Azure, without specifying a password, just by selecting your Azure AD account. Previously we announced the preview of Azure AD authentication for Azure Database for PostgreSQL - Single Server, to enable use of your existing Azure Active Directory (AD) credentials for signing in-but you had to jump through a few extra steps and use a token for signing in. It’s difficult to keep track of who has access and apply security policies consistently across all your databases. Once you start having a large amount of databases, or more than one engineer on the team, management of your database users and their associated passwords can become a problem.
0 kommentar(er)
