不同网段sql server 2005 连接 sql server 2000的问题
当使用Linked Server连接sql server 2000, 出现OLE DB provider "SQLNCLI" for linked server "server130" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "server130" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 1326, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [1326]. 这个错误提示。后来才发现安装有sql server数据库的电脑处于不同的网段。 这时就需要在装有sql server 2005的电脑上的C:\WINDOWS\system32\drivers\etc\hosts中添加要连接电脑的IP地址和电脑名,同时注意端口最好使用默认的1433.
OLE DB provider "SQLNCLI" for linked server "server130" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 1326, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [1326]. 这个错误提示。后来才发现安装有sql server数据库的电脑处于不同的网段。 这时就需要在装有sql server 2005的电脑上的C:\WINDOWS\system32\drivers\etc\hosts中添加要连接电脑的IP地址和电脑名,同时注意端口最好使用默认的1433.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16582684/viewspace-612700/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
记忆不太好，该做日志了
下一篇：
SQL2000 同步问题，字符被截断
请登录后发表评论
登录
全部评论
