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 - 

7 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
  3. I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you! Techesign.com

    ReplyDelete
  4. It should be noted that whilst ordering papers for sale at paper writing service, you can get unkind attitude. In case you feel that the bureau is trying to cheat you, don't buy term paper from it. rtechsh

    ReplyDelete
  5. This is very educational content and written well for a change. It's nice to see that some people still understand how to write a quality post! שרת וירטואלי

    ReplyDelete
  6. i read a lot of stuff and i found that the way of writing to clearifing that exactly want to say was very good so i am impressed and ilike to come again in future.. Europa-Road túlméretes szállítás

    ReplyDelete
  7. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. Windows based CRM

    ReplyDelete

Popular Posts