无法连接到远程sql服务器失败,将应用程序发布到远程服务器时无法连接到SQL

应用程序加载，但是当应用程序尝试连接到SQL时，需要一段时间才能加载，然后返回错误 . 使用DataLink(.udl文件)测试连接属性时，它是成功的 . 该应用程序在我的本地计算机上运行良好 . 我到处搜索，设置都很好，网络管理员验证了防火墙，一切都设置正确 . 我错过了什么？

我注意到它在错误中提到了Name Pipes，但是，这不应该使它成为TCP吗？

SQLConnectionString.NetworkLibrary = "dbmssocn";

这是我的连接字符串的方法：

public string GetReachoutConnectionString()

{

SqlConnectionStringBuilder SQLConnectionString = new SqlConnectionStringBuilder();

SQLConnectionString.TypeSystemVersion = "Latest";

SQLConnectionString.NetworkLibrary = "dbmssocn";

SQLConnectionString.DataSource = "10.10.xxx.xx,1433";

SQLConnectionString.InitialCatalog = "cat";

SQLConnectionString.UserID = "xxx";

SQLConnectionString.Password = "xxx";

SQLConnectionString.MultipleActiveResultSets = true;

SQLConnectionString.ApplicationName = "Website";

return SQLConnectionString.ConnectionString;

}

这是我得到的错误：

[Win32Exception(0x80004005)：找不到网络路径] [SqlException(0x80131904)： Build 与SQL Server的连接时发生与网络相关或特定于实例的错误 . 服务器未找到或无法访问 . 验证实例名称是否正确，以及SQL Server是否配置为允许远程连接 . (提供者：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接)] System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity标识，SqlConnectionString connectionOptions，SqlCredential凭证，Object providerInfo，String newPassword，SecureString newSecurePassword， Boolean redirectedUserInstance，SqlConnectionString userConnectionOptions，SessionData reconnectSessionData，DbConnectionPool pool，String accessToken，Boolean applyTransientFaultHandling)1394 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options，DbConnectionPoolKey poolKey，Object poolGroupProviderInfo，DbConnectionPool pool，DbConnection owningConnection，DbConnectionOptions userOptions)1120 System . Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool池，DbConnection owningObject，DbConnectionOptions选项，DbConnectionPoolKey poolKey，DbConnectionOptions userOptions)70 System.Data.ProviderBase.DbConnectio nPool.CreateObject(DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection)964 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection)114 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject，UInt32 waitForMultipleObjectsTimeout， Boolean allowCreate，Boolean onlyOneCheckConnection，DbConnectionOptions userOptions，DbConnectionInternal＆connection)1631 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject，TaskCompletionSource1 retry，DbConnectionOptions userOptions，DbConnectionInternal＆connection)117 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection，TaskCompletionSource1 retry，DbConnectionOptions userOptions，DbConnectionInternal oldConnection，DbConnectionInternal＆connection)267 System.Data.ProviderBase.DbConnectionInternal.TryOpe nConnectionInternal(DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource1 retry，DbConnectionOptions userOptions)318 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)211 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)393 System.Data.SqlClient .SqlConnection.Open()122 System.Data.Common.DbDataAdapter.FillInternal(DataSet数据集，DataTable [] datatables，Int32 startRecord，Int32 maxRecords，String srcTable，IDbCommand命令，CommandBehavior行为)177 System.Data.Common.DbDataAdapter.Fill (DataSet dataSet，Int32 startRecord，Int32 maxRecords，String srcTable，IDbCommand command，CommandBehavior behavior)182 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet，String srcTable)123 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments参数)2964 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e)369 System.Web.UI.WebControls.ListCont rol.PerformSelect()43 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()139 System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e)36 System.Web.UI.Control.PreRenderRecursiveInternal()107 System . Web.UI.Control.PreRenderRecursiveInternal()204 System.Web.UI.Control.PreRenderRecursiveInternal()204 System.Web.UI.Control.PreRenderRecursiveInternal()204 System.Web.UI.Control.PreRenderRecursiveInternal()204System.Web.UI.Control.PreRenderRecursiveInternal()204 System.Web.UI.d__249.MoveNext()1400 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)13847892 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task )61 System.Web.Util.WithinCancellableCallbackTaskAwaiter.GetResult()32 System.Web.UI.d__523.MoveNext()9283