SQL Server & Azure Experiences and Scripts: November 2018

Azure Managed Instances

Procuring & Connecting

Below steps help you creating a new Azure Managed Instance from Azure portal and shows how to connect to it.

Create a new managed instance in Azure portal. Click on “Create a resource” and search for “Azure SQL Managed Instance”. In the result that appears. Click Create.

2. Provide Instance Name, Login information, resource group, location and Virtual Network to host managed instance. We are using below settings.

Resource Group - NaviDemoDBAInstance

Instance Name - navidemodbainstance

User Name - NaviSQLAdmin

Password - "Your Password"

Once all information is provided click create.

Create Managed Instance

3. You will get a warning while creating a new VNet that First instance in the VNet could take upto 6 hours to complete.

4. Once the creation is in progress, you can click on the notification bell icon and choose to view the progress of the operation. Ours took 3 Hours and 37 Mins to complete.

5. Create a new Virtual network for the VM you will connect your instance through. We are creating it in the same region “East US”.

6. Create a new VM in the same resource group. Use the VNet “MyJumpVMVNet” for this Virtual machine. We opened the RDP ports to this machine.

Machine Name – MgdInstJumpVM

User Name – NaviSQLAdmin

Password - "Your password"

Below is the configurations of the VM created.

7. Once done create a peering between the VM Vnet and Managed Instance VNet. Below are the 2 networks we will peer.

8. Go to “Peerings” section of one of the network and click “Add”.

9. On the blade that opens up, specify a name for peering and select the other Virtual network. In our case it is the Managed instance network selected.

10. Once created you should have the peering visible on your VM Network

11. Now go to the Managed instance Virtual network and create peering towards your VM Virtual network as we did before in other direction.

12. Now Connect to your VM created earlier. You can download the RDP file from the portal for connection. Use the credentials provided while creation of VM.

13. Once logged in Open Internet explorer and download the latest version of SQL Server Management Studio. We will use this for testing connectivity between VM and our Managed Instance.

14. Once downloaded Start the setup and install it on your Azure VM

15. Now go to you managed instance on azure portal and copy the complete Instance name. Instance name should be like “MyInstancename.3ed349523e65.database.windows.net”