Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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
Community Members
Community Events
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



2 answers

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

Sam Tsubota
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Aug 17, 2022 • edited

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
Atlassian Team members are employees working across the company in a wide variety of roles.
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
Atlassian Team members are employees working across the company in a wide variety of roles.
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
AUG Leaders

Atlassian Community Events