远程连接到Sql Server 2008 [英] Remote connection to Sql Server 2008

问题描述

大家好，
我有一个asp.net页，该页从服务器上的sql server2008中检索数据，
我已经完成了访问网络上的数据库所需的所有必要步骤.

但是当我运行我的应用程序时，它给了我类似
的错误
建立与SOL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:命名管道提供者，错误:40-无法打开与SQL Server的连接)''

请在这方面帮助我

:(
Mehboob
巴基斯坦

Hi everybody,
I have an asp.net page that retrieves data from sql server2008 on server,
I had done all the necessary steps which are required to access database on a network.

But when i run my application it gave me error like

''A network-related or instance-specific error occurred while establishing a connection to SOL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)''

Please help me in this regard

:(
Mehboob
Pakistan

推荐答案

显然，您需要检查连接字符串.您使用的是DNS名称吗?验证名称可以解析.使用IP地址?确认可以联系该地址.确保为远程连接正确配置了SQL Server实例

Obviously you need to check the connection string. Are you using a DNS name? Verify the name can be resolved. Using an IP address? Verify the address can be contacted. Ensure the SQL server instance is configured properly for remote connections

这篇关于远程连接到Sql Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！