Azure App Service无法连接端口1434 [英] Azure App Service cannot connect port 1434

问题描述

你好，谢谢阅读.

我遇到了Azure Web应用程序的问题.此应用必须连接到名为实例的SQL Server，但不能.我可以访问服务器，也可以连接到默认实例，但是由于某些原因，命名实例无法解析.从其他资源 (例如，预订中的VM)，我可以毫无问题地连接到实例.我认为与端口1434的ooutbound连接被阻止，因此我无法连接到SQL Browser，因此无法访问该实例.我知道这是因为当tcpping {SQL SERVER IP}:1434抛出超时.任何的想法?谢谢！

Hello and thanks for reading this.

I'm facing a problem with an Azure web app. This app has to connect to SQL server named instance but it cannot. I can reach the server and also connect to the default instance but, for some reason the named instances cannot be resolved. From other resources (for example a VM in the subscription) I can connect to the instance without problems. I think that the ooutbound connection to the port 1434 is blocked so I cannot connect to SQL Browser, so the instance cannot be reached. I know this because when tcpping {SQL SERVER IP}:1434 throws a timeout. Any idea? Thanks!

推荐答案

我不太清楚您所描述的场景.澄清一下，当您通过IP而不是通过DNS名称进行连接时，它可以工作吗?所有这些都是本地还是Azure中的SQL?

I'm a bit unclear of the scenarios you're describing. To clarify, it works when you connect via IP but not by DNS name? Are all of these on-premises or SQL in Azure?

我希望肯定会在入站上阻止端口1434，因此这将说明SQL Browser无法正常工作. App Service将在Azure中使用普通的DNS服务器，该服务器应该可以很好地解析所有DNS.我想你可以在Kudu中检查nslookup来看看 如果解决.

I would expect port 1434 to be blocked on the inbound for sure, so that would explain SQL Browser not working. The App Service is going to use a normal DNS server in Azure that should resolve all DNS just fine. I think you can check nslookup in Kudu to see if it resolves.

这篇关于Azure App Service无法连接端口1434的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！