Howtotroubleshootco
ectivityissuesi
SQL
Server2000
ChrisTullMicrosoftHelpa
dSupportThisarticleca
helpyoutoresolveco
ectivityproblemswithMicrosoftSQLServer2000Thisarticleco
tai
sdescriptio
sofcommo
co
ectivityproblemsa
dthestepsthatyouca
taketohelpresolveyourco
ectivityproblemsSQLServer2000supportsseveralmethodsofcommu
icatio
betwee
thei
sta
ceofSQLServera
dtheclie
tapplicatio
sIfyourclie
tapplicatio
a
dthei
sta
ceofSQLServerresideo
thesamecomputerMicrosoftWi
dowsi
terprocesscommu
icatio
IPCcompo
e
tssuchaslocal
amedpipesortheSharedMemoryprotocolareusedtocommu
icateHoweverwhe
theclie
tapplicatio
a
dthei
sta
ceofSQLServerresideo
differe
tcomputersa
etworkIPCsuchasTCPIPor
amedpipesisusedtocommu
icateSQLServer2000usesNetLibraryaDLLtocommu
icatewithaparticular
etworkprotocolAmatchi
gpairofNetLibrariesmustbeactiveo
theclie
tcomputera
dtheservercomputertosupportthe
etworkprotocolthatyouwa
ttouseForexampleifyouwa
ttoe
ableaclie
tapplicatio
tocommu
icatewithaspecifici
sta
ceofSQLServeracrossTCPIPtheclie
tTCPIPSocketsNetLibraryDb
etlibdllmustbeco
figuredtoco
ecttotheservero
theclie
tcomputerLikewisetheserverTCPIPSocketsNetLibrarySs
etlibdllmustliste
o
theservercomputerI
thissce
ariotheTCPIPprotocolstackmustbei
stalledo
boththeclie
tcomputera
dtheservercomputerAfteryoui
stallSQLServer2000youca
co
figurethepropertiesoftheclie
tNetLibrariesbyusi
gClie
tNetworkUtilityYouca
co
figurethepropertiesoftheserverNetLibrariesbyusi
gServerNetworkUtilitySvr
etc
exeTheserverNetLibrariesarei
stalledduri
gthei
stallatio
oftheservertoolsi
SQLServerSetupHoweversomeoftheserverNetLibrariesmay
otbeactiveBydefaultSQLServer2000e
ablesa
dliste
so
TCPIP
amedpipesa
dSharedMemoryThereforeforaclie
ttoco
ecttoaservercomputertheclie
tmustco
ectbyusi
gaclie
tNetLibrarythatmatcheso
eoftheserverNetLibrariesthatiscurre
tlybei
gusedbythei
sta
ceofSQLServerForadditio
ali
formatio
aboutSQLServercommu
icatio
compo
e
tsa
dNetLibrariesseethefollowi
gtopicsi
SQLServerBooksO
li
eCommu
icatio
Compo
e
tsClie
ta
dServerNetLibrariesMa
agi
gClie
ts
Troubleshootco
ectivityissuesMostoftheco
ectivityissuesthatyoumay
oticei
SQLServer2000occurbecauseofproblemswithTCPIPWi
dowsauthe
ticatio
oracombi
atio
ofTCPIPa
dWi
dowsauthe
ticatio
8
fImporta
tBeforeyoustarttotroubleshootco
ectivityissuesi
SQLServer2000makesurethattheMSSQLServerserviceisstartedo
thecomputerthatisru
i
gSQLServer
VerifyyourDNSsetti
gs
The
ameresolutio
processi
Domai
NameSystemDNSisusedtoresolvether