Error: “Error opening connection 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 for SQL Server; Named Pipes Provider' Could not open a connection to SQL Server [53].\08001 = 53”
Environment Details
Recently upgraded from Alteryx 2019.4.8 to 2021.2.1 and experiencing intermittent connectivity issues between Designer/Server and Azure SQL databases.
- Alteryx Server
- Azure SQL database
- Publish to SQL database hosted on Azure
- Permissions to firewall and DNS
Cause
Missing a gateway IP for the specific Azure region in the internal firewall rule that allows TCP 1433 traffic. When the DNS resolves to an IP that is included, the connection works, and when the missing IP resolves, the connection fails. By including the missing IP, it resolves the issue.
Resolution
Ensure the DNS and IP for the Azure Environment is included in the allow settings of the internal firewall permissions
Additional Resources
Gateway Details are available from the link below:
https://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture