I can't debug SP in VS 2003
My config:
* Windows XP Pro
* VS.NET 2003
* SQL Server 2000 SP3a
* Breakpoints are not hit in stored procs either... they become question
marks when I run and the tooltip text says "The breakpoint will not
currently be hit. Unable to bind SQL breakpoint at this time. Object
containing the breakpoint not loaded."
I have followed ALL these instructions :
* I have granted myself EXEC permissions on sp_sdidebug -- GRANT EXEC
on master..sp_sdidebug to [MYDOMAIN\ME]
* I have run -- exec sp_sdidebug 'legacy on'
* Sqlle.dll and sqldbreg2.exe exist on your debugging workstation. The
former library is the SQL language engine for the debugger.
* Sqldbg.dll exists on both the database server and the debugging
work-station. This library is the SQL debugging proxy.
* Mssdi98.dll exists in the \binn subfolder of every SQL Server instance
on the database server.
* If you're running the full version of SQL Server
* My domain account has permission to the master database itself.
* I re- execute sp_sdidebug 'legacy on' every time I reboot SQL Server.
* I turned on SQL debugging for every project in my VS solution -
* Connection pooling is disabled.
Any help?i usually debug sp's using query analyzer. i right click the stored
procedure in the debug manager and chose debug. u can even pass paramaters
to it
"Oleg Bulay" wrote:
> I can't debug SP in VS 2003
> My config:
> * Windows XP Pro
> * VS.NET 2003
> * SQL Server 2000 SP3a
> * Breakpoints are not hit in stored procs either... they become question
> marks when I run and the tooltip text says "The breakpoint will not
> currently be hit. Unable to bind SQL breakpoint at this time. Object
> containing the breakpoint not loaded."
> I have followed ALL these instructions :
> * I have granted myself EXEC permissions on sp_sdidebug -- GRANT EXEC
> on master..sp_sdidebug to [MYDOMAIN\ME]
> * I have run -- exec sp_sdidebug 'legacy on'
> * Sqlle.dll and sqldbreg2.exe exist on your debugging workstation. The
> former library is the SQL language engine for the debugger.
> * Sqldbg.dll exists on both the database server and the debugging
> work-station. This library is the SQL debugging proxy.
> * Mssdi98.dll exists in the \binn subfolder of every SQL Server instance
> on the database server.
> * If you're running the full version of SQL Server
> * My domain account has permission to the master database itself.
> * I re- execute sp_sdidebug 'legacy on' every time I reboot SQL Server.
> * I turned on SQL debugging for every project in my VS solution -
> * Connection pooling is disabled.
> Any help?
>
>|||Check out this article...
http://support.microsoft.com/?kbid=839280
HTH
"Oleg Bulay" wrote:
> I can't debug SP in VS 2003
> My config:
> * Windows XP Pro
> * VS.NET 2003
> * SQL Server 2000 SP3a
> * Breakpoints are not hit in stored procs either... they become question
> marks when I run and the tooltip text says "The breakpoint will not
> currently be hit. Unable to bind SQL breakpoint at this time. Object
> containing the breakpoint not loaded."
> I have followed ALL these instructions :
> * I have granted myself EXEC permissions on sp_sdidebug -- GRANT EXEC
> on master..sp_sdidebug to [MYDOMAIN\ME]
> * I have run -- exec sp_sdidebug 'legacy on'
> * Sqlle.dll and sqldbreg2.exe exist on your debugging workstation. The
> former library is the SQL language engine for the debugger.
> * Sqldbg.dll exists on both the database server and the debugging
> work-station. This library is the SQL debugging proxy.
> * Mssdi98.dll exists in the \binn subfolder of every SQL Server instance
> on the database server.
> * If you're running the full version of SQL Server
> * My domain account has permission to the master database itself.
> * I re- execute sp_sdidebug 'legacy on' every time I reboot SQL Server.
> * I turned on SQL debugging for every project in my VS solution -
> * Connection pooling is disabled.
> Any help?
>
>
Showing posts with label sp3a. Show all posts
Showing posts with label sp3a. Show all posts
Thursday, March 8, 2012
Can't debug SP from Query Analizer with SP3a
Hi,
I am able to debug them correctly from VS.NET 2003, but trying from Query
Analizer gives me this error:
Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on
object 'sp_sdidebug', database 'master', owner 'dbo'.
Any ideas?
Thanks in advance,
Juan Dent, M.Sc.
The first thing to do is to make sure that the account you are using can
execute the stored procedure indicated in the error message:
GRANT EXECUTE ON sp_sdidebug TO <your user account goes here>
Keith
"Juan Dent" <juan5@.dev.com> wrote in message
news:058F454E-48E0-4194-BBA2-21A953BF2B53@.microsoft.com...
> Hi,
> I am able to debug them correctly from VS.NET 2003, but trying from Query
> Analizer gives me this error:
> Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied
on
> object 'sp_sdidebug', database 'master', owner 'dbo'.
> Any ideas?
> --
> Thanks in advance,
> Juan Dent, M.Sc.
|||Yes I have done this, to no avail.
"Keith Kratochvil" wrote:
> The first thing to do is to make sure that the account you are using can
> execute the stored procedure indicated in the error message:
> GRANT EXECUTE ON sp_sdidebug TO <your user account goes here>
> --
> Keith
>
> "Juan Dent" <juan5@.dev.com> wrote in message
> news:058F454E-48E0-4194-BBA2-21A953BF2B53@.microsoft.com...
> on
>
I am able to debug them correctly from VS.NET 2003, but trying from Query
Analizer gives me this error:
Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on
object 'sp_sdidebug', database 'master', owner 'dbo'.
Any ideas?
Thanks in advance,
Juan Dent, M.Sc.
The first thing to do is to make sure that the account you are using can
execute the stored procedure indicated in the error message:
GRANT EXECUTE ON sp_sdidebug TO <your user account goes here>
Keith
"Juan Dent" <juan5@.dev.com> wrote in message
news:058F454E-48E0-4194-BBA2-21A953BF2B53@.microsoft.com...
> Hi,
> I am able to debug them correctly from VS.NET 2003, but trying from Query
> Analizer gives me this error:
> Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied
on
> object 'sp_sdidebug', database 'master', owner 'dbo'.
> Any ideas?
> --
> Thanks in advance,
> Juan Dent, M.Sc.
|||Yes I have done this, to no avail.
"Keith Kratochvil" wrote:
> The first thing to do is to make sure that the account you are using can
> execute the stored procedure indicated in the error message:
> GRANT EXECUTE ON sp_sdidebug TO <your user account goes here>
> --
> Keith
>
> "Juan Dent" <juan5@.dev.com> wrote in message
> news:058F454E-48E0-4194-BBA2-21A953BF2B53@.microsoft.com...
> on
>
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
>
cant connect to Sql server 2000 sp3a in windows 2003 server
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...
> 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[vbcol=seagreen]
>
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...
> 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[vbcol=seagreen]
>
Sunday, February 12, 2012
Can't connect to full MSDE 2000 (urgent)
I think I've "filled" an MSDE 2000 SP3a database to its maximum 2GB size, and now can't connect to it.
OSQL gets an "insufficient file size" error.
Have also tried to connect via Ent Mngr, and get database is "suspect" error.
How can I connect in order to purge some data?
Thanks!!!!
DT
When connecting using Enterprise Manager, which database is the suspect? Search for the database file in your file system (databasename_.MDF) and check whether you do have enough free space in the disk containing the MDF file. If not, try freeing up some space on that disk just for you to do maintenance. Then you can do a couple of things - truncate the log and shrink the file, move the database file to a different drive, extend the volume by adding disk, or free up some space by deleting large files on the disk.|||We know which database, and there's plenty of room on the disk.
The problem isn't that we don't know how to make the database smaller... it's that we can no longer connect to it in order to truncate/shrink.
Can you recommend a recovery tool?
DT
|||I was able to attach the database to a SQL2K instance, and do a backup.
Problem resolved
Subscribe to:
Posts (Atom)