不同網段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.