HOWTO: Access SQL Server Management Studio (SSMS) in Azure Enclave Project Workspace

Click here for the PDF version of the information below.


Purpose

This document describes: (1) How to open SQL Server Management Studio (SSMS) (2) Connecting to the SQL Server and (3) Creating & Accessing a Scratchpad Database Work Area.


Table of Contents


Prerequisites


Instructions

How to open SQL Server Management Studio (SSMS)

1.  After accessing your Azure Enclave Project Workspace, on the home screen, select the SQL Server Management Studio icon.

Connecting to the SQL Server

1. When the SSMS application opens, you will be prompted to connect to the SQL Server. The following entries should be used:

    • For Server name, type the full unique Project Workspace IP Address  provided to you once your ServiceNow project workspace access request was provisioned.
    • Ensure Azure Active Directory - Password is selected from the Authentication dropdown.
    • Type your full primary partners.org email address associated to your MGB user id and type your password into the User name and Password fields.

Then click on the Connect button.

Creating & Accessing a Scratchpad Database Work Area

Users cannot write to or alter objects within the database server except within the workarea schema. To create a scratchpad area within the database, create objects within the workarea schema*. All project workspace members are granted permissions to CREATE, ALTER, UPDATE, DELETE, and INSERT commands in the workarea schema.
*Note: The schema workarea object is not visible by default


Additional Resources

1.  Introduction to SQL

2.  Microsoft Doc - Microsoft Educational SQL Resources


Escalation

If further assistance is needed, please email the Azure Enclave Team at MGBAzureEnclaveSupport@partners.org. Please always include your unique Project Workspace IP Address on all communications.


Related Articles

INFO: Azure Enclave FAQs and Tips

INFO: RISC Policy - Azure Enclave: Workspace Controls, Permissions, and Auditing

HOWTO: Azure Enclave Project Workspace Import & Export Files

Go to KB0038988 in the IS Service Desk