Azure数据工厂本地复制错误 [英] Azure Data Factory On-Premises Copy Error

问题描述

我正在尝试安排一个包含SQL Server的本地复制作业. 但是，尝试输入sql服务器凭据时出现另一种错误.

I am trying to schedule an on-premises copy job that contains a SQL Server. However I am getting a different kind of error when trying to enter the sql server credentials.

Type = Microsoft.Data.Mashup.InternalMashupException.Message..sorry，en 在期间发生错误 评估.，源= Microsoft.Data.Mashup类型= Microsoft.Mas..data 保护操作失败.这可能是由于 没有为当前线程的用户加载用户配置文件 当线程是 impersonanting.Sources，"Type = Microsoft.Mashup.Evaluation.Inter ...

Type=Microsoft.Data.Mashup.InternalMashupException.Message..sorry,en error occurred during evaluation.,Source=Microsoft.Data.Mashup"Type=Microsoft.Mas..data protection operation was unsuccessful. This may have been caused by not having the user profile loaded for the current thread's user context which may be the case when the thread is impersonanting.Sources, "Type=Microsoft.Mashup.Evaluation.Inter...

我已将网关预配置到托管sql服务器的服务器上，但出现此错误.

I have provisioned the gateway onto the server where the sql server is hosted but getting this error.

我也正在使用复制预览"功能来使它正常工作.

Also I am using the Copy Preview feature to get this working.

推荐答案

我在这里可能是错误的，但它看起来像是身份验证问题.您是否尝试过从网关连接到服务器?打开"Microsoft集成运行时配置管理器"，转到诊断"并填写每个字段，然后单击测试".如果一切正确，则会出现绿色的对勾.您正在尝试模拟用户，因此请选择Windows而不是Basic.

I may be wrong here, but it looks like an authentication issue. Have you tried connecting to the server from the gateway? Open the Microsoft Integration Runtime Configuration Manager, go to Diagnostics and fill every field, then click test. If everything is correct, a green check should appear. You are trying to impersonate a user, so choose Windows instead of Basic.

尝试使用它，直到获得绿色对勾，然后确保所使用的链接服务具有与您所使用的信息相同的信息，并且应该可以正常工作.

Try with it until you get the green check, then make sure that the linked service you are using has the same info you used and it should work.

您还可以尝试创建数据库用户并授予其进行所需查询的权限，然后将链接的服务更改为使用数据库用户而不是Windows用户.

You can also try creating a database user and give it permissions to make the query you want, then changing the linked service to use the database user instead of the windows user.

这篇关于Azure数据工厂本地复制错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！