About this sample
Before you begin
Run this sample
Sample details
Disclaimers
Related links

• Applies to: Azure SQL Database
• Key features: Managed Instance
• Workload: n/a
• Programming Language: PowerShell
• Authors: Srdan Bozovic
• Update history: n/a

To run this sample, you need the following prerequisites.

Software prerequisites:

1. PowerShell 5.1 or PowerShell Core 6.0
2. Azure PowerShell Az module

Azure prerequisites:

1. Permission to manage Azure virtual network

Run the script below from PowerShell or Azure Cloud Shell

$scriptUrlBase = 'https://raw.githubusercontent.com/Microsoft/sql-server-samples/master/samples/manage/azure-sql-db-managed-instance/attach-jumpbox'

$parameters = @{
    subscriptionId = '<subscriptionId>'
    resourceGroupName = '<resourceGroupName>'
    virtualNetworkName = '<virtualNetworkName>'
    administratorLogin  = 'cloudSA'
    administratorLoginPassword  = '<password>'
    }

Invoke-Command -ScriptBlock ([Scriptblock]::Create((iwr ($scriptUrlBase+'/attachJumpbox.ps1?t='+ [DateTime]::Now.Ticks)).Content)) -ArgumentList $parameters, $scriptUrlBase

This sample shows how to attach VM with SSMS to Managed Instance virtual network using PowerShell

The scripts and this guide are copyright Microsoft Corporations and are provided as samples. They are not part of any Azure service and are not covered by any SLA or other Azure-related agreements. They are provided as-is with no warranties express or implied. Microsoft takes no responsibility for the use of the scripts or the accuracy of this document. Familiarize yourself with the scripts before using them.

For more information, see these articles:

• What is a Managed Instance (preview)?
• Configure a VNet for Azure SQL Database Managed Instance