Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>
Showing posts with label guys. Show all posts
Showing posts with label guys. Show all posts
Sunday, March 11, 2012
Can't Delete Meta Data Services Packages (Repost: No response on DTS SQL NG.)
Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>
Saturday, February 25, 2012
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'HON
OFJ),&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 =(
>
>
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"(6M
9L6(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'HON
OFJ),&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="FIEPJQ46BUMKE>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$)<"QLZM#)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
*68M4&THE9H.NG" 2.*(
&7;@.H5YIU1PLGE@.CN6J"=2>08*(I__6=E):$^#)GHCMGU,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 =(
>
>
Sunday, February 19, 2012
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
>
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"(6M
9L6(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'HON
OFJ),&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="FIEPJQ46BUMKE>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$)<"QLZM#)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
*68M4&THE9H.NG" 2.*(
&7;@.H5YIU1PLGE@.CN6J"=2>08*(I__6=E):$^#)GHCMGU,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
>
Thursday, February 16, 2012
Can''t connect to sql ce using sql server mgmt. studio express
Hi everybody,
i apperciate any help you guys can give me regarding this. I'm trying to connect to a sql ce db using sql server mgmt. studio express but from some reason i can't change the server type from the native engine (db engine) to sql ce (it's simply greyd out). I think I've installed all relevants to this (engine, sdk, etc...) but still nothing. The thing is, that on another machine I can do it and i can't figure out what more do I need for this to work.
Thanks again for your help.
Asaf Matyas
Tzunami Inc.
You need to install SQL Server Management Studio Express SP2 to be able to administer SQL Compact files. Download from:
http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en
Can''t connect to sql ce using sql server mgmt. studio express
Hi everybody,
i apperciate any help you guys can give me regarding this. I'm trying to connect to a sql ce db using sql server mgmt. studio express but from some reason i can't change the server type from the native engine (db engine) to sql ce (it's simply greyd out). I think I've installed all relevants to this (engine, sdk, etc...) but still nothing. The thing is, that on another machine I can do it and i can't figure out what more do I need for this to work.
Thanks again for your help.
Asaf Matyas
Tzunami Inc.
You need to install SQL Server Management Studio Express SP2 to be able to administer SQL Compact files. Download from:
http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en
Tuesday, February 14, 2012
Cant connect to my SQLExpress Instance
Hello guys,
I've got some troubles , by attempting to connect the SQL Server database to my server.
I've got this error message on the SQL Configuration Manager (when i tried to start SQL Server which was stopped) " The request failed or the service did not respond in a timely fashion.Consult the event log or the other applicable error logs for details "
I found that error log :
2007-12-18 19:36:12.20 Server Server process ID is 5080.
2007-12-18 19:36:12.20 Server Logging SQL Server messages in file'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-12-18 19:36:12.20 Server This instance of SQL Server last reportedusing a process ID of 1180 at 18/12/2007 19:12:20 (local) 18/12/200719:12:20 (UTC). This is an informational message only; no user actionis required.
2007-12-18 19:36:12.20 Server Registry startup parameters:
2007-12-18 19:36:12.20 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-12-18 19:36:12.20 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-12-18 19:36:12.20 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-12-18 19:36:12.20 Server SQL Server is starting at normal prioritybase (=7). This is an informational message only. No user action isrequired.
2007-12-18 19:36:12.20 Server Detected 2 CPUs. This is an informational message; no user action is required.
2007-12-18 19:36:12.40 Server Using dynamic lock allocation. Initialallocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.This is an informational message only. No user action is required.
2007-12-18 19:36:12.42 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-12-18 19:36:12.43 spid4s Starting up database 'master'.
2007-12-18 19:36:12.50 spid4s Error: 9003, Severity: 20, State: 1.
2007-12-18 19:36:12.50 spid4s The log scan number (228:88:1) passed tolog scan in database 'master' is not valid. This error may indicatedata corruption or that the log file (.ldf) does not match the datafile (.mdf). If this error occurred during replication, re-create thepublication. Otherwise, restore from backup if the problem results in afailure during startup.
2007-12-18 19:36:12.50 spid4s Cannot recover the master database. SQLServer is unable to run. Restore master from a full backup, repair it,or rebuild it. For more information about how to rebuild the masterdatabase, see SQL Server Books Online.
I'm on it since this morning and i haven't been able to fix it , none of the web ressources helped me you're my last chance of sleeping tightly :'(
Thank you so much.
Amokrane CHENTIR
welcome to the forums,
after reading the logfile, i think the Master database is damaged , note that SQL server can't work wothout this database .
you need to re-install the Sqlserver , or repair the installation , go to add/remove programs from control panel ,
and repair the SQl server Express Installation.
|||
Thank you very much , i've just tried it and it worked :)
Friday, February 10, 2012
Can''t connect to a sql express on a workgroup pc
Hi Guys,
I'm trying to connect to a sql express on a workgroup PC through sql server 2005 standard edition remotely but i can't.
I have checked and make sure that tcp/ip and other protocals are allowed. There is no firewall on both PCs and the sql browser service is running as well.
Somehow i can connect using the IP address but not the name?
Any idea why?
TA
Gemma
post back the error
Madhu
|||
HI Madhu,
Here it is:
TITLE: Connect to Server
Cannot connect to TYPICAL1.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. 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: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
BUTTONS:
OK
Ta
Gemma
|||check this out
http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx
Madhu
Can't connect from ASP.Net 2.0 to SQL2000 after installing SQL2005
Hey guys,
I have a web application in ASP.Net 2.0 that needs to connect to a local
SQL2000 DB. After I installed SQL2005 this web app stopped working. I get
the following inner exception:
{"An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)"}
So after unsuccessfully googling I'm at least pretty sure about the
following: My web app thinks it's talking to a SQL2005 server. That one by
default uses shared memory when local. I think SQL2000 uses TCP/IP.
Who can tell me what I have to do so that my ASP.Net 2.0 web app properly
connects to SQL2000? Among the ideas on Google there were cliconfg.exe,
using <clear /> in the <connectionStrings> area in web.config and a couple
more. But none of them worked.
Thanks a lot, ChristophI'm having a very similar error, only mine connects locally but not remotely.
I was able to change the error slightly by putting the referencing the
database by domain and db, myMachine/myDB.
If it helps I looked at my log and it gave an error of 17187 which seems to
be a file in use, full disk, or low memory. Still researching. If I find it
I'll let you know. If you find the answer would you please post it so I can
try it too?
--
---
Magic is not in the hands of the magician but in the mind of the audience.
Animadverto est verus
"Christoph Wienands" wrote:
> Hey guys,
> I have a web application in ASP.Net 2.0 that needs to connect to a local
> SQL2000 DB. After I installed SQL2005 this web app stopped working. I get
> the following inner exception:
> {"An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified)"}
> So after unsuccessfully googling I'm at least pretty sure about the
> following: My web app thinks it's talking to a SQL2005 server. That one by
> default uses shared memory when local. I think SQL2000 uses TCP/IP.
> Who can tell me what I have to do so that my ASP.Net 2.0 web app properly
> connects to SQL2000? Among the ideas on Google there were cliconfg.exe,
> using <clear /> in the <connectionStrings> area in web.config and a couple
> more. But none of them worked.
> Thanks a lot, Christoph
>
>
I have a web application in ASP.Net 2.0 that needs to connect to a local
SQL2000 DB. After I installed SQL2005 this web app stopped working. I get
the following inner exception:
{"An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)"}
So after unsuccessfully googling I'm at least pretty sure about the
following: My web app thinks it's talking to a SQL2005 server. That one by
default uses shared memory when local. I think SQL2000 uses TCP/IP.
Who can tell me what I have to do so that my ASP.Net 2.0 web app properly
connects to SQL2000? Among the ideas on Google there were cliconfg.exe,
using <clear /> in the <connectionStrings> area in web.config and a couple
more. But none of them worked.
Thanks a lot, ChristophI'm having a very similar error, only mine connects locally but not remotely.
I was able to change the error slightly by putting the referencing the
database by domain and db, myMachine/myDB.
If it helps I looked at my log and it gave an error of 17187 which seems to
be a file in use, full disk, or low memory. Still researching. If I find it
I'll let you know. If you find the answer would you please post it so I can
try it too?
--
---
Magic is not in the hands of the magician but in the mind of the audience.
Animadverto est verus
"Christoph Wienands" wrote:
> Hey guys,
> I have a web application in ASP.Net 2.0 that needs to connect to a local
> SQL2000 DB. After I installed SQL2005 this web app stopped working. I get
> the following inner exception:
> {"An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified)"}
> So after unsuccessfully googling I'm at least pretty sure about the
> following: My web app thinks it's talking to a SQL2005 server. That one by
> default uses shared memory when local. I think SQL2000 uses TCP/IP.
> Who can tell me what I have to do so that my ASP.Net 2.0 web app properly
> connects to SQL2000? Among the ideas on Google there were cliconfg.exe,
> using <clear /> in the <connectionStrings> area in web.config and a couple
> more. But none of them worked.
> Thanks a lot, Christoph
>
>
Subscribe to:
Posts (Atom)