在带有暂存Blob存储+ Polybase的Data Factory中运行管道到Azure DataWarehouse时运行管理器身份错误 [英] Manager Identity error when running a pipeline in Data Factory with Staging Blob Storage + Polybase to a Azure DataWarehouse

问题描述

当尝试使用Polybase +启用暂存Blob存储将数据从Azure SQL提取到Azure DW数据库时，我收到此错误消息.

I am getting this error message when trying to use Polybase + Enabling Staging Blob Storage to pull data from Azure SQL to Azure DW Database.

此服务器上尚未启用托管服务标识.请启用托管服务身份，然后重试.

Managed Service Identity has not been enabled on this server. Please enable Managed Service Identity and try again.

我试图创建一个托管身份用户，将其分配给Web服务，并授予它将该用户链接到在数据库中具有所有者权限的AAD组的权限，但是它不起作用.

I've tried to create a Managed Identity user assigning it to a web service and giving it permission linking this user to a AAD Group that has owner permission in the database, but it doesn't work.

推荐答案

首先，使用您的用户名/密码在Azure PowerShell中登录.其次，运行以下命令来分配您的DB DataWarehouse服务器.

First, logon in Azure PowerShell with your username/password . Secondly, run the following command to assign your DB DataWarehouse Server.

Set-AzSqlServer -ResourceGroup -ServerName -AssignIdentity

Set-AzSqlServer -ResourceGroup -ServerName -AssignIdentity

这篇关于在带有暂存Blob存储+ Polybase的Data Factory中运行管道到Azure DataWarehouse时运行管理器身份错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！