This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 .\08001 = 53”
Recently upgraded from Alteryx 2019.4.8 to 2021.2.1 and experiencing intermittent connectivity issues between Designer/Server and Azure SQL databases.
Azure SQL database
Publish to SQL database hosted on Azure
Permissions to firewall and DNS
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.
Ensure the DNS and IP for the Azure Environment is included in the allow settings of the internal firewall permissions
Gateway Details are available from the link below: