I have azure SQL DB, with SQL authenticated user as server admin, we have a requirement to upload data from on-premises folder to Azure DB. How can we achieve this?
1.SQL authenticated user is not recognized in AD 2.is there any service account other than this server admin to az-sql-dbs?

  • Check with your system admin team and check if your AD is in sync with Azure? If yes you can add your windows account as a login in logical server. – SqlWorldWide Oct 23 '17 at 12:56

You can use Azure SSIS integration with Azure Data Factory as explained here. On this resource you will find how to run packages that use Windows Authentication to connect to on-premises resources like a folder.

Hope this helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.