Forum Discussion

swaruss's avatar
swaruss
Frequent Visitor
3 years ago
Solved

Copy Data from SQL Server only available with Basic authentication

If I try to do a Copy Task from SQL server (via on prem data gateway) in a Pipeline, I only have the option of basic authentication. All our SQL Servers use Windows authentication. Why would this not...
  • ScottPowellECU's avatar
    ScottPowellECU
    3 years ago

    Thanks Vitaly, that's what I thought - but the OP seemed to suggest otherwise. Appreciate the clarification.

     

    One bit of feedback on the documentation you linked - it's completely written from a "the user knows Azure Data Factory" standpoint. If one of the goals of Fabric is to introduce it to people that haven't used ADF yet (like me), it's very difficult to understand that Self-hosted integration runtimes is still in progress of design means "you can't do a copy activity between on-prem and Fabric". IMO it would be a good idea to go back through that document and rewrite from a "person doesn't know Azure Data Factory, but still needs to know this functionality doesn't work" standpoint

     

    Thanks!

    Scott