不能在SQL Server代理运行作业

Question

我试图执行从SQL Server代理作业但是收到的错误：

The login is from an untrusted domain and cannot be used with Windows authentication. 

在SQL Server 2016 SQL Server代理和SSIS其中凭证帐户proxy是链接到windows admin account。代理设置SSIS package excecution：

的工作只有1步运行SSIS包。该软件包是从VS 2016 +数据工具开发/测试/部署的。

下面是步骤：

和错误：

右键单击作业查看历史记录。以下是错误：

Executed as user: MACHINE_NAME\admin_user. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 2:15:10 PM Failed to execute IS server package because of error 0x80131904. Server: xxx, Package path: \SSISDB\Practise 1\SSIS 1\Package.dtsx, Environment reference Id: NULL. Description: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Source: .Net SqlClient Data Provider Started: 2:15:10 PM Finished: 2:15:10 PM Elapsed: 0.188 seconds. The package execution failed. The step failed. 

Answer 1

SQL Server代理，它是在本地机器上运行，在步骤无法解析服务器名称tcp:xxx.cloudapp.azure.com。由于代理是本地的，所以只需将服务器名称设置为.即可。解决。