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 - 

Posted by at
Labels: , , , ,

7 comments:

  1. Lawrence FergusonJul 11, 2020, 9:21:00 AM

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

    ReplyDelete
  2. Ali janSep 21, 2020, 1:28:00 PM

    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. Neha ShaikhOct 19, 2020, 1:05:00 AM

    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
  4. movieflixOct 27, 2020, 12:22:00 AM

    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
  5. Jack JohnnyNov 7, 2020, 1:30:00 AM

    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
  6. Bilal Khatri112Nov 10, 2020, 2:39:00 AM

    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
  7. Viktoriya Apr 17, 2021, 2:03:00 PM

    The influence of marketing is a Big business with a billion-dollar riding on it. In fact, there are many people mint money up to 6 figures through influencer marketing. visit the website

    ReplyDelete

Subscribe to: Post Comments (Atom)