data-sql-management-studio.md

title	description	ms.date	ms.topic	ms.service	ms.reviewer
Query Azure Blockchain Workbench data using SQL Server Management Studio	Learn how to connect to Azure Blockchain Workbench's SQL Database from within SQL Server Management Studio.	02/18/2022	how-to	azure-blockchain	mmercuri

Using Azure Blockchain Workbench data with SQL Server Management Studio

[!INCLUDE Retirement note]

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

• Download SQL Server Management Studio.

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.

   

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.

   

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

      

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

[!div class="nextstepaction"] Database views in Azure Blockchain Workbench