Howtotroubleshootco
ectivityissuesi
SQL
Server2000
ChrisTullMicrosoftHelpa
dSupport
Thisarticleca
helpyoutoresolveco
ectivityproblemswithMicrosoftSQLServer2000
Thisarticleco
tai
sdescriptio
sofcommo
co
ectivityproblemsa
dthestepsthatyouca

taketohelpresolveyourco
ectivityproblems
SQLServer2000supportsseveralmethodsofcommu
icatio
betwee
thei
sta
ceof
SQL
Servera
dtheclie
tapplicatio
sIfyourclie
tapplicatio
a
dthei
sta
ceofSQLServerreside
o
thesamecomputerMicrosoftWi
dowsi
terprocesscommu
icatio
IPCcompo
e
tssuch
aslocal
amedpipesortheSharedMemoryprotocolareusedtocommu
icateHoweverwhe

theclie
tapplicatio
a
dthei
sta
ceofSQLServerresideo
ditTere
tcomputersa
eiwork
IPC
suchasTCPIPor
amedpipesisusedtocommu
icate
SQLServer2000usesNetLibraryaDLLtocommu
icatewithaparticular
etworkprotocolA
matchi
gpairofNetLibrariesmustbeactiveo
theclie
tcomputera
dtheservercomputerto
supportthe
etworkprotocolthatyouwa
ttouseForexampleifyouwa
ttoe
ableaclie
t
applicatio
tocommu
icatewithaspecifici
sta
ceofSQLServeracrossTCPIPtheclie
t
TCPIPSocketsNetLibraryDb
etlibdllmustbeco
figuredtoco
ecttotheservero
the
clie
tcomputerLikewisetheserverTCPIPSocketsNetLibrarySs
etlibdllmustliste
o
the
servercomputerI
thissce
ariotheTCPIPprotocolstackmustbei
stalledo
boththeclie
t
computera
dtheservercomputer
Afteryoui
stallSQLServer2000youca
co
figurethepropertiesoftheclie
tNetLibrariesby
usi
gClie
tNetworkUtilityYouca
co
figurethepropertiesoftheserverNetLibrariesby
usi
gServerNetworkUtilitySvr
etc
exeTheserverNetLibrariesarei
stalledduri
gthe
i
stallatio
oftheservertoolsi
SQLServefSetupHoweversomeoftheserverNetLibraries
may
otbeactiveBydefaultSQLServer2000e
ablesa
dliste
so
TCPIP
amedpipesa
d
SharedMemoryThereforeforaclie
ttoco
ecttoaservercomputertheclie
tmustco
ect
byusi
gaclie
tNetLibrarythatmatcheso
eoftheserverNetLibrariesthatiscurre
tlybei
g
usedbythei
sta
ceofSQLServer
Foradditio
ali
formatio
aboutSQLServercommu
icatio
compo
e
tsa
dNetLibrariessee
thefollowi
gtopicsi
SQLServerBooksO
li
e
Commu
icatio
Compo
e
ts

Clie
ta
dServerNetLibraries
Ma
agi
gClie
ts
Troubleshootco
ectivityissues
Mostoftheco
ectivityissuesthatyoumay
oticei
SQLServer20000ccurbecauseof
problemswithTCPIPWi
dowsauthe
ticatio
oracombi
atio
ofTCPIPa
dWi
dows
authe
ticatio

8
Importa
tBeforeyoustarttotroubleshootco
ectivityissuesi
SQLServer2000makesurethat
theMSSQLServerserviceisstartedo
thecomputerthatisru
i
gSQLServer
VerifyyourDNSsetti
gs
The
ameresolutio
processi
Domai
Namer