azure - 如何在另一个资源组中引用 SQL Server

Question

我有一个应用程序，其中包含 2 个 Web 应用程序，每个应用程序都有一个 SQL 数据库。该计划是将每个 Web 应用程序及其数据库放入一个单独的资源组中。共享 SQL Server 将位于其自己的资源组中。

如何在 Web 应用程序的 Azure 资源管理器模板中引用共享 SQL Server？

我已经尝试过以下操作:

    {
      "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
      "contentVersion": "1.0.0.0",
      "parameters": { },
      "variables": { },
      "resources": [
        {
          "name": "Microsoft.Sql/servers/sqlserver-dev/databases/app1db",
          "type": "Microsoft.Sql/servers/databases",
          "location": "[resourceGroup().location]",
          "apiVersion": "2014-04-01-preview",
          "dependsOn": [ ],
          "properties": {
            "collation": "SQL_Latin1_General_CP1_CI_AS",
            "edition": "Basic",
            "maxSizeBytes": "1073741824",
            "requestedServiceObjectiveName": "Basic"
           }
        }
      ]
    }

但是这种方法给了我错误:

Deployment template validation failed: 'The template resource 'Microsoft.Sql/servers/sqlserver-dev/databases/app1db' for type 'Microsoft.Sql/servers/databases' at line '1' and column '202' has incorrect segment lengths. A nested resource type must have identical number of segments as its resource name. A root resource type must have segment length one greater than its resource name. Please see https://aka.ms/arm-template/#resources for usage details.'.

当我使用SQL服务器的resourceId时:

/subscriptions/{GUID}/resourceGroups/sql-server-group/providers/Microsoft.Sql/servers/sqlserver-dev/databases/app1db

我也遇到同样的错误。

关于如何建立跨资源组链接有什么想法吗？

Answer 1

您无法将 Azure SQL 服务器及其数据库分配给不同的资源组。