Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DataFlow Gen2 - Destination Lakehouse Connection Issue

My dataflow started receiving this connection error on the destination side from Lakehouse. The strange thing is that when I go into table preview in Lakehouse, I don't have any issues viewing the da...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous 

     

    According to the error message, the database on your "XXX.database.windows.net" appears to be currently unavailable.

     

    You can try the following to troubleshoot this problem:

     

    Ensure that the database is online and accessible. You can try connecting to it using SQL Server Management Studio or another SQL client to verify its status.

     

    Sometimes, the issue might be temporary. Wait for a few minutes and then try reconnecting.

     

    Verify if there are any scheduled maintenance activities or outages affecting the database server. You can check the Azure status page or your organization’s maintenance schedule.

     

    Double-check the configuration settings in your DataFlow Gen2 and ensure that all connection strings, credentials, and other settings are correct.

     

    The following link are for your reference and may be helpful:

     

    Lesson Learned #320:Database 'XXX' on server 'xyz' is not currently available using ServerLess tier. - Microsoft Community Hub

     

    Regards,

    Nono Chen

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