![]() ![]() Back to the Import Data-tier Application screen click Next. In the Import Settings screen, click Browse and navigate to C:\LabFiles\Secure Environment folder, click on the AdventureWorksLT.bacpac file, and then click Open. bacpac file located on to C:\LabFiles\Secure Environment path on the lab VM (create the folder structure if it does not exist). In the Import Data Tier Application dialog, click Next on the first screen.ĭownload the. In Object Explorer expand the server node, and right click on Databases. Authentication: SQL Server Authentication.On the Connect to Server dialog box, paste in the name of your Azure SQL Database server, and login with the credentials below: Make note of your client IP address, you will use it later. Adding your client IP address to the list will allow you to connect to your Azure SQL Database using SQL Server Management Studio or any other client tools. ![]() Note: Your client IP address was automatically entered for you. On the Networking page, click on + Add your client IPv4 address (your IP address), and then click Save. In the detail screen for your SQL server, move your mouse to the right of the server name, and then select Copy to clipboard button as shown below. Select the server name dp300-lab-XXXXXXXX to be taken to the detail page (you may have a different resource group and location assigned for your SQL server). Connect to the Portal using the Azure Username and Password provided on the Resources tab for this lab virtual machine.įrom the Azure Portal, search for “SQL servers” in the search box at the top, then click SQL servers from the list of options. Configure Azure SQL Database firewall rulesįrom the lab virtual machine, start a browser session and navigate to. Please verify that the code has been copied correctly, before executing the code. Note: These 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 to help ensure the security of the database environment. ![]() 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. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |