Tuesday, July 9, 2019

Azure SQL Server - Configuring Connection with DbVisualizer

In this tutorial, we will learn "How to configure connections with DbVisualizer tools " to connect with Azure SQL database or Azure SQL data warehouse from Azure SQL Server.

Note: If you don't have an Azure subscription, then create a free account before you begin.

You have to do followings-
1. Configure Client IP - We have to Add to the Allowed IP Addresses in set server firewall settings and where we can also add a range of IP addresses to allow.
2. Configure Connection String with access credentials - get the connection string to connect with.
3. Connect DbVisualizer with credentials with Azure 
4. Pull your data from database or data warehouse

Note: You don't use your Azure login ID to connect to the SQL service. You use the new credentials that are specific to the SQL database you've created via the Azure SQL Data Service console. Also, you must specify "encryptionMethod=SSL". Required for all communications with SQL Azure.

To Learn more, please visit us at YouTube - 

2 comments:

  1. The complete blogs are really inconceivable and definitely everyone will share this information.erp software dubai

    ReplyDelete
  2. Aspirants get to learn about different types of storage using the Azure data cloud. They also work on code examples to get comfortable with the technology. best AZ-900 courses

    ReplyDelete

Popular Posts