search

MicrosoftLearning / dp-300-database-administrator

Repository for lab exercises and instructions for Microsoft DP-300 learning content
https://microsoftlearning.github.io/dp-300-database-administrator/
MIT License
81 stars 89 forks source link

Lab 1 - Need checkbox for SSMS v.20 #43

Closed tylerfarmer1 closed 3 months ago

tylerfarmer1 commented 6 months ago

Lab/Demo: 01 - Provision SQL Server on Azure VM

Section - Connect to SQL Server on an Azure Virtual Machine

Description of issue

Two issues, both relatively minor:

  1. The Azure portal has changed just a bit when connecting to a VM through RDP
    • Step 1 of the instructions say: "On the Overview page for the virtual machine, select the Connect button and choose RDP."

It should be changed to something like: "On the Overview page for the virtual machine, select the Connect dropdown and select Connect." Then step 2 should be just "Select the Download RDP File button." The picture is out of date, but it should be workable.

  1. The SQL VM now includes the newer version of SSMS - version 20. With v.20, when you're on the login page to connect to SQL Server, the is a checkbox called "Trust Server Certificate" that must be turned on. Otherwise you won't be able to connect to the SQL Server. So the instructions on Step 7 need to include a new picture, and include the action to "Turn on the checkbox for Trust Server Certificate."
JulianePadrao commented 3 months ago

We're looking into this issue, thank you.

afelix-95 commented 3 months ago

Thank you for pointing those out! The lab is updated.