Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,848
Community Members
 
Community Events
168
Community Groups

Connection Error from Alteryx - Intermittent Connection Just Started

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

2 answers

Hi Sam.  Thanks for the quick response.  IP address for our Alteryx instance has not changed recently.  

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. 

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 Atlassian Team Aug 17, 2022

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. 

0 votes
Sam Tsubota Atlassian Team Aug 17, 2022

@Jason Davis You should to check to see if the network IP address for your Alteryx instance was changed recently. When your Enterprise Insights instance was set up a range of IP addresses for your corporate network was whitelisted by Atlassian to restrict access to users/application on your network. If the IP address has changed recently, you will need to submit a support ticket to Jira Align support to have the new IP address(es) whitelisted. Are you able to connect to Enterprise Insights from Azure Data Studio or SQL Server Management Studio when you are on your corporate network? 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Align

Rockin' the Roadmap - How to make most of the Roadmap with Jira Align

The roadmap challenge for large scale agile enterprises Regardless of the agile framework you use, the agile enterprise has a massive scale with the challenge to connect hundreds of teams and thous...

3,714 views 8 30
Read article

Atlassian Community Events