资源描述:
《毕业论文外文翻译-如何解决 SQL Server 2000 中的连接问题》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、HowtotroubleshootconnectivityissuesinSQLServer2000ChrisTull,MicrosoftHelpandSupportThisarticlecanhelpyoutoresolveconnectivityproblemswithMicrosoftSQLServer2000.Thisarticlecontainsdescriptionsofcommonconnectivityproblemsandthestepsthatyoucantaketohelpresolveyourconnectivityproblems.SQLServer2000supp
2、ortsseveralmethodsofcommunicationbetweentheinstanceofSQLServerandtheclientapplications.IfyourclientapplicationandtheinstanceofSQLServerresideonthesamecomputer,MicrosoftWindowsinterprocesscommunication(IPC)components,suchaslocalnamedpipesortheSharedMemoryprotocol,areusedtocommunicate.However,whenthe
3、clientapplicationandtheinstanceofSQLServerresideondifferentcomputers,anetworkIPC,suchasTCP/IPornamedpipes,isusedtocommunicate.SQLServer2000usesNet-Library,aDLL,tocommunicatewithaparticularnetworkprotocol.AmatchingpairofNet-Librariesmustbeactiveontheclientcomputerandtheservercomputertosupportthenetw
4、orkprotocolthatyouwanttouse.Forexample,ifyouwanttoenableaclientapplicationtocommunicatewithaspecificinstanceofSQLServeracrossTCP/IP,theclientTCP/IPSocketsNet-Library(Dbnetlib.dll)mustbeconfiguredtoconnecttotheserverontheclientcomputer.Likewise,theserverTCP/IPSocketsNet-Library(Ssnetlib.dll)mustlist
5、enontheservercomputer.Inthisscenario,theTCP/IPprotocolstackmustbeinstalledonboththeclientcomputerandtheservercomputer.AfteryouinstallSQLServer2000,youcanconfigurethepropertiesoftheclientNet-LibrariesbyusingClientNetworkUtility.YoucanconfigurethepropertiesoftheserverNet-LibrariesbyusingServerNetwork
6、Utility(Svrnetcn.exe).TheserverNet-LibrariesareinstalledduringtheinstallationoftheservertoolsinSQLServerSetup.However,someoftheserverNet-Librariesmaynotbeactive.Bydefault,SQLServer2000enablesandlistensonTCP/IP,namedpipes,andSharedMemory.Therefore,foraclienttoconnecttoaservercomputer,theclientmustco
7、nnectbyusingaclientNet-LibrarythatmatchesoneoftheserverNet-LibrariesthatiscurrentlybeingusedbytheinstanceofSQLServer.ForadditionalinformationaboutSQLServercommunicationcomponentsandNet-Libraries,seethefollo