Forum Discussion
Helper IFabric CI/CD: Data Pipeline fails with RequestValidationFailed (SQL Connection) when deployed via SP
Hi CloudVasu
Q: Is connection mapping (Deployment Rules) mandatory for Data Pipelines when deploying via SPN, even if connection names already exist in the target workspace?
A: No, Deployment Rules are not valid for Data Factory pipelines, they cover semantic models. If you name your connection exactly the same in the target workspace, there will be no rules required.
Q: Are there additional authorization or binding steps required for SPNs to use SQL connections during cross-workspace deployments?
A: Connections are valid within tenant scope - your SPN should be granted either a read or an use permission on the connectiuon object it will run against, both in source as well in the target. If you don't do this, the deployment will fail at validation.
Q: What is the recommended way to automate the swap of SQL connection strings (Server/Database name) during deployment?
A: You can use a variable library and parameterize your pipeline, including the connection selection. The correct way is to store 1 value set per env. Dynamic content can bind to the variable library.
Hope that makes sense - please appreciate by leaving a Kudos or accept it as a Solution to help others.
Helper IHi MJParikh,
Thanks a lot for the detailed explanation,really helpful!
I ended up re-creating the SQL connection in the target workspace and gave the SPN Use permission, and after waiting a bit for propagation, the deployment worked.
I also set up a Variable Library per environment to parameterize the pipeline, which is now working as expected.
Appreciate the practical tips on post-deploy rebinding and checking data source permissions,that cleared up a lot of confusion.
Hello, I am having the same issue with you in regards to the SQL connection... I have my SPN added as a user to the connection (also tried with owner) and I get the same error message as you every time. I have created a new connection to use which doesnt help. How long did you have to wait for your permissions to propagate?
v-dineshyaCommunity Support
Hello, Yes I am still having the same issue. My service principal (an entra id app) has user permission on the connection (a sql server basic auth connection).
I have tried recreating the connection, recreating the pipeline etc and I still get the same error message.
- CloudVasu
Sorry to hear you're still experiencing this issue.
To help you properly, could you please share the exact error message you're receiving? A full screenshot or the complete error text would be helpful.
Based on your description, it sounds like there may be a missing configuration step. Please review your setup carefully and confirm that all required steps have been completed.
If the issue persists after that, share the detailed error and we’ll assist you further. If needed, we can escalate it to the wider team