In the Import Data Tier Application dialog, click Next on the first screen. In Object Explorer expand the server node, and right click on databases. Paste in the name of your Azure SQL database server and login with the credentials you created in Lab 2:Īuthentication: SQL Server Authentication Open SQL Server Management Studio on the lab VM. Important: Make note of your client IP address, you will use it later in this task. This will allow you to connect to your Azure SQL Database server using SQL Server Management Studio or any other client tools. Click on + Add client IP as highlighted below and then click Save. In the detail screen for your SQL server, move your mouse to the right of the server name, and click copy to clipboard button as shown below.Ĭlick on Show firewall settings (above the server name that you just copied). Click on the server name to be taken to the detail page for the server you created in Lab 2 In the search bar at the top of the Azure Portal, type SQL. Exercise 1: Configure an Azure SQL Database Firewall and connect to a new databaseįrom the lab virtual machine, start a browser session and navigate to. Please verify that the code has been copied correctly, with the proper line breaks, before executing the code. Note: The exercises ask you to copy and paste T-SQL code. These tasks will focus on Azure SQL Database. You have been hired as a Senior Database Administrator help ensure the security of the database environment. Lab objectivesĪfter completing this lab, you will be able to:Īuthorize Access to Azure SQL Database with Azure Active DirectoryĮnable Microsoft Defender for SQL for Azure SQL DatabaseĬonfigure Data Classification for Azure SQL Database The students will take the information gained in the lessons to configure and subsequently implement security in the Azure Portal and within the AdventureWorks database. Lab files: The files for this lab are in the D:\Labfiles\Secure Environment folder. Azure Active Directory access in the subscription. Prerequisites: An Azure SQL server you created in the lab for Module 2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |