sql-server - ADO NET 目标无法获取连接，并显示以下错误消息 : "Login failed for user

Question

创建了一个SSIS包，当我在本地运行它时它运行良好，但是当我尝试从sql server代理执行它时，它给我错误，用户登录失败，我正在使用SQL身份验证连接到Azure数据库在本地运行良好，但在作业代理上出错

这是我收到的错误:

Server Execute Package Utility Version 14.0.1000.169 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 10:59:46 AM Error: 2019-06-07 10:59:47.71 Code: 0xC0208452 Source: Data Flow Task ADO NET Destination [2] Description: ADO NET Destination has failed to acquire the connection {F51F409E-2990-4C40-8DFF-0B078AF481D4} with the following error message: "Login failed for user 'SVCASQLDW'.". End Error Error: 2019-06-07 10:59:47.71 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: ADO NET Destination failed validation and returned error code 0xC0208452. End Error Error: 2019-06-07 10:59:47.71 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2019-06-07 10:59:47.71 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:59:46 AM Finished: 10:59:47 AM Elapsed: 0.875 seconds. The package execution failed. The step failed.

Answer 1

在 powershell 中进行测试以验证您的连接参数:

dbrowne> $constr = "server=xxxxxx.database.windows.net;Database=master;user id=<yourUserName>;password=<yourPassword>"
dbrowne> $con = new-object system.data.sqlclient.sqlconnection $constr
dbrowne> $con.Open()