Using Azure Blockchain Workbench data with SQL Server Management Studio

Microsoft SQL Server Management Studio provides the ability to rapidly write and test queries against Azure Blockchain Workbench's SQL DB. This section contains a step-by-step walkthrough of how to connect to Azure Blockchain Workbench's SQL Database from within SQL Server Management Studio.

Prerequisites

Connecting SQL Server Management Studio to data in Azure Blockchain Workbench

  1. Open the SQL Server Management Studio and select Connect.

  2. Select Database Engine.

    Database engine

  3. In the Connect to Server dialog, enter the server name and your database credentials.

    If you are using the credentials created by the Azure Blockchain Workbench deployment process, the username is dbadmin and the password is the one you provided during deployment.

    Enter SQL credentials

    1. SQL Server Management Studio displays the list of databases, database views, and stored procedures in the Azure Blockchain Workbench database.

      Database list

  4. To view the data associated with any of the database views, you can automatically generate a select statement using the following steps.

  5. Right-click any of the database views in the Object Explorer.

  6. Select Script View as.

  7. Choose SELECT to.

  8. Select New Query Editor Window.

  9. A new query can be created by selecting New Query.

Next steps

Database views in Azure Blockchain Workbench