Default AutoResolveIntegrationRuntime didn't work

Zhou Wentong 66 Reputation points
2022-06-17T03:45:19.28+00:00

Hello,

I have problem in AutoResolveIntegrationRuntime of Synapse.
The status is "failed to get status", in that case I cannot use AutoResolveIntegrationRuntime, and cannot create a linked service.
My role is synapse contributor. My colleague with same role can use AutoResolveIntegrationRuntime though.

Could you tell me how to solve this problem?
Thank you.

Shu
212893-%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%BC%E3%83%B3%E3%82%B7%E3%83%A7%E3%83%83%E3%83%88-2022-06-20-164925.pngHello,

212258-%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%BC%E3%83%B3%E3%82%B7%E3%83%A7%E3%83%83%E3%83%88-2022-06-17-124433.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,170 questions
0 comments No comments
{count} votes

Accepted answer
  1. Pratik Somaiya 4,206 Reputation points
    2022-06-18T05:41:40.867+00:00

    Hello @Zhou Wentong

    The role Synapse Contributor is on IAM or Access Control tab in Synapse Analytics?

    Similar case happened with me wherein my team mate had SQL Contributor rights in Synapse Analytics Access Control whereas I just had access on IAM

    Can you please check the access once?

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Zhou Wentong 66 Reputation points
    2022-06-21T08:01:06.87+00:00

    Hi PratikSomaiya,

    Thank you for your reference information.
    I finally solved this problem by changing my role from workspace_SynapseComputeOperators to workspace_SynapseContributors in Manage > Access Control tab.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.