how to solve using azure data factory connect to SQL MI DB.

Feng, Laughing-ZM 20 信誉分
2024-07-26T03:29:36.2733333+00:00

HI guys, we have a project want to use Azure data factory to connect SQL MI DB . When we create linked service to connect DB , it occurs error :

"Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'FQDN', Database: 'DBName', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Login failed for user 'xxxx'  like that . "

we already create new inbound rule for nsg to SQL MI DB under . could you suggest me how to solve this issue?

PS : our Azure data factory use Managed Virtual Network integration runtime.

SQL Server | 其他
0 个注释 无注释
{count} 票

1 个答案

排序依据: 非常有帮助
  1. ZoeHui-MSFT 41,541 信誉分
    2024-07-26T09:35:24.3266667+00:00

    Hi @Feng, Laughing-ZM

    It seems that you have not configure correctly, please follow the documentation to see if you miss any steps.

    Azure Data Factory managed virtual network

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 个注释 无注释

你的答案

提问者可以将答案标记为“已接受”,版主可以将答案标记为“已推荐”,这有助于用户了解答案是否解决了提问者的问题。