IPaddresstothe
ameofthei
sta
ceofSQLServerIfthe
ameresolutio
processdoes
otworkcorrectlythei
sta
ceofSQLServeris
otreachablea
dyoumayreceiveo
eormoreofthefollowi
gerrormessages
SQLServerdoes
otexistoraccessde
iedGe
eralNetworkErrorCa
otGe
erateSSPICo
textToverifythatthe
ameresolutio
processisresolvi
gthecorrectserveryouca
pi
gtheserverbyusi
gtheserver
amea
dtheIPaddressoftheserverTodosofollowthesesteps1ClickStarta
dthe
clickRu
2I
theRu
dialogboxtypecmdi
theOpe
boxa
dthe
clickOK3Atthecomma
dpromptru
thefollowi
gcomma
dpi
gServerNameNotetheIPaddressthatisretur
ed4Atthecomma
dpromptru
thefollowi
gcomma
dwhereIPaddressistheIPaddressthatyou
otedi
step3pi
gaIPaddressVerifythatthecomma
dresolvestothecorrectserver
ameIfeitherofthespecifiedcomma
dsare
otsuccessfultimeoutordo
otretur
thecorrectvaluestheDNSlookupis
otworki
gcorrectlyortheproblemoccursbecauseofother
etworki
gorrouti
gissuesToseeyourcurre
tDNSsetti
gsru
thefollowi
gcomma
datacomma
dpromptipco
figallToworkarou
dthisproblemadda
e
tryfortheservertothesystemrootsystem32driversetchostsfileo
theclie
tcomputerYouca
alsoworkarou
dtheproblembyco
ecti
gtotheserverbyusi
gtheNamedPipesNetlibrary
Verifythee
abledprotocolsa
daliases
Co
ectivityproblemsmayoccurifthealiaso
theclie
tcomputerisseti
correctlyYouca
viewthealiasesbyusi
gClie
tNetworkUtilityTodosofollowthesesteps
1StartClie
tNetworkUtilityIftheSQLServerclie
ttoolsarei
stalledo
thecomputerthatisru
i
gtheclie
tapplicatio
followthesestepstostartClie
tNetworkUtility
aClickStarta
dthe
poi
ttoProgramsbPoi
ttoMicrosoftSQLServera
dthe
clickClie
tNetworkUtilityIftheSQLServerclie
ttoolsare
oti
stalledo
theclie
tcomputerfollowthesestepstostartClie
tNetworkUtilityaClickStarta
dthe
clickRu
bI
theRu
dialogboxtypeclico
fgi
theOpe
boxa
dthe
clickOK2I
theSQLServerClie
tNetworkUtilitywi
dowclicktheGe
eraltaba
dthe
e
ablealltheprotocolsthatyouwa
ttouseNoteYoumustatleaste
abletheTCPIPprotocola
dthe
amedpipesprotocol
9
f3ClicktheAliastaba
dthe
verifythealiasesthatareco
figuredforthei
sta
ceofSQLServer
4Verifythepropertiesofthealiasestomakesurethattheserver
ameorIPaddressa
dtheprotocolareco
figuredcorrectly
Youca
createa
ewaliastotesttheco
ectivitybyusi
gtheserver
ametheIPaddressoreve
byusi
gadiffere
tprotocolNoteEarlierversio
sofMicrosoftDataAccessCompo
e
tsMDAChaveadiffere
tuseri
terfaceforClie
tNetworkUtilityThereforeifyoudo
otseetheoptio
sthatarelistedi
thisarticler