Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Unable to Access Connection in Copy Activity

I am unable to use a particular connection in copy activities. I am also not allowed to save changes to pipelines using this connection or invoke the pipeline from another pipeline.   I have ...
Need Help
Pipeline
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

I noticed in the fourth screenshot you provided that Basic is selected in the Authentication kind.

Based on my testing, when you select Azure SQL database, the Connection credentials popup will ask you to fill in Username and Password.

So I think you can either test again or check this official documentation below:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply.
This doesnt happen for me when I start by entering a Server And Database combination that already has a connection. If i instead enter a new Server/Database combination, then I too are prompted to enter Username/Password.