If this is a transient issue (for example, an instable network connection), add retry in the activity policy to mitigate.įor more information, see Pipelines and activities. For further help, contact Azure SQL support.
#Whatsmate analyzing data failed error code
If the error message contains the string "SqlException", SQL Database the error indicates that some specific operation failed.įor more information, search by SQL error code in Database engine errors. For more information, see Azure SQL connectivity settings.įor Azure SQL, if the error message contains an SQL error code such as "SqlErrorNumber=", see the Azure SQL troubleshooting guide.įor a recommendation, see Troubleshoot connectivity issues and other errors with Azure SQL Database and Azure SQL Managed Instance.Ĭheck to see whether port 1433 is in the firewall allowlist.įor more information, see Ports used by SQL Server.
On the Azure SQL firewall, set the Deny public network access option to No. Cause analysisįor Azure SQL, if the error message contains the string "SqlErrorNumber=47073", it means that public network access is denied in the connectivity setting. Check below list for possible cause analysis and related recommendation. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.Ĭauses and recommendations: Different causes may lead to this error.
Message: Cannot connect to SQL Database: '%server ', Database: '%database ', User: '%user '. This article provides suggestions to troubleshoot common problems with the Azure Synapse Analytics, Azure SQL Database, and SQL Server connectors in Azure Data Factory and Azure Synapse.
0 kommentar(er)
