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.