locked
Getting exception while executing DataFlow pipeline. "Activity data flow failed. DF-SYS-01 SQLServerException cannot open the database requested by the login." RRS feed

  • Question

  • Getting exception while executing DataFlow pipeline. "Activity data flow failed. DF-SYS-01 SQLServerException cannot open the database requested by the login.".

    Connection test for the linked SQL Server shows a success however.

    Saturday, July 6, 2019 5:21 PM

Answers

  • The error shows that the username and password which you are using to login to your SQL Server database is not valid or does not have the permission to access  the database.

    Please re-check the connection information and try again., Also try accessing the database using SQL Server management studio and try to provide similar credentials in Azure Data Factory.

    Sunday, July 7, 2019 2:10 AM

All replies

  • Is this for your source or sink transformation?

    What type of auth are you using in the Linked Service?


    Saturday, July 6, 2019 6:55 PM
  • The error shows that the username and password which you are using to login to your SQL Server database is not valid or does not have the permission to access  the database.

    Please re-check the connection information and try again., Also try accessing the database using SQL Server management studio and try to provide similar credentials in Azure Data Factory.

    Sunday, July 7, 2019 2:10 AM
  • One of the engineers deleted the pipeline i was working with. I tried to reproduce the issue but later realised there was a name confusion between 2 different databases that had different credentials that caused the error.  Thanks for helping.

    Monday, July 15, 2019 7:46 PM
  • You are right. There was a name confusion between 2 different databases that had different credentials that caused the error.  Thanks for helping.
    Monday, July 15, 2019 7:46 PM
  • For anyone still looking at this post, trying to figure this out.  I ran into this error multiple times when using data flow in a pipeline on Azure Data Factory. After much effort and searching I found nothing to remedy it, so I started just generally troubleshooting the database.  Eventually I realized the database had a space in its name, which data factory does not like. Once I renamed the database not to have a space, my pipelines ran just fine.
    Monday, December 23, 2019 4:20 PM
  • Thank you for bringing this to our attention ZZBrent.  Can you tell me whether this was an Azure SQL or non-Azure SQL, cloud or on-prem?  I would like to make a note in the relevant document.
    Monday, December 23, 2019 6:28 PM