资源描述:
《如何解决 SQL Server 2000 中的连接问题-毕业论文外文翻译》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、HowtotroubleshootconnectivityissuesinSQLServer2000ChrisTull,MicrosoftHelpandSupportThisarticlecanhelpyoutoresolveconnectivityproblemswithMicrosoftSQLServer2000.Thisarticlecontainsdescriptionsofcommonconnectivityproblemsandthestepsthatyoucantaketohelpresolveyourconnectivityproblems.SQLServer200
2、0supportsseveralmethodsofcommunicationbetweentheinstanceofSQLServerandtheclientapplications.IfyourclientapplicationandtheinstanceofSQLServerresideonthesamecomputer,MicrosoftWindowsinterprocesscommunication(IPC)components,suchaslocalnamedpipesortheSharedMemoryprotocol,areusedtocommunicate.Howev
3、er,whentheclientapplicationandtheinstanceofSQLServerresideondifferentcomputers,anetworkIPC,suchasTCP/IPornamedpipes,isusedtocommunicate.SQLServer2000usesNet-Library,aDLL,tocommunicatewithaparticularnetworkprotocol.AmatchingpairofNet-Librariesmustbeactiveontheclientcomputerandtheservercomputert
4、osupportthenetworkprotocolthatyouwanttouse.Forexample,ifyouwanttoenableaclientapplicationtocommunicatewithaspecificinstanceofSQLServeracrossTCP/IP,theclientTCP/IPSocketsNet-Library(Dbnetlib.dll)mustbeconfiguredtoconnecttotheserverontheclientcomputer.Likewise,theserverTCP/IPSocketsNet-Library(S
5、snetlib.dll)mustlistenontheservercomputer.Inthisscenario,theTCP/IPprotocolstackmustbeinstalledonboththeclientcomputerandtheservercomputer.AfteryouinstallSQLServer2000,youcanconfigurethepropertiesoftheclientNet-LibrariesbyusingClientNetworkUtility.YoucanconfigurethepropertiesoftheserverNet-Libr
6、ariesbyusingServerNetworkUtility(Svrnetcn.exe).TheserverNet-LibrariesareinstalledduringtheinstallationoftheservertoolsinSQLServerSetup.However,someoftheserverNet-Librariesmaynotbeactive.Bydefault,SQLServer2000enablesandlistensonTCP/IP,namedpipes,andSharedMemory.Therefore,foraclienttoconnecttoa
7、servercomputer,theclientmustconnectbyusingaclientNet-LibrarythatmatchesoneoftheserverNet-LibrariesthatiscurrentlybeingusedbytheinstanceofSQLServer.ForadditionalinformationaboutSQLServercommunicationcomponentsandNet-Libraries,seethefollo