I am trying to create a pipeline for my stored procedure in dedicated SQL pool. I am getting error Cannot connect to SQL database "" Check the linked service config is correct, and make sure the SQL database firewall allows the integration runtime to access. Logon failed for user ""
This was due to access issue. Admin granted relevant access and now it's working.