问题描述
我们已经在Azure中设置了到本地数据库的VPN连接，连接正常进行.我编写了一个MVC应用程序，尝试连接到SQL Server中的本地数据库，并收到以下错误:
We have setup our VPN connection in Azure to our on-premises database, the connect is working with no problems. I have written a MVC app that tries to connect to our on-premise database in SQL Server and am getting the following error:
我正在使用的连接字符串是:
The connection string I am using is:
name="productdbConnectionString" connectionString="Data Source=172.16.x.xx,1433;Initial Catalog=productdb;User Id=poppy;Password=poppyxxxxx" providerName="System.Data.SqlClient"
我已经打开TCP并命名管道，并且我在连接字符串中使用端口1433，所以有点困惑为什么我无法访问数据库?
I have opened TCP and named pipes and I am using port 1433 in the connection string so am a bit confused why I cannot access the database?
推荐答案
我们可以使用Hybrid Connection功能将Web应用连接到本地本地SQL Server数据库.请参考本文档，说明了如何使用混合连接从Azure App Service中的Web应用程序连接到本地SQL Server.
We could connect the web app to local on-premises SQL Server database using the Hybrid Connection feature. Please refer to this documentation that explained how to connect to on-premises SQL Server from a web app in Azure App Service using Hybrid Connections.
这篇关于到本地的Azure VPN无法从Azure Web应用程序连接SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！