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.
InstallationIf you have not already done so, download and install DBHawk.
- Login to your Azure account at https://azure.microsoft.com/en-us/get-started/azure-portal/
- Create a New Azure SQL Database
3. After database creation, ensure that you have configured your Azure Firewall to allow a connection to your Azure server from your IP address.
4. Follow http://msftdbprodsamples.codeplex.com/releases/view/37304 link to download and install Adventure Works for Azure SQL Database.
5. After successful AdventureWorks database installation, find out JDBC connection information to connect DBHawk using JDBC
6. Login to DBHawk admin screen and go to Manage Connections Tab. Add a new connection for MS Azure SQL connection.
7. After DBHawk connection setup, you should be able to login MS Azure SQL database using DBHawk with username and password.
