Connection Error from Alteryx - Intermittent Connection Just Started

Question

Connections from Alteryx to Enterprise Insights from Alteryx vis OLEDB have been fine for over a year but suddenly receiving intermittent fails.  Appears to be some type of timeout issue but unsure as to how to resolve.

Anyone else encountered this and resolved successfully?

Here's the error.

Error: Input Data (2): Error opening connect string: Microsoft OLE DB Driver for SQL Server: Login timeout expired\HYT00 = 0; Microsoft OLE DB Driver for SQL Server: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.\08001 = 53; Microsoft OLE DB Driver for SQL Server: Named Pipes Provider: Could not open a connection to SQL Server [53]. \08001 = 53

Thanks

Sam Tsubota · Answer

The reason why I suggested checking these things because Enterprise Insights access is just IP whitelisting and either SQL login or Azure AD authentication. Since you are able to connect to Enterprise Insight, albeit not consistently, that rules out issues with IP whitelisting or SQL login authentication. The biggest variable with most connectivity issues is the customer's corporate network and firewall configurations. If you are unable connect to Enterprise Insights, the Atlassian team most likely won't see any error in the logs because no connection was established or know why the connection failed. You can open a support ticket to see if your Enterprise Insights instance is experiencing any intermittent downtime.

Jason Davis_7jaodk · Answer

I can check but again it's not a full block.  We connect but it's not consistent.  Might connect 5 times in a row but then fail once or 3 times straight.

Sam Tsubota · Answer

I suggest also checking with your network team to see if any firewall or network configurations were changed recently that may be blocking traffic to the port that is used to connect to Enterprise Insights.