时间戳

首页 > 解决方案 > 具有集成运行时的 Azure DataFactory v2 链接服务

azure - 具有集成运行时的 Azure DataFactory v2 链接服务

问题描述

客户端服务器上的自托管 IR 设置，显示已连接到我的 ADFv2。创建链接服务超时。我可以看到此设置与之前成功设置之间的唯一区别是 SQL 连接需要启用信任服务器证书勾选。

我不知道如何将信任服务器证书添加到我的 json sqlconnection 文件中。

为 SqlServerLinkedService.json 删除了下面的服务器名称和密码

{
"properties": {
    "type": "SqlServer",
    "typeProperties": {
        "connectionString": {
            "type": "SecureString",
            "value": "Server=<servername>;Database=Master;User 
ID=admin;Password=<password>;Timeout=60"
        }
    },
    "connectVia": {
        "type": "integrationRuntimeReference",
        "referenceName": "Test-IR"
    }
},
"name": "SqlServerLinkedService"
}


New-AzureRmDataFactoryV2LinkedServiceEncryptedCredential -DataFactoryName 
$dataFactoryName -ResourceGroupName $ResourceGroupName - 
IntegrationRuntimeName "TEST-IR" -File ".\SQLServerLinkedService.json
" > encryptedSQLServerLinkedService.json

给我错误：

 New-AzureRmDataFactoryV2LinkedServiceEncryptedCredential : Unable to 
connect to the remote server caused by A connection attempt failed because 
the connected party did not properly respond after a period of time, or
established connection failed because connected host has failed to respond 
<ip address removed>:8050 At line:1 char:1
+ New-AzureRmDataFactoryV2LinkedServiceEncryptedCredential -DataFactory ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo          : CloseError: (:) [New- 
AzureRmData...yptedCredential], GeneralException
+ FullyQualifiedErrorId :

Microsoft.Azure.Commands.DataFactoryV2.NewAzureDataFactoryLinkedServiceEncryptedCredentialCommand

标签： azureazure-data-factory-2

解决方案

您可以在连接字符串中使用 TrustServerCertificate。https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax#using-trustservercertificate

推荐阅读