06/2015

2  comments

SQL Azure JDBC Connection & AdventureWorks Sample Databases Setup with DBHawk

SQL Azure is the relational data store for the Azure platform. DBHawk allows to connect to Azure database via JDBC connection.
Following tutorial shows how to connect to MS Azure database and install sample AdventureWorks database.

Installation
If you have not already done so, download and install DBHawk.

  1. Login to your Azure account at https://azure.microsoft.com/en-us/account/
  2. Create a New Azure SQL Database
SQL Azure With DBHawk

     3. After database creation, ensure that you have configured your Azure Firewall to allow a connection to your Azure server          from your IP address.

SQL Azure With DBHawk

    4. Follow http://msftdbprodsamples.codeplex.com/releases/view/37304 link to download and install Adventure Works for            Azure SQL Database.

SQL Azure With DBHawk

     5. After successful AdventureWorks database installation, find out JDBC connection information to connect DBHawk using          JDBC

SQL Azure With DBHawk
SQL Azure With DBHawk

    6. Login to DBHawk admin screen and go to Manage Connections Tab. Add a new connection for MS Azure SQL connection.

SQL Azure With DBHawk

     7. After DBHawk connection setup, you should be able to login MS Azure SQL database using DBHawk with username and         password.

SQL Azure With DBHawk

Tags


You may also like

Cross Database Development with DBHawk

Get started for free.

Sign Up to see how DBHawk provides zero trust database access and development across all databases.


No Credit card required!