How to connect with Azure Active Directory authentication

If you have an Azure Active Directory instance configured, you can connect to an Azure database with Azure Active Directory authentication in dbForge Studio for SQL Server.

Azure Active Directory is a Microsoft solution with a single or multi-factor authentication that ensures more secure access to the database.

In dbForge Studio for SQL Server, you can use the following authentication types of Azure Active Directory for connection:

When connecting with the Universal with MFA support authentication, dbForge Studio for SQL Server should be registered as an Azure Active Directory application. During the registration, an application ID will be generated which you need to specify to connect to the Azure database with the Universal with MFA support authentication. For more information, see How to register Studio for SQL Server as an Azure Active Directory application.

Connecting to the Azure database with Azure Active Directory - Universal with MFA support

1. In Database Explorer, click New connection.

2. In the Database Connection Properties dialog, select Azure Active Directory - Universal with MFA support as an authentication type.

3. Enter the following details:

  • Server: URL of the Azure SQL Server instance.

  • User name: Azure Active Directory user with Azure SQL database permissions.

4. Select Use common MFA options and click Change Common Options to enter the Application ID and Redirect URL generated during the registration of dbForge Studio for SQL Server.

Entering the application ID

Note

If you want to insert an alternative application ID, select Override MFA options for this connection and enter the application ID and Redirect URL.

5. In the Options window that opens, enter the application ID and click OK.

Connecting to the Azure database with Azure Active Directory - Universal with MFA support

6. Click Connect.

7. In the Sign in to your account window that opens, enter the password for the specified Azure Active Directory account. After a successful login, a set of databases for the specified Azure SQL instance becomes available.

Note

The Sign in to your account window also opens when you click Test connection or try to choose a database in the Database field.

When the connection is successful, the Database Connection Properties is closed and the connection with databases appears in Database Explorer.

If you first click Test Connection, the information you’ve entered is being validated. After that, in the pop-up window informing about a successful connection, click Connect so that the connection is displayed in Database Explorer.

Note

When you create a new connection for the same SQL Server but on another instance or another standalone dbForge SQL tool, the Application ID and Redirect URL are automatically pulled in from the corresponding values of the Options dialog.

Connecting to the Azure database with Azure Active Directory - Password

1. In Database Explorer, click New connection.

2. In the Database Connection Properties dialog, select Azure Active Directory - Password as an authentication type.

3. Enter the following details:

  • Server: URL of the Azure SQL Server instance.

  • Login: Azure Active Directory user with Azure SQL database permissions.

  • Password: Password for the specified user.

Connecting to the Azure database with Azure Active Directory - Password

4. Click Connect.

When the connection is successful, the Database Connection Properties is closed and the connection with databases appears in Database Explorer.

If you first click Test Connection, the information you’ve entered is being validated. After that, in the pop-up window informing about a successful connection, click Connect so that the connection is displayed in Database Explorer.

Connecting to the Azure database with Azure Active Directory - Integrated

1. In Database Explorer, click New connection.

2. In the Database Connection Properties dialog, select Azure Active Directory - Password as an authentication type.

3. In the Server field, enter a URL of the Azure SQL Server instance and click Connect.

Connecting to the Azure database with Azure Active Directory - Integrated

When the connection is successful, the Database Connection Properties is closed and the connection with databases appears in Database Explorer.

If you first click Test Connection, the information you’ve entered is being validated. After that, in the pop-up window informing about a successful connection, click Connect so that the connection is displayed in Database Explorer.