资源描述：
《sql2000远程连接不上服务器解决方法》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、SQLservercannotconnecterrorandsolutioninremoteconnectionLANReading:373times:2010-03-1700:00:00font:[large,mediumandsmall.Thefirstmistake,"SQLServerdoesnotexistorisdeniedaccess",isusuallythemostcomplex,thereasonfortheerrorismore,theneedtocheckmoreaspects.Generallyspeaking,thereareseveralpo
2、ssibilities:1,SQLServernameorIPaddressspellingerror;2,serversidenetworkconfigurationerror;3,dientnetworkconfigurationerror・Tosolvethisproblem,wegenerallyfollowthefollowingstepstofindoutthecausesoferrorsstepbystep・First,checkthephysicalconnectionsofthenetwork:PingperhapsPi
3、ngIfPingfailure,indicatingphysicalconnectionproblems,atthistimetocheckthehardwaredevices,suchasnetworkcards,HUB,routersandsoon.AlsoOnepossibilityisthatthefirewallsoftwareisinstalledbetweentheclientandtheserver,suchasISAServer・Firewallsoftwaremayshieldping,Teln
4、etandsoon,sowhencheckingtheconnectionproblem,wehavetotemporarilyshutdownthefirewallsoftware,oropenallclosedports・IfPingsuccessandPingfailure,itmeansthereisaprobleminnameresolution,atthistimetocheckDNSsuitIsitnormal?・SometimestheclientandserverarenotinthesameLA
5、N,andatthispointitisunlikelythattheservernamewillbeusedtoidentifytheserverWhenwecanuseHOSTSfiletonameresolution,thespecificmethodis:1,useNotepadtoopentheHOSTSfile(usuallyinC:WINNTsystem32driversetc)2,addaIPaddressandservernamecorrespondingrecords,suchas:172.168.10.24MyserverItcanalsob
6、econfiguredintheclientnetworkutilityofSQLServer,whichwillbeexplainedindetaillater.Secondly,checktheworkingstatusofSQLServerserverusingthetelnetcommand:Telnet1433Ifthecommandisexecutedsuccessfully,youcanseethecursorflashingintheupperleftcorneraftertheflashofthescreen,which
7、meansthattheSQLServerserverisworkingandisworkingListentothe1433portTCP/IPconnection;ifthecommandreturnsunabletoopentheconnection"errorinformation,thentheserverdoesnotstartSQLServerserviceItisalsopossiblethattheserverdoesnotenabletheTCP/IPprotocol,ortheserverdoesnotl
