sqlserver错误解决 [英] sqlserver error solving

问题描述

当我在本地sqlserver中连接远程sqlserver时，有人告诉我.它显示以下错误
远程服务器名称为wdb1003.chi.us.securedata.net.

any one tell me when i connect the remote sqlserver in local sqlserver. it is showing the below error
the remote server name is wdb1003.chi.us.securedata.net.

===================================

Cannot connect to wdb1003.chi.us.securedata.net.

===================================

A network-related or instance-specific error occurred while establishing a connection to SQL 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) (.Net SqlClient Data Provider)

数据提供者)
数据提供程序)

Data Provider)
Data Provider)

推荐答案

检查远程服务器是否允许连接以及它使用的协议.

您正在尝试通过命名管道进行连接，请尝试使用TCP.

Check the remote server allows connections and what protocol it is using.

You are trying to connect via named pipes, try TCP instead.

^ ]

关注此链接可能会对您有所帮助.

http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx [

Follow this link may help you.

http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx[^]

这篇关于sqlserver错误解决的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！