cant connecto to sql server 2000 sp3a in windows server 2003

hi guys im having troubles to connecto to sql server, my clients are win xp
and win 2000 pro, before i had the sql server 2000 on a windows 2000 server
and all worked fine, but two days ago i changed to windows server 2003
standard and the problems began...
when i try to connect to sql by odbc or by another way its the screen that
appears, the extrange is that in downstair there are 4 pcs and that 4 can
connect to sql, (all winXP Sp1 in spanish), upstairs there are 3 winXp
spanish, 2 winxp english(1 with SP2 the other Sp1) and 1 win2000 Sp4 pro
english and just 1 XP in spanish can connect the other 2 not, i thought it
was a problem with the server but now i connect a new laptop with winXP
spanish SP2 and it works fine... so i dont know what to do, all pcs have
mdac 2.8
now i thought its problem with clients but i cant find difference between
pcs except for the language
what can be?
i tried to connect by IP, i checked the port and nothing works =(
begin 666 error.gif
M1TE&.#EA!P+&`.8``````.5($P!+YP`DI@.`.?7BH]%MDJ_'OXK$M"B)T]>OH
MUV-OA@.!BZ0`[X =$P7%O9)FWU.A^929#<2\\(,KH_P!F_P!:YP`?TK;8\0@.A
MDC.9_^?U_XVJQ !0WCA2L !F_^_8TN9J38V5GA9J[L/%O]5*)0!;\ !3YJ;-
M\WF:O `FK ``2 H8@.QHO6/___^5>-TZ&W^R1>4.$[4)6=]4U!"&)_P!*W-[H
M\["TM,O<^0!9^)RBS-K9S!,D3%2/\0=R_7"*M.[O]HJ;T 4VM@.!,[QM0OCI%
MF_"FE)B[]KO(Z0)D]1DFB@.@.QV*W"V4ANM@.A5W0`SF:>LKH"HV@.%(T0`[TJRH
MF=]3,$-CF^;HZP!S_2N0__'Y_YB=I-W?[0!1\-?L_VB"S*TY'+W W2DZF7)^
MDP`@.R-[O_P!#W'N:R-5%&YNJV1J"_X>T^^9E0RL_8KC<_P`SS D<BN50(N=S
M63^7_P!@.[EEUQ@.!#S]?>W4I5HP`>H `3C&:9__.[K;/!S/___R'Y! 44`'\`
M+ `````'`L8```?_@.!."@.E.%-H>''1T6C!8,#(V1DI.4E9:7F)F:FYR=GI8F
MH:*CI*6FIZBIJJNLK:ZOKY^RL[2UMK><7EXG)P*^O\#!5 K$Q(.%2C]KRVM:
MSG30T=+3U-76U]C9VMO<W=[?X.'BX^3EYN?HZ>KK[.?.[UHU-6L_5'#%A!9*
MR<QK\O!:- @.$2+"@.P8,($RI<R+"APX<0(TJ<2+&BQ8L8,VK<R+&AO(\@.0_;K
M]^.'B6$*)MQ1]*AELI)98LJ<&;/D#YHX<^K<R;.GSY] @.PH=2K2HT:-(DRH%
M6J&ITZ=0HTJ=2K6JU:M8LVK=NG7GOJ\ZPH:M0[9L'5XG0IVXT R#EG3N2_USN
MLTFWY->[>//JW<NWK]^_@. ,+'DRXL.'#B!,K7LRXL>/'D"/C;0DI$EJTBA0A
M0G0'CAX%<&Q,R=R(\J.[ILO"6LVZM>O7L%GAFDV[MNW;N'/KWBW+AQD7P(,+
M'^X"S%LXR/4@.?ZNHM.GGE'E+GTZ]NO7KV+-KWR[KLG<?"F)$F!.BC?D7Z%]8
M66\EC1408)"K4*%G`!SFBQA!-TW)N___``8HX( $%FC@.@.0@.FJ.""##;HX(,0
M&IC9A!16:.&%&&:HX88<=NCAAR!JZ$(,1Y0H7@.0HCC<'>>594 4()-\@.W``'*
MW=><?OL]TE^$//;HXX] !BGDD$0&&.*12":IY/^23';H0@.0E'A'#B2FJ6-X+
M)83A@.HPT(G>(<SGJ*$F19)9IYIEHIGEFDVRVZ>:;;+HPAXDGK LAB>6VHE^66
M<)0QHW)4V'#C?I>H:>BAB":JZ**,-HKHA2Z$,&4,(,A)WGDON-#'>GO:4X8*
M!)0!1Z =G, (!@.FTE `&+>60PR1 8N!"#@.(BL8$+** U`@.K H3 "+\#5>FNN
M9@.:[H*N.)JOLLLPVBU8P`D0:@.7C!A7!EIL!QJJ6G,Y9!Q1EGH &6!"T(\\0@.;
M+D#QB*L9P-HC$BYXP$(&;'SAGZQ%&!%$$[QLD,,`2^ 1Q!,G`,<"@./CJRV^9
M!A^;0P;.1BSQQ!3["*W_"VU4&5R>V+H@.AQPN;GO!IZ%^&RXO) KC0Q1"/_,9"
M2QED0-:8/!H\1<$N0'R9P:+%,0"Z>4 L@.PL[=-#P?SQ/X3/#+AR\8,P51RWU
MU%0_&PS&*:X87,<?]SIR*!Z>T9^%B0`W!AUF.V"$74$1U8!7[CPA0R,`(>$
MO2? ZP(2O,B0@.]R_YFTWL,'A;"Q:<>]P6=PLW %L%RH<[5_BWNG--^%WG_#W
MKR/,*OC>:-F-=^A-5SXX+[+Z6X#AP*)P*P:!5RW[[+2K"8P++]BY8@.C#=>WU
MME1<$#85OS R=!="6,#L_T7;3!;@.@.109-`#'%N"X8X 2]+MB1![D6W#H&
M_QY =("N]^!CSP(+ZK/?B Q!N' #W>HW`EP&!E<"O_STPPO&]VJH6_:VYP-R
MF2][:B@..``6HO7;9KVF1.-_WDB<K#QC!!6(80OV DR\7)(%L-*N="$=(0@./I
MXH3 >D$(=&>MX%C!=W+84P,+P]>,L7C*A#](2PLB](P05 >((2#,:X(9A@.
M`$8TV%MNU3@.7!&$(<3/""3+@.`";>P8E);%HH#%:*)X@.!.#!(F1:WV#0NGL*+
M8#0!$QV 13$V[@.XF",(3-Q $%L2/!6Q\HAO?,@.HSAL**6.09< ;@.1C<:S06$
MC(TB%\G(1CKRD9",I"09><)*>L$%5EBAG7@.G'!BF`?\!+IAA# 2\P0Y29('IC
MR)X+4@.D$!PRQC$T+BRC,R$7@.Q"$!7<!5`@.IIRT+ZLA0)#,(=X K:$4'2N"RSP
MXRF"><7AQ.&7T=L!$.- G&<JDXPLZ*,6;1E%L^$AF[7<YA@.G2<YRFO.<Z$RG
M.EMA24RVP5HM!$X;@.M.U`'PRE#-4P1Y(V8"TA.(-36/>#9(I!E<:C(EX,=@.^
M$.I$%BCA!'9PX@.D86L=7.M2B?+$EN@.P0B@.+N`']-^XLMF;B^]6%T'YT#SA*J
MV+22.E2A"0WI5RC*`K6Y``-CR !&%0K3O(CEIT -JE"'2M2B&O6H2$VJ4I?*
MU*8Z]:E0C:I4IXK4$WKL!>__Y"3&\D3/`'@.5E#-L@.#Y)Z8NR`)0%Z!("_L0`
MA1\8+'I 4 (*V+ /F&Z4#^2*PQOHZL0XW#6O)T7H79"0`R68;0<.#4(7IC""
M+P1A"4/H*5X(:UBBL0"N...@.`74^Z#W@.A]I1 S.QF)5M7F>[CKT*(P]^,L+X!
MG&"G(26M9&9+V]K:]K:XS:UDB.J"-&!UGO+D6,>\2@.-0^J(!<-AG`P1@.@.;(8
MS&QC8&.ZW-JT"D@.AEU\HPA XFT#IL6 (!9S5&.*@.A.Y*X;LG#2]>$I $%V@.6
MO0GXXMGB\#SAK+>][]VN%.)W@.S%L5[):6-MVE;!?^?F7LU\ASC[,^UU>!><+
M/H#M_TM-J]L*6QBW7,FPAC?,X0Y[F"L_[:T5L-J'K0I7#IHB+BB)0 3D*E<`
MHMC'^G[ @.)?]8,8W9D%)')"!>=6A*>M[RA#6YX"F3&%],FO*D/'HE" ;V<E.
MJ<,`6!"'(C=%RDL(`A!^7 &70OG*4ZZR4QP0!Q\#F050L0#[QESF)'<9S5'Q
M,IR77.0$V&%]J0S"%-Y\YCY_^,^ #K2@.!TWH0AOZT(<.2V]!EIY&OZ">*G8!
MBUU,5A/@.I2Z8ODE-;(+H#(] FB[H-*+?L($$5 "O>(B#J%...ZE:[^M6PCO56
M7$"#-)2 /;C^F%>)6UQ)MSBYE;YTINLBDV$;^]C(3C:FE?^P9&4[^]G01K8:
MXF<&),PKVB61M;:WS>UN>QO19BA!&L;]HG*/>]PT2'>ZM31I8"\W%'DY=K&S
M_>UZ_YG9;1Z"O?...[W[[^]]1X0,(PH" @.AO\X @./`PCXT.X7ER+>] :XQ"=.
M\8I;_.*O!DM8\$J<C@./'#'S0A0`HO5P!F*H19-'+5"[,\I8S!N,PY[#+9T[S
MP!BUDC^U)(MWOG.2-\ &5'C+6S:3B Q!Z^A(3[K2E\[TICO]Z5"/NM2G3O6J
M6_WJ6*\ZN+;.]:Y[_>M@.#[O8QT[VLIO][&A/^QD$(/:PAE7L5(C[#-W]<Z';
M_>YXS[O>]\[WOOO][X /O. '3_C_PAO^\(A/O.(7S_C&._[QD(\\X>>^!R:,
MX G%R+SF-\_YSGO^\Z /O>A'3_K2F_[TJ$^]ZE?/^M:[_O6PC[WL9T_[U#=@.
M`)6_?.UWS_O>^_[WP ^^\(=/_.(;'_6WSSWFC\_\YCO_^="/OO2G3WW3)]_R
MRZ^^]K?/_>Y[__O@.+_[U=1_^\IO__.A/O_JA/_[LK__]\(^__.<__P;H0?GT
MS[_^]\___A/?_OCG?P(X@. 18@. :H>0"(?0>X@. S8@. X8?@.E(?@.\X@.118@.1;H
M>Q'H?A>X@.1S8@.1[H>1FH>GC0!5A0@.B98@.B3 `Q^X@.BS8@.N 7@.J9'`@.(C1Q[G
M`EN `RKH_X(ZN(,\*'[WIX"EAP7 L07"X0<X0(1#2(0W.( ```">YX2?!X4]
M.(542'LP*'IX@. 4T*!PSL (KT -(F(081 *OUX1-.'M2*(6BIX::YX1LN'EO
M6(5R.(>G=X6@.EX58$(; @.0<KP )[L ) ,!Q;$ 1;D ,XT'IQ"'N)&'J+2 R-
MJ "/2(>2.(F99X>>AP=9&#]B> ,K``4P``4)M 6B.(0WL 5-<(BJ%X=FZ(BK
M"(FMZ(II>(:K"(6M9L6(MG"(FZ"(O%8(N.2(G &(S%8(F<AXE:F(2B2(1"
M4 0P``8VN 4;$(W L0$WL $I0(:I]X9IN(NZN(W>F'G?^(O;V/^+G.>&W4B.
MXQB)PKB.+DB,FX>)S/.,R:B'TQB-]DB$-W #.4 &.7AZVHB.`"F.OJB&X7B.
MOTB.O3B+W3B0",F.#CF'[IAYF-@.%MS*/HR@.<]AB-9K"19B"*.6 &"\ %V0B'
M`6F0)GF0*&F.XMB0W/B-*MF0ZOB0,MF!$5D,8H 'I0B-&;D%0" !/BD!*Y "
M6\"11+D%7Y #3; `_6AZMUB2+_F4W-B24CF.*0F04)F.,YF5[?B#$MAY?H"3
M.KF3J44`<1 '!""4'/D%:OD%&W"42> &J(AZOLB+4XF0KXB+NUB++$F0"DF+
MN0B+M*B5@.OF!-4D,?B &U:B11;D%.07_!7N !D.YEI))`4F0!"T@.`H.9F9J9
M?H6I`(=9C419E%<0!U# `I IF9*9`Y5YF9O9FJ[9?9UYF!])E)*Y!:-9FFC0
MEA2PF[Q)`:IIF9CYFL(YG,\7FWXPFZBIEAMPFZ:Y`;W9FZK9! *Q)G-19G<+7
MF1#@.!TF0G&NYG*39G,_)FTG0!! PG>H7DTQIG>I9?URI@.9OG!_"9`VH9GF;
MG+D9GA2 `4W0!%=@.GDQYEW]YBPK9>>B9EW\9E0`:BX&YG@.RZ?IW)`TW@.!TT@.
MG_1IGV; FV^0H6^ `N0I`7 IER1YD 39AD]8>E#IBC!9ERO9H"QZ?IVI`!P`
MGTF0`^&YG'L`_P4$``3.J:$9B@.(0``$&T -*":+@.2*(C"HZYB(M^295%6I55
M69 %VJ)26ISM&7H\D (<``$S^IPX!05>.@.880 $\ZJ,0D (]X 8BF8U):J1M
MN*8D294+2J).JJ(F&:53>J?&]Z(*@. ,<D*5-$*84\ 5H0"-%4*A%``52(*8;
M^J-H( $MP(^(&)4G6:1\*8L)^8KEF*)/ZI1XVJG;IZ<*P 58ZJ<8D*%(L*$H
M@. *HB@.%D6J82(*38R'HONOFJ),&H6:2J<GZJF\&GV@.&JI T*=9"@.%_JJ&*
M^J/"Z@.0](*1Q*:M.FHB[&JTHV:12N:FT:J>]FJU66*6D%P4+$*S"VO^G$)"J
M9-JG/7FF9-"L<HFI">J&`,J*2;JD+(FD"GJI]@.JOVIJOS/>KQ$ "9# #,T &
M*3"P6)JJ4@.`$5_"J+3 #(A"KM(>M^AJQ$\BOQ, #.$ &"S #;B !P8H$*" %
M+7"F"]"P2UE[!RJQ*$N8W'IZ/-"R) "P/_JQ+; `.."P*7NSPDFQG$<";@.`$
MXRH%JS0DN<.LMY.. &=O"Q03NT3-N:1;NS,X &()NFLC>7="FIEPJQ46BU
MKE>I]\J*37NS3\MY/$ &5["TL?>/(IJINZ>U6VNK=AFV.#NVG1<%Z8J&<EJ2
MU'JOYIB.:WJD5FF@.@.1FG>SNOLRJW$DNWPZ?_EY1*H&ZZD-8*N?3JEV [E;<Z
MK2C:I%R+N-JJN,5WN(?[I@.P9D+88NDTYIZ$;HGD+IYRKKYY+?*"+M6RZMRIY
MNH7+NK1:HB$*N&[;NCF[LN$7IX2;J06)NEAKNZP+N-1:O-7JN[WZNK_'M>TZ
MN7R;MW2IC:.+H(][O $:KTKJO)T+O.G7N^!;OM0'O<UWLN:[OBXJONS[OD[K
MOO [OX*)OKV'J;QWLK.HOE.XO^2+B/R[?__KC\W+?_:;OPF9P -<P),ZO?!:
MJ0+:O9?[P&B(OY@.[>D_IP $*F.XZH/@.JO5F+MQ?\A &<GB%<M<L[K_EWP&V;
MP)6KB(:+H'&[MC2L_[J:JHH(/,(@.BKO>R+QS6L-8V<(F++M#O,!L:[S]Q\(F
M&[BU:ZGRBJ_7*XL;?*NS>I6Z&\,XW*:#6ZUZJ;Q]6Z=0;,73:L5;K+JGF[SE
MZ+U+6J\?;*E1O+T+*<$4G,)PJ,9S?+7^*ZD3+']*_+!,?)*/6\6<VKB8*\AS
MV8B,J[?T^J3":[G6ZZ[7ZLB#+)!_2\F\*Z<@.K+9@.#*4R',G,* \9@.G*MPZ\EZ
M2\4JS)X!Z'U!_,6Y"LF1VY2F/*(^3+RS6Z*E*\-K;+J$G)>"Z\:3O,DKF<5Z
M;+R:#,H=[,NZ2J>>G+V7O+K)?,O-+,HK++_5M\J W,K&7,NPO,NI6ZN[3/^@.
MPTRZUCO&7,S+MUO 8LS*SJRYHYS"G&R[SZS(H/S#E_O.\DS'TDQ_?2S"PRS(
M])S,WQS$YCS0NBO0X/S)[7S#K7S//.R4J6O*S3N\]DS*[7RB`IW->^G,$WW-
MA3S#^DS-U!?+'[S(>+R]4ZS%)PR8U)O2)7V@.5IO(8PS'*HW$8:S-&JS +QW"
M_LN[WPO0"0JV3PRG$LS&$#W'B6S1<IRYN$O$#@.K2TV?$J<C4]YM_W6Q\4)W#
M1+JX^?S1J=Q]%AQ\>0R[5_VY4CS6_VG6?AS5L,O ^K?/]/O6-.G4<#W7E.C6
M!5C"CXC6=$V==EVU7^VL.@.S.!PUZ>KW7P]G7,"S_Q 2,JXQMV$R+V%V;QFM\
MQS\]H$H:P37]Q#-=V(ZMF9 =J1K-J<6[T<K[QY$LU9W]O'(=?<7\S-D;S^2L
MTW'LRYR=VIZ]VM#7VAL=V\#,VRX9SJAMVZK=U5X=VA3-T;W=R76)T;4MW#/Y
MV5W;TYS<TD!=T[RMTDVLH,/KW-D*W=S]W9R)V^ ]W@.WHW>1]WK IWNB]WOYG
MWO WULW-WI+HWFJ:U'KLP3;,B%!,W?O-UO+=H/2]V'1<VHM8H-D\W1O\WU,:
MX$/<T03NO6&<X,:=W'NLX "NWLX'TPTLTZ%,T#<<R!%MX9W*X".YS;0LVP^,
MR*(]R?$MXA")X;G=SX/]_\H8O.*G'=PN3K0P_GR-3,32VM!F#-O^G>/J2>*D
M)[U#/=-*C9=X[+ALS-]72^0,:N2@.+>523N4`;.5$CN5:WN6VM^->'N;.Q^5B
M7N:@.1^:$_=,ZO+G1_=<CF>)FSHYH?L4*G=\H7,%''.? ..>"C<5YGME<7,E^
MGMTK*LRGK.=TR.=.[N"++LGO',&4J]3H.,&:C.AU#>;I*^.X"LV$S.GCO-15
M'<.6'HR*ONFU/.,9+='Y#>K!#<^C/M^8SGP]GM?*'.*5'N*Y:^@.M_NKM'>N+
MRZY)GM(:[K7<Z\'$7MI-SNN73MSHM^O*'K&E;J+._NS=[>O4?NVE%^W8[N+:
M_O^U]XO9;KZ#82WK)?S4DOB_D=CM*1F+.%[CC$[22H[D^JOF/A[N]6WH1]Z2
M&MS#.UW%97VD+RWA6JS7:&VGMV[N^MW8(&CM8.W"F9O8FOZL' KW=%VS0AUZ&
M%Y^>0"ZYD_K#`^W#%A_8=Y[6@.*U]Z!YZZK[<!MF7^RW=9?W+USS+'?W-*MS%
M@.5[&Y/S%?HOSNPK,.(_/0'S/-%_QE;SSN;O9]@.WL28V_1RVX47Z]]TW4$![A
MD$[U"^K GY?ROZW.DI[K,-_S,:_A*!WQ8]_#-*Z_E,KSDGSCLUWH2L[ DVV7
M<-S-30_B9N_.-C[ANKRV/Z_;!:[<RBS,!P[06<_PP&?_S?Z\]M/]];BLR*A^
M]**+W]F-S#D?M[D<\;(LS@.\MZDM]]*$^VX8,Y[H]Z?L;Y""?TP)9\XZ/W;0[
MD.RNT<P,^D->B88?O3/,]:".T8R?^9!_XJM/\[SOZHW/]S/_R^G<\7!/TYZ/
MVK$KSH4KY$B*]Y O^ IL^M:?T77L\+7^VT#?>5H_Z/C,^QWN]4%?SH0M\::^
M_)%;Y[C>P+@..I9L_\YW_\2*?W,1\_>-_R2!O^94_X0D=S8"@.`*! *%AH2#@.X
MF(AHJ%CXR-AX2-B@.M\<T\D3)V>GY"1K*N3CIF @.0>;J(2LHJ>0I9ZJK:.DM[
MR$HJB IIN\NK^BH\JWO[VHH+_UR<FMNKW/L+W-CLVAQK'6RL34RIRSU*+!V^
M'/L+G;QZ;0Z++NR\JAP//P\N?XQH:UU\FI*0HPH$!/^P8:!)7JH$)<"QLZ
M#)CPH<12HR9:O(@.QH\:-HOIEVL0QHZ^0!'F-))D,I<I@.)U=VD_8)ILN9-&O:
MK'3IX\V=/'OZ_ DTJ-"A+CW^(XHTJ=*E3)LZ=6H4Y-.I5*M:O8J5:M2L7+MZ
M_0HV[,"M8LN:/8LVK4^R:MNZ?0LW+BBV<NO:O8O7*MV\?/OZ_3MS+^#!A L;
M!BCXL.+%C/DF;@.PYLN2RCR=;OHRY:>7,G#M[MKGYL^C1I">&+HTZM6I/IU>[
M?CVZ-?_LV;0GRZX--I?NW;Q[^_X-/'A+W&AO$^\*P(7RY<R;.W\./;KTZ<X?
M%#QNUCAVK,D/>/\./KSX\>3+FS\/OHKU[6VULZ_:G:OZZ^^_NJ__-+ZI1_SW
M^^\/X'\"!KC(?/B===^!3,5'GU*#&*B@.6 E&F)1^6$%(H7TY'96A5PQ>E$\Y
M$SVX7H=>36AB4!:.6$XZ&6&8(E8HQNC3AQ*1$]&-"L!(8U4S]KC3B@._AV*!#
M/ +YU(](UF3CD-WLHA&)12Y)E))4NB2D0SA2--&15RIEY9<H->FD)"Y*68
M4&THE9H.NG" 2.*(&7;@.H5YIU1PLGE@.CN6J"=2>08*(I__6=E):$^#)GHC
MGU,2E2:C>+(IJ5#Z$3A@.IIANJBDBB%9:TZ*@.*I0E59^.6A2EJ /:47!6NO@.IK
MK++.2FNMMMX:*Z"KWB3JKA ]`&RPP@.Y+;+'&'HMLLL4^ZNM&O38;BG#23DMM
MM=""INJUVB+Y[+;>BM;MM^)F%NZXYDI6[KGJ+I;NNNX2UNZ[\ O85[[SVVE7O
MO?J^E>^^_A:7[;\"8];/!4P\H8D`"B_,\,)$/ QQQ!)/3''%%E^,<<8:;\QQ
MQQY_#'+((H],<LDFGXQRRBJOS#(1#0QQR0!ZS$QSS3;?C'/..N_,<\\^_PQT
MT$(/37311A^-=-)*+\UTTTX_#;71*GM,37755E^-==9:;\UUUUY_#7;88H]-
5=MEFGXUVVFJOS7;;;K\-=]J!```[
`
end
Couple simple questions:
1. Are the English PC's on a different subnet by any chance?
2. Can you ping the SQL Server from the English PC's?
"Rick" <ricardo.blanco@.indap.com.mx> wrote in message
news:eFIMjgStEHA.904@.TK2MSFTNGP11.phx.gbl...
> hi guys im having troubles to connecto to sql server, my clients are win
xp
> and win 2000 pro, before i had the sql server 2000 on a windows 2000
server
> and all worked fine, but two days ago i changed to windows server 2003
> standard and the problems began...
> when i try to connect to sql by odbc or by another way its the screen that
> appears, the extrange is that in downstair there are 4 pcs and that 4 can
> connect to sql, (all winXP Sp1 in spanish), upstairs there are 3 winXp
> spanish, 2 winxp english(1 with SP2 the other Sp1) and 1 win2000 Sp4 pro
> english and just 1 XP in spanish can connect the other 2 not, i thought it
> was a problem with the server but now i connect a new laptop with winXP
> spanish SP2 and it works fine... so i dont know what to do, all pcs have
> mdac 2.8
> now i thought its problem with clients but i cant find difference between
> pcs except for the language
> what can be?
> i tried to connect by IP, i checked the port and nothing works =(
>
>

Can't connect to SQL Server 2000 with Visual Studio 2005

I've been using Delphi for years (Win 32) and connecting to my SQL Server
databases with no problem.
I am now trying to learn both VB and C#. (Visual studio 2005)
From the Data menu, I select Add New Data Source
I then choose Database
I select Microsoft SQL Server as the Data Source
The Add Connection Dialog appears
It populates the Server name dropdown with both of my SQL servers.
However, when I try to select a database name, the dropdown is never
populated.
If I manually enter a known database name and try to connect, I get a
TimeOut Expired (or server not responding) error.
This happens whether I use windows authentication or SQL server
authentication.
This drill works fine with Delphi (Win 32) and connects without a hitch.
Any help would be appreciated.
Regards,
Dave
Take a look at my connecting whitepaper on my blog. It lays down the basics.
I expect the rights are not setup correctly or you've chosen a server
instance that's not visible on the network.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Dave Davis" <online@.blindsided.org> wrote in message
news:uvZV0Qt3HHA.4400@.TK2MSFTNGP06.phx.gbl...
> I've been using Delphi for years (Win 32) and connecting to my SQL Server
> databases with no problem.
> I am now trying to learn both VB and C#. (Visual studio 2005)
> From the Data menu, I select Add New Data Source
> I then choose Database
> I select Microsoft SQL Server as the Data Source
> The Add Connection Dialog appears
> It populates the Server name dropdown with both of my SQL servers.
> However, when I try to select a database name, the dropdown is never
> populated.
> If I manually enter a known database name and try to connect, I get a
> TimeOut Expired (or server not responding) error.
> This happens whether I use windows authentication or SQL server
> authentication.
> This drill works fine with Delphi (Win 32) and connects without a hitch.
> Any help would be appreciated.
> Regards,
> Dave
>
|||Bill,
Remember, I connect without any problems using Borland's Delphi. I have for
years.
I also connect with no problems using ASP.
If the rights aren't setup properly or the instance wasn't visible on the
network it seems to me that I couldn't connect with anything.
Or, does .net require different rights or something else different in the
SQL server setup?
Thanks,
Dave
"William Vaughn" <billvaNoSPAM@.betav.com> wrote in message
news:elZYHTv3HHA.1484@.TK2MSFTNGP06.phx.gbl...
> Take a look at my connecting whitepaper on my blog. It lays down the
> basics. I expect the rights are not setup correctly or you've chosen a
> server instance that's not visible on the network.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ------
> "Dave Davis" <online@.blindsided.org> wrote in message
> news:uvZV0Qt3HHA.4400@.TK2MSFTNGP06.phx.gbl...
>

Can't connect to SQL Server 2000 with Visual Studio 2005

I've been using Delphi for years (Win 32) and connecting to my SQL Server
databases with no problem.
I am now trying to learn both VB and C#. (Visual studio 2005)
From the Data menu, I select Add New Data Source
I then choose Database
I select Microsoft SQL Server as the Data Source
The Add Connection Dialog appears
It populates the Server name dropdown with both of my SQL servers.
However, when I try to select a database name, the dropdown is never
populated.
If I manually enter a known database name and try to connect, I get a
TimeOut Expired (or server not responding) error.
This happens whether I use windows authentication or SQL server
authentication.
This drill works fine with Delphi (Win 32) and connects without a hitch.
Any help would be appreciated.
Regards,
DaveTake a look at my connecting whitepaper on my blog. It lays down the basics.
I expect the rights are not setup correctly or you've chosen a server
instance that's not visible on the network.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Dave Davis" <online@.blindsided.org> wrote in message
news:uvZV0Qt3HHA.4400@.TK2MSFTNGP06.phx.gbl...
> I've been using Delphi for years (Win 32) and connecting to my SQL Server
> databases with no problem.
> I am now trying to learn both VB and C#. (Visual studio 2005)
> From the Data menu, I select Add New Data Source
> I then choose Database
> I select Microsoft SQL Server as the Data Source
> The Add Connection Dialog appears
> It populates the Server name dropdown with both of my SQL servers.
> However, when I try to select a database name, the dropdown is never
> populated.
> If I manually enter a known database name and try to connect, I get a
> TimeOut Expired (or server not responding) error.
> This happens whether I use windows authentication or SQL server
> authentication.
> This drill works fine with Delphi (Win 32) and connects without a hitch.
> Any help would be appreciated.
> Regards,
> Dave
>|||Bill,
Remember, I connect without any problems using Borland's Delphi. I have for
years.
I also connect with no problems using ASP.
If the rights aren't setup properly or the instance wasn't visible on the
network it seems to me that I couldn't connect with anything.
Or, does .net require different rights or something else different in the
SQL server setup?
Thanks,
Dave
"William Vaughn" <billvaNoSPAM@.betav.com> wrote in message
news:elZYHTv3HHA.1484@.TK2MSFTNGP06.phx.gbl...
> Take a look at my connecting whitepaper on my blog. It lays down the
> basics. I expect the rights are not setup correctly or you've chosen a
> server instance that's not visible on the network.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---
> "Dave Davis" <online@.blindsided.org> wrote in message
> news:uvZV0Qt3HHA.4400@.TK2MSFTNGP06.phx.gbl...
>

cant connect to Sql server 2000 sp3a in windows 2003 server

hi guys im having troubles to connecto to sql server, my clients are win xp
and win 2000 pro, before i had the sql server 2000 on a windows 2000 server
and all worked fine, but two days ago i changed to windows server 2003
standard and the problems began...
when i try to connect to sql by odbc or by another way its the screen that
appears, the extrange is that in downstair there are 4 pcs and that 4 can
connect to sql, (all winXP Sp1 in spanish), upstairs there are 3 winXp
spanish, 2 winxp english(1 with SP2 the other Sp1) and 1 win2000 Sp4 pro
english and just 1 XP in spanish can connect the other 2 not, i thought it
was a problem with the server but now i connect a new laptop with winXP
spanish SP2 and it works fine... so i dont know what to do, all pcs have
mdac 2.8
now i thought its problem with clients but i cant find difference between
pcs except for the language
what can be?
i tried to connect by IP, i checked the port and nothing works =(
begin 666 error.gif
M1TE&.#EA!P+&`.8``````.5($P!+YP`DI@.`.?7BH]%MDJ_'OXK$M"B)T]>OH
MUV-OA@.!BZ0`[X =$P7%O9)FWU.A^929#<2\\(,KH_P!F_P!:YP`?TK;8\0@.A
MDC.9_^?U_XVJQ !0WCA2L !F_^_8TN9J38V5GA9J[L/%O]5*)0!;\ !3YJ;-
M\WF:O `FK ``2 H8@.QHO6/___^5>-TZ&W^R1>4.$[4)6=]4U!"&)_P!*W-[H
M\["TM,O<^0!9^)RBS-K9S!,D3%2/\0=R_7"*M.[O]HJ;T 4VM@.!,[QM0OCI%
MF_"FE)B[]KO(Z0)D]1DFB@.@.QV*W"V4ANM@.A5W0`SF:>LKH"HV@.%(T0`[TJRH
MF=]3,$-CF^;HZP!S_2N0__'Y_YB=I-W?[0!1\-?L_VB"S*TY'+W W2DZF7)^
MDP`@.R-[O_P!#W'N:R-5%&YNJV1J"_X>T^^9E0RL_8KC<_P`SS D<BN50(N=S
M63^7_P!@.[EEUQ@.!#S]?>W4I5HP`>H `3C&:9__.[K;/!S/___R'Y! 44`'\`
M+ `````'`L8```?_@.!."@.E.%-H>''1T6C!8,#(V1DI.4E9:7F)F:FYR=GI8F
MH:*CI*6FIZBIJJNLK:ZOKY^RL[2UMK><7EXG)P*^O\#!5 K$Q(.%2C]KRVM:
MSG30T=+3U-76U]C9VMO<W=[?X.'BX^3EYN?HZ>KK[.?.[UHU-6L_5'#%A!9*
MR<QK\O!:- @.$2+"@.P8,($RI<R+"APX<0(TJ<2+&BQ8L8,VK<R+&AO(\@.0_;K
M]^.'B6$*)MQ1]*AELI)98LJ<&;/D#YHX<^K<R;.GSY] @.PH=2K2HT:-(DRH%
M6J&ITZ=0HTJ=2K6JU:M8LVK=NG7GOJ\ZPH:M0[9L'5XG0IVXT R#EG3N2_USN
MLTFWY->[>//JW<NWK]^_@. ,+'DRXL.'#B!,K7LRXL>/'D"/C;0DI$EJTBA0A
M0G0'CAX%<&Q,R=R(\J.[ILO"6LVZM>O7L%GAFDV[MNW;N'/KWBW+AQD7P(,+
M'^X"S%LXR/4@.?ZNHM.GGE'E+GTZ]NO7KV+-KWR[KLG<?"F)$F!.BC?D7Z%]8
M66\EC1408)"K4*%G`!SFBQA!-TW)N___``8HX( $%FC@.@.0@.FJ.""##;HX(,0
M&IC9A!16:.&%&&:HX88<=NCAAR!JZ$(,1Y0H7@.0HCC<'>>594 4()-\@.W``'*
MW=><?OL]TE^$//;HXX] !BGDD$0&&.*12":IY/^23';H0@.0E'A'#B2FJ6-X+
M)83A@.HPT(G>(<SGJ*$F19)9IYIEHIGEFDVRVZ>:;;+HPAXDGK LAB>6VHE^66
M<)0QHW)4V'#C?I>H:>BAB":JZ**,-HKHA2Z$,&4,(,A)WGDON-#'>GO:4X8*
M!)0!1Z =G, (!@.FTE `&+>60PR1 8N!"#@.(BL8$+** U`@.K H3 "+\#5>FNN
M9@.:[H*N.)JOLLLPVBU8P`D0:@.7C!A7!EIL!QJJ6G,Y9!Q1EGH &6!"T(\\0@.;
M+D#QB*L9P-HC$BYXP$(&;'SAGZQ%&!%$$[QLD,,`2^ 1Q!,G`,<"@./CJRV^9
M!A^;0P;.1BSQQ!3["*W_"VU4&5R>V+H@.AQPN;GO!IZ%^&RXO) KC0Q1"/_,9"
M2QED0-:8/!H\1<$N0'R9P:+%,0"Z>4 L@.PL[=-#P?SQ/X3/#+AR\8,P51RWU
MU%0_&PS&*:X87,<?]SIR*!Z>T9^%B0`W!AUF.V"$74$1U8!7[CPA0R,`(>$
MO2? ZP(2O,B0@.]R_YFTWL,'A;"Q:<>]P6=PLW %L%RH<[5_BWNG--^%WG_#W
MKR/,*OC>:-F-=^A-5SXX+[+Z6X#AP*)P*P:!5RW[[+2K"8P++]BY8@.C#=>WU
MME1<$#85OS R=!="6,#L_T7;3!;@.@.109-`#'%N"X8X 2]+MB1![D6W#H&
M_QY =("N]^!CSP(+ZK/?B Q!N' #W>HW`EP&!E<"O_STPPO&]VJH6_:VYP-R
MF2][:B@..``6HO7;9KVF1.-_WDB<K#QC!!6(80OV DR\7)(%L-*N="$=(0@./I
MXH3 >D$(=&>MX%C!=W+84P,+P]>,L7C*A#](2PLB](P05 >((2#,:X(9A@.
M`$8TV%MNU3@.7!&$(<3/""3+@.`";>P8E);%HH#%:*)X@.!.#!(F1:WV#0NGL*+
M8#0!$QV 13$V[@.XF",(3-Q $%L2/!6Q\HAO?,@.HSAL**6.09< ;@.1C<:S06$
MC(TB%\G(1CKRD9",I"09><)*>L$%5EBAG7@.G'!BF`?\!+IAA# 2\P0Y29('IC
MR)X+4@.D$!PRQC$T+BRC,R$7@.Q"$!7<!5`@.IIRT+ZLA0)#,(=X K:$4'2N"RSP
MXRF"><7AQ.&7T=L!$.- G&<JDXPLZ*,6;1E%L^$AF[7<YA@.G2<YRFO.<Z$RG
M.EMA24RVP5HM!$X;@.M.U`'PRE#-4P1Y(V8"TA.(-36/>#9(I!E<:C(EX,=@.^
M$.I$%BCA!'9PX@.D86L=7.M2B?+$EN@.P0B@.+N`']-^XLMF;B^]6%T'YT#SA*J
MV+22.E2A"0WI5RC*`K6Y``-CR !&%0K3O(CEIT -JE"'2M2B&O6H2$VJ4I?*
MU*8Z]:E0C:I4IXK4$WKL!>__Y"3&\D3/`'@.5E#-L@.#Y)Z8NR`)0%Z!("_L0`
MA1\8+'I 4 (*V+ /F&Z4#^2*PQOHZL0XW#6O)T7H79"0`R68;0<.#4(7IC""
M+P1A"4/H*5X(:UBBL0"N...@.`74^Z#W@.A]I1 S.QF)5M7F>[CKT*(P]^,L+X!
MG&"G(26M9&9+V]K:]K:XS:UDB.J"-&!UGO+D6,>\2@.-0^J(!<-AG`P1@.@.;(8
MS&QC8&.ZW-JT"D@.AEU\HPA XFT#IL6 (!9S5&.*@.A.Y*X;LG#2]>$I $%V@.6
MO0GXXMGB\#SAK+>][]VN%.)W@.S%L5[):6-MVE;!?^?F7LU\ASC[,^UU>!><+
M/H#M_TM-J]L*6QBW7,FPAC?,X0Y[F"L_[:T5L-J'K0I7#IHB+BB)0 3D*E<`
MHMC'^G[ @.)?]8,8W9D%)')"!>=6A*>M[RA#6YX"F3&%],FO*D/'HE" ;V<E.
MJ<,`6!"'(C=%RDL(`A!^7 &70OG*4ZZR4QP0!Q\#F050L0#[QESF)'<9S5'Q
M,IR77.0$V&%]J0S"%-Y\YCY_^,^ #K2@.!TWH0AOZT(<.2V]!EIY&OZ">*G8!
MBUU,5A/@.I2Z8ODE-;(+H#(] FB[H-*+?L($$5 "O>(B#J%...ZE:[^M6PCO56
M7$"#-)2 /;C^F%>)6UQ)MSBYE;YTINLBDV$;^]C(3C:FE?^P9&4[^]G01K8:
MXF<&),PKVB61M;:WS>UN>QO19BA!&L;]HG*/>]PT2'>ZM31I8"\W%'DY=K&S
M_>UZ_YG9;1Z"O?...[W[[^]]1X0,(PH" @.AO\X @./`PCXT.X7ER+>] :XQ"=.
M\8I;_.*O!DM8\$J<C@./'#'S0A0`HO5P!F*H19-'+5"[,\I8S!N,PY[#+9T[S
MP!BUDC^U)(MWOG.2-\ &5'C+6S:3B Q!Z^A(3[K2E\[TICO]Z5"/NM2G3O6J
M6_WJ6*\ZN+;.]:Y[_>M@.#[O8QT[VLIO][&A/^QD$(/:PAE7L5(C[#-W]<Z';
M_>YXS[O>]\[WOOO][X /O. '3_C_PAO^\(A/O.(7S_C&._[QD(\\X>>^!R:,
MX G%R+SF-\_YSGO^\Z /O>A'3_K2F_[TJ$^]ZE?/^M:[_O6PC[WL9T_[U#=@.
M`)6_?.UWS_O>^_[WP ^^\(=/_.(;'_6WSSWFC\_\YCO_^="/OO2G3WW3)]_R
MRZ^^]K?/_>Y[__O@.+_[U=1_^\IO__.A/O_JA/_[LK__]\(^__.<__P;H0?GT
MS[_^]\___A/?_OCG?P(X@. 18@. :H>0"(?0>X@. S8@. X8?@.E(?@.\X@.118@.1;H
M>Q'H?A>X@.1S8@.1[H>1FH>GC0!5A0@.B98@.B3 `Q^X@.BS8@.N 7@.J9'`@.(C1Q[G
M`EN `RKH_X(ZN(,\*'[WIX"EAP7 L07"X0<X0(1#2(0W.( ```">YX2?!X4]
M.(542'LP*'IX@. 4T*!PSL (KT -(F(081 *OUX1-.'M2*(6BIX::YX1LN'EO
M6(5R.(>G=X6@.EX58$(; @.0<KP )[L ) ,!Q;$ 1;D ,XT'IQ"'N)&'J+2 R-
MJ "/2(>2.(F99X>>AP=9&#]B> ,K``4P``4)M 6B.(0WL 5-<(BJ%X=FZ(BK
M"(FMZ(II>(:K"(6M9L6(MG"(FZ"(O%8(N.2(G &(S%8(F<AXE:F(2B2(1"
M4 0P``8VN 4;$(W L0$WL $I0(:I]X9IN(NZN(W>F'G?^(O;V/^+G.>&W4B.
MXQB)PKB.+DB,FX>)S/.,R:B'TQB-]DB$-W #.4 &.7AZVHB.`"F.OJB&X7B.
MOTB.O3B+W3B0",F.#CF'[IAYF-@.%MS*/HR@.<]AB-9K"19B"*.6 &"\ %V0B'
M`6F0)GF0*&F.XMB0W/B-*MF0ZOB0,MF!$5D,8H 'I0B-&;D%0" !/BD!*Y "
M6\"11+D%7Y #3; `_6AZMUB2+_F4W-B24CF.*0F04)F.,YF5[?B#$MAY?H"3
M.KF3J44`<1 '!""4'/D%:OD%&W"42> &J(AZOLB+4XF0KXB+NUB++$F0"DF+
MN0B+M*B5@.OF!-4D,?B &U:B11;D%.07_!7N !D.YEI))`4F0!"T@.`H.9F9J9
M?H6I`(=9C419E%<0!U# `I IF9*9`Y5YF9O9FJ[9?9UYF!])E)*Y!:-9FFC0
MEA2PF[Q)`:IIF9CYFL(YG,\7FWXPFZBIEAMPFZ:Y`;W9FZK9! *Q)G-19G<+7
MF1#@.!TF0G&NYG*39G,_)FTG0!! PG>H7DTQIG>I9?URI@.9OG!_"9`VH9GF;
MG+D9GA2 `4W0!%=@.GDQYEW]YBPK9>>B9EW\9E0`:BX&YG@.RZ?IW)`TW@.!TT@.
MG_1IGV; FV^0H6^ `N0I`7 IER1YD 39AD]8>E#IBC!9ERO9H"QZ?IVI`!P`
MGTF0`^&YG'L`_P4$``3.J:$9B@.(0``$&T -*":+@.2*(C"HZYB(M^295%6I55
M69 %VJ)26ISM&7H\D (<``$S^IPX!05>.@.880 $\ZJ,0D (]X 8BF8U):J1M
MN*8D294+2J).JJ(F&:53>J?&]Z(*@. ,<D*5-$*84\ 5H0"-%4*A%``52(*8;
M^J-H( $MP(^(&)4G6:1\*8L)^8KEF*)/ZI1XVJG;IZ<*P 58ZJ<8D*%(L*$H
M@. *HB@.%D6J82(*38R'HONOFJ),&H6:2J<GZJF\&GV@.&JI T*=9"@.%_JJ&*
M^J/"Z@.0](*1Q*:M.FHB[&JTHV:12N:FT:J>]FJU66*6D%P4+$*S"VO^G$)"J
M9-JG/7FF9-"L<HFI">J&`,J*2;JD+(FD"GJI]@.JOVIJOS/>KQ$ "9# #,T &
M*3"P6)JJ4@.`$5_"J+3 #(A"KM(>M^AJQ$\BOQ, #.$ &"S #;B !P8H$*" %
M+7"F"]"P2UE[!RJQ*$N8W'IZ/-"R) "P/_JQ+; `.."P*7NSPDFQG$<";@.`$
MXRH%JS0DN<.LMY.. &=O"Q03NT3-N:1;NS,X &()NFLC>7="FIEPJQ46BU
MKE>I]\J*37NS3\MY/$ &5["TL?>/(IJINZ>U6VNK=AFV.#NVG1<%Z8J&<EJ2
MU'JOYIB.:WJD5FF@.@.1FG>SNOLRJW$DNWPZ?_EY1*H&ZZD-8*N?3JEV [E;<Z
MK2C:I%R+N-JJN,5WN(?[I@.P9D+88NDTYIZ$;HGD+IYRKKYY+?*"+M6RZMRIY
MNH7+NK1:HB$*N&[;NCF[LN$7IX2;J06)NEAKNZP+N-1:O-7JN[WZNK_'M>TZ
MN7R;MW2IC:.+H(][O $:KTKJO)T+O.G7N^!;OM0'O<UWLN:[OBXJONS[OD[K
MOO [OX*)OKV'J;QWLK.HOE.XO^2+B/R[?__KC\W+?_:;OPF9P -<P),ZO?!:
MJ0+:O9?[P&B(OY@.[>D_IP $*F.XZH/@.JO5F+MQ?\A &<GB%<M<L[K_EWP&V;
MP)6KB(:+H'&[MC2L_[J:JHH(/,(@.BKO>R+QS6L-8V<(F++M#O,!L:[S]Q\(F
M&[BU:ZGRBJ_7*XL;?*NS>I6Z&\,XW*:#6ZUZJ;Q]6Z=0;,73:L5;K+JGF[SE
MZ+U+6J\?;*E1O+T+*<$4G,)PJ,9S?+7^*ZD3+']*_+!,?)*/6\6<VKB8*\AS
MV8B,J[?T^J3":[G6ZZ[7ZLB#+)!_2\F\*Z<@.K+9@.#*4R',G,* \9@.G*MPZ\EZ
M2\4JS)X!Z'U!_,6Y"LF1VY2F/*(^3+RS6Z*E*\-K;+J$G)>"Z\:3O,DKF<5Z
M;+R:#,H=[,NZ2J>>G+V7O+K)?,O-+,HK++_5M\J W,K&7,NPO,NI6ZN[3/^@.
MPTRZUCO&7,S+MUO 8LS*SJRYHYS"G&R[SZS(H/S#E_O.\DS'TDQ_?2S"PRS(
M])S,WQS$YCS0NBO0X/S)[7S#K7S//.R4J6O*S3N\]DS*[7RB`IW->^G,$WW-
MA3S#^DS-U!?+'[S(>+R]4ZS%)PR8U)O2)7V@.5IO(8PS'*HW$8:S-&JS +QW"
M_LN[WPO0"0JV3PRG$LS&$#W'B6S1<IRYN$O$#@.K2TV?$J<C4]YM_W6Q\4)W#
M1+JX^?S1J=Q]%AQ\>0R[5_VY4CS6_VG6?AS5L,O ^K?/]/O6-.G4<#W7E.C6
M!5C"CXC6=$V==EVU7^VL.@.S.!PUZ>KW7P]G7,"S_Q 2,JXQMV$R+V%V;QFM\
MQS\]H$H:P37]Q#-=V(ZMF9 =J1K-J<6[T<K[QY$LU9W]O'(=?<7\S-D;S^2L
MTW'LRYR=VIZ]VM#7VAL=V\#,VRX9SJAMVZK=U5X=VA3-T;W=R76)T;4MW#/Y
MV5W;TYS<TD!=T[RMTDVLH,/KW-D*W=S]W9R)V^ ]W@.WHW>1]WK IWNB]WOYG
MWO WULW-WI+HWFJ:U'KLP3;,B%!,W?O-UO+=H/2]V'1<VHM8H-D\W1O\WU,:
MX$/<T03NO6&<X,:=W'NLX "NWLX'TPTLTZ%,T#<<R!%MX9W*X".YS;0LVP^,
MR*(]R?$MXA")X;G=SX/]_\H8O.*G'=PN3K0P_GR-3,32VM!F#-O^G>/J2>*D
M)[U#/=-*C9=X[+ALS-]72^0,:N2@.+>523N4`;.5$CN5:WN6VM^->'N;.Q^5B
M7N:@.1^:$_=,ZO+G1_=<CF>)FSHYH?L4*G=\H7,%''.? ..>"C<5YGME<7,E^
MGMTK*LRGK.=TR.=.[N"++LGO',&4J]3H.,&:C.AU#>;I*^.X"LV$S.GCO-15
M'<.6'HR*ONFU/.,9+='Y#>K!#<^C/M^8SGP]GM?*'.*5'N*Y:^@.M_NKM'>N+
MRZY)GM(:[K7<Z\'$7MI-SNN73MSHM^O*'K&E;J+._NS=[>O4?NVE%^W8[N+:
M_O^U]XO9;KZ#82WK)?S4DOB_D=CM*1F+.%[CC$[22H[D^JOF/A[N]6WH1]Z2
M&MS#.UW%97VD+RWA6JS7:&VGMV[N^MW8(&CM8.W"F9O8FOZL' KW=%VS0AUZ&
M%Y^>0"ZYD_K#`^W#%A_8=Y[6@.*U]Z!YZZK[<!MF7^RW=9?W+USS+'?W-*MS%
M@.5[&Y/S%?HOSNPK,.(_/0'S/-%_QE;SSN;O9]@.WL28V_1RVX47Z]]TW4$![A
MD$[U"^K GY?ROZW.DI[K,-_S,:_A*!WQ8]_#-*Z_E,KSDGSCLUWH2L[ DVV7
M<-S-30_B9N_.-C[ANKRV/Z_;!:[<RBS,!P[06<_PP&?_S?Z\]M/]];BLR*A^
M]**+W]F-S#D?M[D<\;(LS@.\MZDM]]*$^VX8,Y[H]Z?L;Y""?TP)9\XZ/W;0[
MD.RNT<P,^D->B88?O3/,]:".T8R?^9!_XJM/\[SOZHW/]S/_R^G<\7!/TYZ/
MVK$KSH4KY$B*]Y O^ IL^M:?T77L\+7^VT#?>5H_Z/C,^QWN]4%?SH0M\::^
M_)%;Y[C>P+@..I9L_\YW_\2*?W,1\_>-_R2!O^94_X0D=S8"@.`*! *%AH2#@.X
MF(AHJ%CXR-AX2-B@.M\<T\D3)V>GY"1K*N3CIF @.0>;J(2LHJ>0I9ZJK:.DM[
MR$HJB IIN\NK^BH\JWO[VHH+_UR<FMNKW/L+W-CLVAQK'6RL34RIRSU*+!V^
M'/L+G;QZ;0Z++NR\JAP//P\N?XQH:UU\FI*0HPH$!/^P8:!)7JH$)<"QLZ
M#)CPH<12HR9:O(@.QH\:-HOIEVL0QHZ^0!'F-))D,I<I@.)U=VD_8)ILN9-&O:
MK'3IX\V=/'OZ_ DTJ-"A+CW^(XHTJ=*E3)LZ=6H4Y-.I5*M:O8J5:M2L7+MZ
M_0HV[,"M8LN:/8LVK4^R:MNZ?0LW+BBV<NO:O8O7*MV\?/OZ_3MS+^#!A L;
M!BCXL.+%C/DF;@.PYLN2RCR=;OHRY:>7,G#M[MKGYL^C1I">&+HTZM6I/IU>[
M?CVZ-?_LV;0GRZX--I?NW;Q[^_X-/'A+W&AO$^\*P(7RY<R;.W\./;KTZ<X?
M%#QNUCAVK,D/>/\./KSX\>3+FS\/OHKU[6VULZ_:G:OZZ^^_NJ__-+ZI1_SW
M^^\/X'\"!KC(?/B===^!3,5'GU*#&*B@.6 E&F)1^6$%(H7TY'96A5PQ>E$\Y
M$SVX7H=>36AB4!:.6$XZ&6&8(E8HQNC3AQ*1$]&-"L!(8U4S]KC3B@._AV*!#
M/ +YU(](UF3CD-WLHA&)12Y)E))4NB2D0SA2--&15RIEY9<H->FD)"Y*68
M4&THE9H.NG" 2.*(&7;@.H5YIU1PLGE@.CN6J"=2>08*(I__6=E):$^#)GHC
MGU,2E2:C>+(IJ5#Z$3A@.IIANJBDBB%9:TZ*@.*I0E59^.6A2EJ /:47!6NO@.IK
MK++.2FNMMMX:*Z"KWB3JKA ]`&RPP@.Y+;+'&'HMLLL4^ZNM&O38;BG#23DMM
MM=""INJUVB+Y[+;>BM;MM^)F%NZXYDI6[KGJ+I;NNNX2UNZ[\ O85[[SVVE7O
MO?J^E>^^_A:7[;\"8];/!4P\H8D`"B_,\,)$/ QQQ!)/3''%%E^,<<8:;\QQ
MQQY_#'+((H],<LDFGXQRRBJOS#(1#0QQR0!ZS$QSS3;?C'/..N_,<\\^_PQT
MT$(/37311A^-=-)*+\UTTTX_#;71*GM,37755E^-==9:;\UUUUY_#7;88H]-
5=MEFGXUVVFJOS7;;;K\-=]J!```[
`
end
There is a way to find out - I think you should find out if the clients are
using "Named Pipes" or TCP/IP for connectivity.
Bring up the ODBC connection, then on the second page you should see a
button "Client connectivity". Go into this and make the bullet TCP/IP.
Please let me know if this fixed your problem.
=-Chris
On the clients that cannot connect, click the box "Client configuration"
"Rick" <ricardo.blanco@.indap.com.mx> wrote in message
news:ur4WMjStEHA.2688@.TK2MSFTNGP14.phx.gbl...
> hi guys im having troubles to connecto to sql server, my clients are win
xp
> and win 2000 pro, before i had the sql server 2000 on a windows 2000
server
> and all worked fine, but two days ago i changed to windows server 2003
> standard and the problems began...
> when i try to connect to sql by odbc or by another way its the screen that
> appears, the extrange is that in downstair there are 4 pcs and that 4 can
> connect to sql, (all winXP Sp1 in spanish), upstairs there are 3 winXp
> spanish, 2 winxp english(1 with SP2 the other Sp1) and 1 win2000 Sp4 pro
> english and just 1 XP in spanish can connect the other 2 not, i thought it
> was a problem with the server but now i connect a new laptop with winXP
> spanish SP2 and it works fine... so i dont know what to do, all pcs have
> mdac 2.8
> now i thought its problem with clients but i cant find difference between
> pcs except for the language
> what can be?
> i tried to connect by IP, i checked the port and nothing works =(
>
>
|||Chris thanks a lot, but ive found other way to solve it, i know maybe its
not the more correct but i reinstalled the Sql server because i found at
microsofts web a tool to check the ports, its name is PortQuery, with it
you can check for Sql server if it is running on a server, or network
connectivity and other things, i saw that the server doesnt aswer to the
tool, the ports 1433 and 1434 not respond, so i decided to reinstal Sql
server, and it solved the problem =)
the tools url is http://support.microsoft.com/kb/310513/EN-US/
Rick =)
"Christopher Conner" <someone@.someplace.com> wrote in message
news:%23u554sTtEHA.3872@.TK2MSFTNGP15.phx.gbl...
> There is a way to find out - I think you should find out if the clients
> are
> using "Named Pipes" or TCP/IP for connectivity.
> Bring up the ODBC connection, then on the second page you should see a
> button "Client connectivity". Go into this and make the bullet TCP/IP.
> Please let me know if this fixed your problem.
> =-Chris
>
> On the clients that cannot connect, click the box "Client configuration"
> "Rick" <ricardo.blanco@.indap.com.mx> wrote in message
> news:ur4WMjStEHA.2688@.TK2MSFTNGP14.phx.gbl...
> xp
> server
>
|||Rick, thanks for the tip about the tool.
Because you had to reinstall to fix it, tells me that next time you have
this problem, on the SQL Server itself, bring up the Server Network Utility
(located in Programs->Microsoft SQL Server) and double check that on the
enabled protocols list that TCPIP and Named Pipes is listed. I am betting
that they were not previously. If you want to stop clients from connecting,
this is the place to do so as you would just remove the protocols.
Cheers!
=-Chris
"Rick" <ricardo.blanco@.indap.com.mx> wrote in message
news:eN8LyBWtEHA.2788@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Chris thanks a lot, but ive found other way to solve it, i know maybe its
> not the more correct but i reinstalled the Sql server because i found at
> microsofts web a tool to check the ports, its name is PortQuery, with it
> you can check for Sql server if it is running on a server, or network
> connectivity and other things, i saw that the server doesnt aswer to the
> tool, the ports 1433 and 1434 not respond, so i decided to reinstal Sql
> server, and it solved the problem =)
> the tools url is http://support.microsoft.com/kb/310513/EN-US/
> Rick =)
> "Christopher Conner" <someone@.someplace.com> wrote in message
> news:%23u554sTtEHA.3872@.TK2MSFTNGP15.phx.gbl...
win[vbcol=seagreen]
can[vbcol=seagreen]
pro[vbcol=seagreen]
have[vbcol=seagreen]
between
>

Can't connect to SQL 2005 in Vista

Hi. I hope someone can give me some ideas.
I have a SQL 2005 dev installed in my Vista and I tried to register it from
my Win 2003 server which also has SQL 2005. I get a time out message, it
seems the server cannot connect to my vista sql server. I already set my
vista sql server remote connection and restarted. Any idea? I don't have
issue to connect my server SQL from my vista. Is it something to do with
vista?
Thanks
KLWhat does "set my vista sql server remote connection" mean? Did you use the
surface area configuration tool to ensure that outside connections via
TCP/IP would be enabled? Also, is it a named instance or a default
instance? Are you using the correct instance name while trying to register
from Windows Server 2003? Are you inside a domain or a workgroup? Is it
possible that Windows firewall (or hardware firewall(s), or a program like
ZoneAlarm etc.) is blocking you from connecting? Is SQL Server using the
default port (1433) or is it custom? Can you ping the Vista machine from
Windows Server 2003? If so, can you telnet to the Vista machine on port
1433?
Aaron Bertrand
SQL Server MVP
"KL" <KwanLoonLai@.msn.com> wrote in message
news:C5507C7F-DAAC-4102-A510-201C3C4E247F@.microsoft.com...
> Hi. I hope someone can give me some ideas.
> I have a SQL 2005 dev installed in my Vista and I tried to register it
> from my Win 2003 server which also has SQL 2005. I get a time out
> message, it seems the server cannot connect to my vista sql server. I
> already set my vista sql server remote connection and restarted. Any idea?
> I don't have issue to connect my server SQL from my vista. Is it something
> to do with vista?
> Thanks
> KL|||- I use surface area configuration to enbled the remote connection with
both TCP/IP and name pipes
- It is a default instance
- Yes I use correct instance name to register the server, in this case I
use my computer name
- This is within a domain
- There is no third party firewall program running in my Vista, and I do
suspect vista built in firewall may block it, anyway I can find out ? I read
an article from
http://support.microsoft.com/defaul...kb;EN-US;914277 I follow
the step and add the sqlbrowser to exception list. still not working.
- I don't think I change any port when I installed sql server, if 1433 is
default it should be it
- I cant telnet to my vista with port 1433, but ping is fine
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:ORzmx630HHA.4184@.TK2MSFTNGP06.phx.gbl...
> What does "set my vista sql server remote connection" mean? Did you use
> the surface area configuration tool to ensure that outside connections via
> TCP/IP would be enabled? Also, is it a named instance or a default
> instance? Are you using the correct instance name while trying to
> register from Windows Server 2003? Are you inside a domain or a
> workgroup? Is it possible that Windows firewall (or hardware firewall(s),
> or a program like ZoneAlarm etc.) is blocking you from connecting? Is SQL
> Server using the default port (1433) or is it custom? Can you ping the
> Vista machine from Windows Server 2003? If so, can you telnet to the
> Vista machine on port 1433?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "KL" <KwanLoonLai@.msn.com> wrote in message
> news:C5507C7F-DAAC-4102-A510-201C3C4E247F@.microsoft.com...
>|||> - I cant telnet to my vista with port 1433, but ping is fine
Sounds to me like 1433 is blocked. It may be Windows firewall... you will
have to go into the config and make sure SQL (port 1433) is allowed at least
from the Windows Server 2003 IP.
A|||Thanks. It works after I put port 1433 in vista firewall exception.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:OAix3d40HHA.536@.TK2MSFTNGP06.phx.gbl...
> Sounds to me like 1433 is blocked. It may be Windows firewall... you will
> have to go into the config and make sure SQL (port 1433) is allowed at
> least from the Windows Server 2003 IP.
> A
>

Can't connect to SQL 2005 in Vista

Hi. I hope someone can give me some ideas.
I have a SQL 2005 dev installed in my Vista and I tried to register it from
my Win 2003 server which also has SQL 2005. I get a time out message, it
seems the server cannot connect to my vista sql server. I already set my
vista sql server remote connection and restarted. Any idea? I don't have
issue to connect my server SQL from my vista. Is it something to do with
vista?
Thanks
KL
What does "set my vista sql server remote connection" mean? Did you use the
surface area configuration tool to ensure that outside connections via
TCP/IP would be enabled? Also, is it a named instance or a default
instance? Are you using the correct instance name while trying to register
from Windows Server 2003? Are you inside a domain or a workgroup? Is it
possible that Windows firewall (or hardware firewall(s), or a program like
ZoneAlarm etc.) is blocking you from connecting? Is SQL Server using the
default port (1433) or is it custom? Can you ping the Vista machine from
Windows Server 2003? If so, can you telnet to the Vista machine on port
1433?
Aaron Bertrand
SQL Server MVP
"KL" <KwanLoonLai@.msn.com> wrote in message
news:C5507C7F-DAAC-4102-A510-201C3C4E247F@.microsoft.com...
> Hi. I hope someone can give me some ideas.
> I have a SQL 2005 dev installed in my Vista and I tried to register it
> from my Win 2003 server which also has SQL 2005. I get a time out
> message, it seems the server cannot connect to my vista sql server. I
> already set my vista sql server remote connection and restarted. Any idea?
> I don't have issue to connect my server SQL from my vista. Is it something
> to do with vista?
> Thanks
> KL

Can't connect to SQL 2005 in Vista

Hi. I hope someone can give me some ideas.
I have a SQL 2005 dev installed in my Vista and I tried to register it from
my Win 2003 server which also has SQL 2005. I get a time out message, it
seems the server cannot connect to my vista sql server. I already set my
vista sql server remote connection and restarted. Any idea? I don't have
issue to connect my server SQL from my vista. Is it something to do with
vista?
Thanks
KLWhat does "set my vista sql server remote connection" mean? Did you use the
surface area configuration tool to ensure that outside connections via
TCP/IP would be enabled? Also, is it a named instance or a default
instance? Are you using the correct instance name while trying to register
from Windows Server 2003? Are you inside a domain or a workgroup? Is it
possible that Windows firewall (or hardware firewall(s), or a program like
ZoneAlarm etc.) is blocking you from connecting? Is SQL Server using the
default port (1433) or is it custom? Can you ping the Vista machine from
Windows Server 2003? If so, can you telnet to the Vista machine on port
1433?
--
Aaron Bertrand
SQL Server MVP
"KL" <KwanLoonLai@.msn.com> wrote in message
news:C5507C7F-DAAC-4102-A510-201C3C4E247F@.microsoft.com...
> Hi. I hope someone can give me some ideas.
> I have a SQL 2005 dev installed in my Vista and I tried to register it
> from my Win 2003 server which also has SQL 2005. I get a time out
> message, it seems the server cannot connect to my vista sql server. I
> already set my vista sql server remote connection and restarted. Any idea?
> I don't have issue to connect my server SQL from my vista. Is it something
> to do with vista?
> Thanks
> KL|||- I use surface area configuration to enbled the remote connection with
both TCP/IP and name pipes
- It is a default instance
- Yes I use correct instance name to register the server, in this case I
use my computer name
- This is within a domain
- There is no third party firewall program running in my Vista, and I do
suspect vista built in firewall may block it, anyway I can find out ? I read
an article from
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 I follow
the step and add the sqlbrowser to exception list. still not working.
- I don't think I change any port when I installed sql server, if 1433 is
default it should be it
- I cant telnet to my vista with port 1433, but ping is fine
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ORzmx630HHA.4184@.TK2MSFTNGP06.phx.gbl...
> What does "set my vista sql server remote connection" mean? Did you use
> the surface area configuration tool to ensure that outside connections via
> TCP/IP would be enabled? Also, is it a named instance or a default
> instance? Are you using the correct instance name while trying to
> register from Windows Server 2003? Are you inside a domain or a
> workgroup? Is it possible that Windows firewall (or hardware firewall(s),
> or a program like ZoneAlarm etc.) is blocking you from connecting? Is SQL
> Server using the default port (1433) or is it custom? Can you ping the
> Vista machine from Windows Server 2003? If so, can you telnet to the
> Vista machine on port 1433?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "KL" <KwanLoonLai@.msn.com> wrote in message
> news:C5507C7F-DAAC-4102-A510-201C3C4E247F@.microsoft.com...
>> Hi. I hope someone can give me some ideas.
>> I have a SQL 2005 dev installed in my Vista and I tried to register it
>> from my Win 2003 server which also has SQL 2005. I get a time out
>> message, it seems the server cannot connect to my vista sql server. I
>> already set my vista sql server remote connection and restarted. Any
>> idea? I don't have issue to connect my server SQL from my vista. Is it
>> something to do with vista?
>> Thanks
>> KL
>|||> - I cant telnet to my vista with port 1433, but ping is fine
Sounds to me like 1433 is blocked. It may be Windows firewall... you will
have to go into the config and make sure SQL (port 1433) is allowed at least
from the Windows Server 2003 IP.
A|||Thanks. It works after I put port 1433 in vista firewall exception.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OAix3d40HHA.536@.TK2MSFTNGP06.phx.gbl...
>> - I cant telnet to my vista with port 1433, but ping is fine
> Sounds to me like 1433 is blocked. It may be Windows firewall... you will
> have to go into the config and make sure SQL (port 1433) is allowed at
> least from the Windows Server 2003 IP.
> A
>

cant connect to server from another machine

Hi Friends
I have a sql server (2005 standard edition) on Win xp machine. i can connect to this server from my machine ok but others on the network try to connect i get following error

"An error has occurred during report processing.
Cannot create a connection to data source 'dataSource1'.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) "

but my remote connection allows remote connects. i also enabled "Named pipes" and "VIA" protocols under sql configuration manager but no avail.
any ideas on this one.
Thanks for your help.

Cheersyou need to config to enable this via surface area config tool|||Thanks for that and actually i tried that too but no avail.|||

Try disabling VIA, and restarting the SQL Server.

|||Peter
VIA is already disabled|||i also have sqlexpress on the same machine ,does it make any difference ?
BTW i stoped sqlexpress service but still made no difference!|||

The error you get most frequently indicates that TCP and/or Named Pipes are not enabled on the target SQL Server 2005.

The first thing is to make sure that these protocols are enables, and then restart the target SQL Server.

If you have SQL Server 2005 client tools installed on the remote client machine you can test the connection over TCP and Named Pipes, resp., by running the following commands:

sqlcmd -E -Stcp:<targetServer>

or

sqlcmd -E -Snp:<targetServer>

Notes:

- the switches -E -S are case sensitive, and must be in capital letters

- replace <targetMachine> with the name of the machine running the target SQL Server 2005.

If you still get errors their text may be helpful in troubleshooting further.

|||Peter
Thank you very much for your help.those 2 commands really helped.

first command (uses tcp) it connected ok but 2nd command(using np) gave an error.
so on target server i enabled Named pipes and restarted server and tried to connect again from remote machine and guess what it connect nicely. and now i can connect to target server from my report manager page also which was originally giving problem.
Thanks again for your help :)

one question remained though we've another sql server on a different machine which has too only TCP/IP enabled but all other PCs in the network able to connect without any problem!!

why my PC was any different ?
Thanks|||

How does your application specify the server in the connection string?

If it uses an alias, does the alias specify Named Pipes as the protocol? Is there any chance the connection string specifies the Named Pipes protocol through the "Network Library" or "Net" property, e.g. as "Network Library=dbnmpntw"?

|||Peter
here my application is Report Manager page (http://localhost/reportserver) and connection does not specify any protocols.

we installed sql server with default settings so i dont think there is any alias|||

I have had identical connection problem problems. The two commands are extremely helpful for diagnosis. I wish I had known them earlier. Thank you!

No matter what I try (enabling, disabling, stopping, restarting, ...), I cannot get TCP work, but the name pipes can be made work easily and I can certainly live with it.

hz

|||

Hi all

I am fascinated by this discussion. I have had similar problems.

I have access to 100 computers in the university library on the same network. Each pc is running Windows XP and has a copy os SQL Server 2005 installed (the full version and express).

I am manually connecting servers (but would love to know how to in T-SQL as well ;-)). A friend has helped me before, and we disabled Named Pipes and enabled TCPIP on some of the computers. We were then able to use the wizzard to connect these computers. I am using SQL Server Authentication, and each database, and all connections are using the same login, and I have set this up to have server role "svsadmin".

Unfortunately this does not work now. I have followed the instructions suggested above (and enabled both TCPIP and Named Pipes), and now, while I am able to connect the servers on different machines, the connected server does not have an icon that indicates that it is either

* started (green triangle) or

* stopped (red triangle)

but an empty little circle at the base of the satabase cream cylinder

I hope I have given the right amount of info.

Thanks in advance.

Greg

|||

Greg

did you mean ,you cant see whether "server" running or not ?

if so "sql server configuration manager" under configuration tools you should be able to see whether sql server running or not.

BTW if you dont use sqlexpress i suggest you uninstall it as it resolved many issues for me.i guess sql server 2005 and sqlexpress conflicting each other!

|||

Hi

Thanks for the response.

I have uninstalled SQL Server Express on 2 of the machines.

The servers are running - I'm sure of that, but unbelievably slowly. I have been able to view (in SQL Server Managment Studio) the contents of tables on either the local or networked server. (The server status is still being denoted by the empty white disc superimposed on the yellow server cylinder...)

So they must be running right? The SQL Server Configuration Manager agrees - but to me the server manager is telling me that the server is running locally, which is the case. The problem relates to the connected database...

Despite deleting the database, unfortunately still getting this unusual situation. I'm able to explore a database on either server from either computer once I have connected the servers. But unfortunately I can not use T-SQL to input into a table on the networked server. (I am using sp_addlinkedserver to link the server successfully.)

Could the problem be a network setting, and if so, what should I ask the network administrator to change?

Thanks

Greg

|||

am out of ideas on this Greg.

BTW after uninstalling sqlexpress have you restarted machines ?

if not give it a try and see .

cant connect to server from another machine

Hi Friends
I have a sql server (2005 standard edition) on Win xp machine. i can connect to this server from my machine ok but others on the network try to connect i get following error

"An error has occurred during report processing.
Cannot create a connection to data source 'dataSource1'.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) "

but my remote connection allows remote connects. i also enabled "Named pipes" and "VIA" protocols under sql configuration manager but no avail.
any ideas on this one.
Thanks for your help.

Cheersyou need to config to enable this via surface area config tool|||Thanks for that and actually i tried that too but no avail.|||

Try disabling VIA, and restarting the SQL Server.

|||Peter
VIA is already disabled|||i also have sqlexpress on the same machine ,does it make any difference ?
BTW i stoped sqlexpress service but still made no difference!|||

The error you get most frequently indicates that TCP and/or Named Pipes are not enabled on the target SQL Server 2005.

The first thing is to make sure that these protocols are enables, and then restart the target SQL Server.

If you have SQL Server 2005 client tools installed on the remote client machine you can test the connection over TCP and Named Pipes, resp., by running the following commands:

sqlcmd -E -Stcp:<targetServer>

or

sqlcmd -E -Snp:<targetServer>

Notes:

- the switches -E -S are case sensitive, and must be in capital letters

- replace <targetMachine> with the name of the machine running the target SQL Server 2005.

If you still get errors their text may be helpful in troubleshooting further.

|||Peter
Thank you very much for your help.those 2 commands really helped.

first command (uses tcp) it connected ok but 2nd command(using np) gave an error.
so on target server i enabled Named pipes and restarted server and tried to connect again from remote machine and guess what it connect nicely. and now i can connect to target server from my report manager page also which was originally giving problem.
Thanks again for your help :)

one question remained though we've another sql server on a different machine which has too only TCP/IP enabled but all other PCs in the network able to connect without any problem!!

why my PC was any different ?
Thanks|||

How does your application specify the server in the connection string?

If it uses an alias, does the alias specify Named Pipes as the protocol? Is there any chance the connection string specifies the Named Pipes protocol through the "Network Library" or "Net" property, e.g. as "Network Library=dbnmpntw"?

|||Peter
here my application is Report Manager page (http://localhost/reportserver) and connection does not specify any protocols.

we installed sql server with default settings so i dont think there is any alias|||

I have had identical connection problem problems. The two commands are extremely helpful for diagnosis. I wish I had known them earlier. Thank you!

No matter what I try (enabling, disabling, stopping, restarting, ...), I cannot get TCP work, but the name pipes can be made work easily and I can certainly live with it.

hz

|||

Hi all

I am fascinated by this discussion. I have had similar problems.

I have access to 100 computers in the university library on the same network. Each pc is running Windows XP and has a copy os SQL Server 2005 installed (the full version and express).

I am manually connecting servers (but would love to know how to in T-SQL as well ;-)). A friend has helped me before, and we disabled Named Pipes and enabled TCPIP on some of the computers. We were then able to use the wizzard to connect these computers. I am using SQL Server Authentication, and each database, and all connections are using the same login, and I have set this up to have server role "svsadmin".

Unfortunately this does not work now. I have followed the instructions suggested above (and enabled both TCPIP and Named Pipes), and now, while I am able to connect the servers on different machines, the connected server does not have an icon that indicates that it is either

* started (green triangle) or

* stopped (red triangle)

but an empty little circle at the base of the satabase cream cylinder

I hope I have given the right amount of info.

Thanks in advance.

Greg

|||

Greg

did you mean ,you cant see whether "server" running or not ?

if so "sql server configuration manager" under configuration tools you should be able to see whether sql server running or not.

BTW if you dont use sqlexpress i suggest you uninstall it as it resolved many issues for me.i guess sql server 2005 and sqlexpress conflicting each other!

|||

Hi

Thanks for the response.

I have uninstalled SQL Server Express on 2 of the machines.

The servers are running - I'm sure of that, but unbelievably slowly. I have been able to view (in SQL Server Managment Studio) the contents of tables on either the local or networked server. (The server status is still being denoted by the empty white disc superimposed on the yellow server cylinder...)

So they must be running right? The SQL Server Configuration Manager agrees - but to me the server manager is telling me that the server is running locally, which is the case. The problem relates to the connected database...

Despite deleting the database, unfortunately still getting this unusual situation. I'm able to explore a database on either server from either computer once I have connected the servers. But unfortunately I can not use T-SQL to input into a table on the networked server. (I am using sp_addlinkedserver to link the server successfully.)

Could the problem be a network setting, and if so, what should I ask the network administrator to change?

Thanks

Greg

|||

am out of ideas on this Greg.

BTW after uninstalling sqlexpress have you restarted machines ?

if not give it a try and see .

Can't connect to server - real newbie here

SLQ 2000, Win XP Pro network
I installed SQL (developer) 2000 on an XP Pro running SP2 (firewall turned
off)
The SQL server seems to be running fine in that I can access the default
tables from the local computer. The problem is, I can't connect to the SLQ
Server from another XP Pro client computer using Enterprise Manager. That
is, I can't register it. I get a "server does not exist" error.
I've tried both Windows authentication and SQL Server authentication. To
use SQL auth. I'm assuming that all I have to do is create a new login on
the server, which I have done. I've made sure this login is an administrator
with ownership and public rights to each database.
What else should I check or setup?
All help greatly appreciated!!
Karl wrote:
> SLQ 2000, Win XP Pro network
> I installed SQL (developer) 2000 on an XP Pro running SP2 (firewall
> turned off)
> The SQL server seems to be running fine in that I can access the
> default tables from the local computer. The problem is, I can't
> connect to the SLQ Server from another XP Pro client computer using
> Enterprise Manager. That is, I can't register it. I get a "server
> does not exist" error.
> I've tried both Windows authentication and SQL Server authentication.
> To use SQL auth. I'm assuming that all I have to do is create a new
> login on the server, which I have done. I've made sure this login is
> an administrator with ownership and public rights to each database.
> What else should I check or setup?
> All help greatly appreciated!!
What name are you using for the SQL Server? Can you see the other PC on
the network. Try using the IP address in case the name is not resolving
properly.
David Gugick
Imceda Software
www.imceda.com
|||Thank you for the reply.
As it turns out, I was trying this on a new installation of XP Pro running
SP 2 as I mentioned. As soon as I updated SQL 2000 with its service pack 3,
I was able to connect to the server from the client computers. Leave it to
my 14 year old son to suggest this solution. :-)
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:eR5zVb84EHA.3596@.TK2MSFTNGP12.phx.gbl...
> Karl wrote:
> What name are you using for the SQL Server? Can you see the other PC on
> the network. Try using the IP address in case the name is not resolving
> properly.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Can't connect to server - real newbie here

SLQ 2000, Win XP Pro network
I installed SQL (developer) 2000 on an XP Pro running SP2 (firewall turned
off)
The SQL server seems to be running fine in that I can access the default
tables from the local computer. The problem is, I can't connect to the SLQ
Server from another XP Pro client computer using Enterprise Manager. That
is, I can't register it. I get a "server does not exist" error.
I've tried both Windows authentication and SQL Server authentication. To
use SQL auth. I'm assuming that all I have to do is create a new login on
the server, which I have done. I've made sure this login is an administrator
with ownership and public rights to each database.
What else should I check or setup?
All help greatly appreciated!!Karl wrote:
> SLQ 2000, Win XP Pro network
> I installed SQL (developer) 2000 on an XP Pro running SP2 (firewall
> turned off)
> The SQL server seems to be running fine in that I can access the
> default tables from the local computer. The problem is, I can't
> connect to the SLQ Server from another XP Pro client computer using
> Enterprise Manager. That is, I can't register it. I get a "server
> does not exist" error.
> I've tried both Windows authentication and SQL Server authentication.
> To use SQL auth. I'm assuming that all I have to do is create a new
> login on the server, which I have done. I've made sure this login is
> an administrator with ownership and public rights to each database.
> What else should I check or setup?
> All help greatly appreciated!!
What name are you using for the SQL Server? Can you see the other PC on
the network. Try using the IP address in case the name is not resolving
properly.
--
David Gugick
Imceda Software
www.imceda.com|||Thank you for the reply.
As it turns out, I was trying this on a new installation of XP Pro running
SP 2 as I mentioned. As soon as I updated SQL 2000 with its service pack 3,
I was able to connect to the server from the client computers. Leave it to
my 14 year old son to suggest this solution. :-)
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:eR5zVb84EHA.3596@.TK2MSFTNGP12.phx.gbl...
> Karl wrote:
> > SLQ 2000, Win XP Pro network
> >
> > I installed SQL (developer) 2000 on an XP Pro running SP2 (firewall
> > turned off)
> >
> > The SQL server seems to be running fine in that I can access the
> > default tables from the local computer. The problem is, I can't
> > connect to the SLQ Server from another XP Pro client computer using
> > Enterprise Manager. That is, I can't register it. I get a "server
> > does not exist" error.
> >
> > I've tried both Windows authentication and SQL Server authentication.
> > To use SQL auth. I'm assuming that all I have to do is create a new
> > login on the server, which I have done. I've made sure this login is
> > an administrator with ownership and public rights to each database.
> >
> > What else should I check or setup?
> >
> > All help greatly appreciated!!
> What name are you using for the SQL Server? Can you see the other PC on
> the network. Try using the IP address in case the name is not resolving
> properly.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>