遠程登錄SQL2005出錯
Error: 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
通過telnet IP 1433 發現服務器並沒有監聽
在服務器上netstat -an查看果然如此
檢查server property中security中是否啟用sql和Windows混和登錄和connection中是否allow remote connection
檢查configuration manager中是否啟用了tcp ip和named pipe
也可以在surface area 檢查configuration中檢查database engine的remote connection設置
檢查操作系統防火牆設置,打開1433端口
但是問題還是依舊,最後發現在configuration manager中tcp/ip的property中IP Address:IP1設置的IP和port均沒錯,而IPALL中居然設置了Dynamic Port
馬上設置1433後,問題解決,難道安裝完時就是這個作為默認值嗎?