首页 > 数据库 >AZ-500 Lab-configure SQL Server network access

AZ-500 Lab-configure SQL Server network access

时间:2023-01-09 16:37:13浏览次数:44  
标签:network Lab Server virtual SQL Azure select configure

由于微软Azure平台界面一直都在变,所以通过考试的关键,是真正理解lab题要表达的意思,不要死记硬背。

SIMULATION -

You need to configure a Microsoft SQL server named Web1234578 only to accept connections from the Subnet0 subnet on the VNET01 virtual network.To complete this task, sign in to the Azure portal.

Correct Answer
You need to allow access to Azure services and configure a virtual network rule for the SQL Server.

  1. In the Azure portal, type SQL Server in the search box, select SQL Server from the search results then select the server named web1234578. Alternatively, browse to SQL Server in the left navigation pane.

AZ-500 Lab-configure SQL Server network access_SQL

  1. In the properties of the SQL Server, click Firewalls and virtual networks.

AZ-500 Lab-configure SQL Server network access_SQL Server_02

  1. In the Virtual networks section, click on Add existing. This will open the Create/Update virtual network rule window.
  2. Give the rule a name such as Allow_VNET01-Subnet0 (it doesn't matter what name you enter for the exam).
  3. In the Virtual network box, select VNET01.
  4. In the Subnet name box, select Subnet0.
  5. Click the OK button to save the rule.

AZ-500 Lab-configure SQL Server network access_SQL Server_03

  1. Back in the Firewall / Virtual Networks window, set the Allow access to Azure services option to On.

AZ-500 Lab-configure SQL Server network access_Azure_04

标签:network,Lab,Server,virtual,SQL,Azure,select,configure
From: https://blog.51cto.com/543925535/5997489

相关文章

  • AZ-500 Lab-configure a lock for the app service plan
    由于微软Azure平台界面一直都在变,所以通过考试的关键,是真正理解lab题要表达的意思,不要死记硬背。SIMULATION-Youneedtopreventadministratorsfromperformingacciden......
  • 【2023.01.08】NUC9I9安装PVE7.3和OpenWrt,WinServer
    前面的教程可以看:【2022.11.17】N5105安装PVE系统,关联proxmox-Mokou-博客园(cnblogs.com)本文主要做一个备注,方便以后查阅同时改路由器将作为一个旁路由使用,不作为......
  • sql server技巧类sql语句
    1、1=1,1=2的使用,在SQL语句组合时用的较多“where1=1”是表示选择全部“where1=2”全部不选,如:if@strWhere!=’’beginset@strSQL=‘selectcount(*)asTotal......
  • sql server语句(1)
    1、说明:复制表(只复制结构,源表名:a新表名:b)(Access可用)法一:select*intobfromawhere1<>1(仅用于SQlServer)法二:selecttop0*intobfroma2、说明:拷贝表(拷贝......
  • 【车间调度】基于GA/PSO/SA/ACO/TS优化算法的车间调度比较(Matlab代码实现)
    目录1概述2 FJSP描述3运行结果3.1main1运行结果3.2main2运行结果4Matlab代码 5参考文献6写在最后1概述柔性作业车间调度问题(FlexibleJobshopSched-ulingPro......
  • sql server基础语句
    1、说明:创建数据库CREATEDATABASEdatabase-name2、说明:删除数据库dropdatabasedbname3、说明:备份sqlserver—创建备份数据的deviceUSEmasterEXECsp_addum......
  • SQL Server 关于NULL值匹配
    SQLServer关于NULL值匹配一、NULL值数据库中逻辑值类型有三种:TURE、FALSE、UNKNOW,其中NULL就代表UNKNOW,NULL和0是有本质区别的,不能混为一谈。查询要求中可能涉及到NU......
  • SQL Server 2019 普通时间转换成UNIX时间戳
    SQLServer2019普通时间转换成UNIX时间戳一、前言由于在查询时,经常使用到DATETIME2类型数据date_time列,查询效率比较低,用时也很长。如果能转换成BIGINT类型的UNI......
  • 数据库阻塞查询语句 SQL SERVER
    --查询CPU占用最高的SQL语句SELECTtotal_worker_time/execution_countASavg_cpu_cost,plan_handle,execution_count,(SELECTSUBSTRING(text,statement_sta......
  • 对话开发者:Serverless 落地的困境与破局
    作者:阿里云开发者社区从2012年提出Serverless到今年2022年刚好十年。过去十年,上云是确定性趋势,在这个阶段企业一开始的关注点在于如何实现平滑上云。随着越来越多的企......