connecting to SSAS: running

Showing posts with label running. Show all posts

Friday, March 30, 2012

Problem in installing SQLSERVER2000 Developer Edition

Dear friends,
I tried to install my SQLServer2000 Developer
Edition in my server machine, which is running on the OS
Windows Server 2000.
I am getting the following errors
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
SQL Server configuration failed.
What is the problem?
Also, i herewith attached the error log file.
Kindly give me the solution and it is very urgent.
with regards,
T.Thirumalairajan B.E
begin 666 sqlstp.log
M,3@.Z,#0Z-# @.0F5G:6X@.4V5T=7 -"C$X.C T.C0P(#@.N,# N,3DT#0HQ.#HP
M-#HT,"!-;V1E(#T@.3F]R;6%L#0HQ.#HP-#HT,"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,3@.Z,#0Z-# @.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'AF,# P,# -"C$X.C T.C0P(%9A;'5E1E13(')E='5R;F5D.B Q
M#0HQ.#HP-#HT,"!686QU95!)1"!R971U<FYE9#H@.,0T*,3@.Z,#0Z-# @.5F%L
M=65,:6,@.<F5T=7)N960Z(# -"C$X.C T.C0P(%-Y<W1E;3H@.5VEN9&]W<R!.
M5"!497)M:6YA;"!397)V97(-"C$X.C T.C0P(%-13"!397)V97(@.4')O9'5C
M=%1Y<&4Z($1E=F5L;W!E<B!%9&ET:6]N(%LP>#-=#0HQ.#HP-#HT,"!"96=I
M;B!!8W1I;VXZ(%-E='5P26YI=&EA;&EZ92 -"C$X.C T.C0P($5N9"!!8W1I
M;VX@.4V5T=7!);FET:6%L:7IE#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3
M971U<$EN<W1A;&P-"C$X.C T.C0P(%)E861I;F<@.4V]F='=A<F5<36EC<F]S
M;V9T7%=I;F1O=W-<0W5R<F5N=%9E<G-I;VY<0V]M;6]N1FEL97-$:7(@.+BXN
M#0HQ.#HP-#HT,"!#;VUM;VY&:6QE<T1I<CU#.EQ0<F]G<F%M($9I;&5S7$-O
M;6UO;B!&:6QE<PT*,3@.Z,#0Z-# @.5VEN9&]W<R!$:7)E8W1O<GD]0SI<5TE.
M3E1<#0HQ.#HP-#HT,"!0<F]G<F%M($9I;&5S/4,Z7%!R;V=R86T@.1FEL97-<
M#0HQ.#HP-#HT,"!414U01$E2/4,Z7$1/0U5-17XQ7$%$34E.27XQ7$Q/0T%,
M4WXQ7%1E;7!<#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3971U<$EN<W1A
M;&P-"C$X.C T.C0P(&1I9W!I9"!S:7IE(#H@.,C4V#0HQ.#HP-#HT,"!D:6=P
M:60@.<VEZ92 Z(#$V- T*,3@.Z,#0Z-# @.0F5G:6X@.06-T:6]N.B @.0VAE8VM&
M:7AE9%)E<75I<F5M96YT<PT*,3@.Z,#0Z-# @.4&QA=&9O<FT@.240Z(#!X9C P
M#0HQ.#HP-#HT,"!697)S:6]N.B U+C N,C$Y-0T*,3@.Z,#0Z-# @.1FEL92!6
M97)S:6]N("T@.0SI<5TE.3E1<<WES=&5M,S)<<VAD;V-V=RYD;&PZ(#4N,"XS
M-3(V+C@.P, T*,3@.Z,#0Z-# @.16YD($%C=&EO;CH@.($-H96-K1FEX961297%U
M:7)E;65N=',-"C$X.C T.C0P($)E9VEN($%C=&EO;CH@.(%-H;W=$:6%L;V=S
M#0HQ.#HP-#HT,"!);FET:6%L($1I86QO9R!-87-K.B P>#@.S,# P9C<L($1I
M<V%B;&4@.0F%C:STP>#$-"C$X.C T.C0Q($)E9VEN($%C=&EO;B!3:&]W1&EA
M;&]G<TAL<'(Z(#!X,0T*,3@.Z,#0Z-#$@.0F5G:6X@.06-T:6]N.B @.1&EA;&]G
M4VAO=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.16YD($%C=&EO;B @.1&EA;&]G4VAO
M=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.1&EA;&]G(#!X,2!R971U<FYE9#H@.,0T*
M,3@.Z,#0Z-#(@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C T.C0R
M(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#(L
M:6YD97@.],0T*,3@.Z,#0Z-#(@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP
M<CH@.,'@.R#0HQ.#HP-#HT,B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1-
M86-H:6YE3F%M90T*,3@.Z,#0Z-#0@.4VAO=T1L9TUA8VAI;F4@.<F5T=7)N960Z
M(#$-"C$X.C T.C0T($YA;64@./2!#4U!,+"!4>7!E(#T@.,'@.Q#0HQ.#HP-#HT
M-"!"96=I;B!!8W1I;VXZ("!#:&5C:U)E<75I<F5M96YT<PT*,3@. Z,#0Z-#0@.
M4')O8V5S<V]R($%R8VAI=&5C='5R93H@.>#@.V("A096YT:75M*0T*,3@.Z,#0Z
M-#0@.4V5R=FEC92!086-K.B @.-S8X#0HQ.#HP-#HT-"!#;VUP=71E<DYA;64Z
M($-34$P-"C$X.C T.C0T(%5S97(@.3F%M93H@.061M:6YI<W1R871O<@.T*,3@.Z
M,#0Z-#0@.27-!;&Q!8V-E<W-!;&QO=V5D(')E='5R;F5D.B Q#0HQ.#HP-#HT
M-"!/4R!,86YG=6%G93H@.,'@.T,#D-"C$X.C T.C0T($5N9"!!8W1I;VX@.0VAE
M8VM297%U:7)E;65N=',-"C$X.C T.C0T($-R96%T95-E='5P5&]P;VQO9WDH
M0U-03"DL($AA;F1L92 Z(#!X,3@.Y-#$T,"P@.<F5T=7)N960@..B P#0HQ.#HP
M-#HT-"!#<F5A=&53971U<%1O<&]L;V=Y(')E='5R;F5D(#H@.,"P@.2&%N9&QE
M(#H@.,'@.Q.#DT,30P#0HQ.#HP-#HT-"!4;W!O;&]G>2!4>7!E(#H@.,2P@.4F5T
M=7)N(%9A;'5E(#H@., T*,3@.Z,#0Z-#0@.4U1?1V5T4&AY<VEC86Q.;V1E(')E
M='5R;F5D(#H@.,"P@.4$Y(86YD;&4@..B P>#$X.30Q-C@.-"C$X.C T.C0T(%!.
M7T5N=6UE<F%T945X(')E='5R;F5D(#H@., T*,3@.Z,#0Z-#0@.4$Y?1V5T4U%,
M4W1A=&5S(')E='5R;F5D(#H@.,"P@.4W%L4W1A=&5S(#H@.,'@.R, C<-"C$X.C T
M.C0T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z(# -"C$X
M.C T.C0T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,3@.Z,#0Z-#0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$X.C T.C0T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ.#HP
M-#HT-"!.86UE9"!I;G-T86YC92!L:6UI=#H@.,3 P+"!Q=6]T83H@., T*,3@.Z
M,#0Z-#0@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$X
M.C T.C0T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#0Z-#0@.
M;D9U;&Q-87-K(#T@.,'@.X,S P,&8W+"!N0W5R<F5N=" ](#!X,BP@.;D1I<F5C
M=&EO;B ](# -"C$X.C T.C0T(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X8F8P
M,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-#HT-"!$:6%L;V<@.,'@.R
M(')E='5R;F5D.B P#0HQ.#HP-#HT-"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,3@.Z,#0Z-#0@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X-"QI;F1E>#TR#0HQ.#HP-#HT-"!"96=I;B!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R.B P>#0-"C$X.C T.C0T($)E9VEN($%C=&EO;CH@.
M($1I86QO9U-H;W=39$EN<W1A;&Q-;V1E#0HQ.#HP-#HU-2!3:&]W1&QG26YS
M=&%L;$UO9&4@.<F5T=7)N960Z(#$-"C$X.C T.C4U($EN<W1A;&Q-;V1E(#H@.
M,'@.Q#0HQ.#HP-#HU-2!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86QL
M36]D90T*,3@.Z,#0Z-34@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-#HU-2!N1G5L;$UA<VL@./2 P>&)F,# P,S<L(&Y#=7)R96YT(#T@.,'@.T
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#0Z-34@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9C0P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C T.C4U($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$X.C T.C4U($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ.#HP-#HU-2!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z,#0Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z
M,#0Z-38@.1&EA;&]G(#!X,3 @.<F5T=7)N960Z(#$-"C$X.C T.C4V($5N9"!!
M8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ.#HP-#HU-B!3:&]W1&EA;&]G<T=E
M=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.R,"QI;F1E>#TU#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#(P#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ.#HP
M-#HU.2!%;F0@.06-T:6]N($1I86QO9U-H;W=39$QI8V5N<V4-"C$X.C T.C4Y
M($1I86QO9R P>#(P(')E='5R;F5D.B Q#0HQ.#HP-#HU.2!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#0Z-3D@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X-# P,# L:6YD97@.],3@.-"C$X.C T
M.C4Y($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$X
M.C T.C4Y($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,3@.Z
M,#0Z-3D@.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,3@.Z,#4Z,#,@.4VAO=T1L9T-L
M:65N=%-E<G9E<E-E;&5C="!R971U<FYE9#H@.,0T*,3@.Z,#4Z,#,@.5'EP92 Z
M(#!X,@.T*,3@.Z,#4Z,#,@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R
M#0HQ.#HP-3HP,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$X.C U
M.C S(&Y&=6QL36%S:R ](#!X8F8T,# S-RP@.;D-U<G)E;G0@./2 P>#0P,# P
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#4Z,#,@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9F,P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C U.C S($1I
M86QO9R P>#0P,# P(')E='5R;F5D.B Q#0HQ.#HP-3HP,R!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#4Z,#,@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# L:6YD97@.],3D-"C$X.C U
M.C S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X.# P,# -"C$X
M.C U.C S($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$EN<W1A;F-E3F%M
M90T*,3@.Z,#4Z,#,@.0F5G:6X@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE
M#0HQ.#HP-3HP."!%;F0@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE#0HQ
M.#HP-3HP."!3:&]W1&QG26YS=&%N8V5.86UE(')E='5R;F5D(#H@.,0T*,3@.Z
M,#4Z,#@.@.26YS=&%N8V5.86UE(#H@.0U-03#)+#0HQ.#HP-3HP."!%;F0@.06-T
M:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$X.C U.C X(&)E9VEN
M(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z,#@.@.;D9U;&Q-87-K(#T@.
M,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X.# P,# L(&Y$:7)E8W1I;VX@./2 Q
M#0HQ.#HP-3HP."!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F8S P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z,#@.@.1&EA;&]G(#!X.# P,# @.<F5T
M=7)N960Z(#$-"C$X.C U.C X($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ.#HP-3HP."!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.Q,# P,# L:6YD97@.],C -"C$X.C U.C X($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P#0HQ.#HP-3HP."!"96=I;B!!
M8W1I;VXZ("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U.C X($)E9VEN
M($%C=&EO;CH@.4V5T=7 @.5'EP90T*,3@.Z,#4Z-3(@.4U%,('!R;V=R86T@.9F]L
M9&5R.B!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ
M.#HP-3HU,B!344P@.9&%T82!F;VQD97(Z($0Z7%!R;V=R86T@.1FEL97-<36EC
M<F]S;V9T(%-13"!397)V97(-"C$X.C U.C4R(%=I;F1O=W,@.<WES=&5M(&9O
M;&1E<CH@.0SI<5TE.3E1<<WES=&5M,S)<#0HQ.#HP-3HU,B!0<F]G(')E<3H@.
M,S0W.#DL($1A=&$@.<F5Q.B S-#0S,BP@.4WES(')E<3H@.,3,R,38X#0HQ.#HP
M-3HU,B!0<F]G(&%V86EL.B Q-30S.3$R+"!$871A(&%V86EL.B Q-30S.3$R
M+"!3>7,@.879A:6PZ(#4U,C<S,S8-"C$X.C U.C4R(%!R;V<@.<F5Q('9S+B!A
M=F%I;"P@.-CDR,C$L(#$U-#,Y,3(-"C$X.C U.C4R($1A=&$@.<F5Q('9S+B!A
M=F%I;"P@.,S0T,S(L(#$U-#,Y,3(-"C$X.C U.C4R(%-Y<R!R97$@.=G,N(&%V
M86EL+" Q,S(Q-C@.L(#4U,C<S,S8-"C$X.C U.C4R($1I<W!L87E3>7-T96U0
M<F5297$-"C$X.C U.C4R(%M3971U<%1Y<&5344Q=#0HQ.#HP-3HU,B!S>D1I
M<B ]($0Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$X
M.C U.C4R('-Z1&ER(#T@.1#I<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,
M(%-E<G9E<@.T*,3@.Z,#4Z-3(@.4F5S=6QT(#T@.,S Q#0HQ.#HP-3HU,B!S>D1A
M=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R
M#0HQ.#HP-3HU,B!S>D1A=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R#0HQ.#HP-3HU,B!%;F0@.06-T:6]N.B!3971U<"!4
M>7!E#0HQ.#HP-3HU,B!3971U<"!4>7!E.B!4>7!I8V%L("@.S,#$I#0HQ.#HP
M-3HU,B!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U
M.C4R(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z-3(@.;D9U
M;&Q-87-K(#T@.,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER
M96-T:6]N(#T@.,S Q#0HQ.#HP-3HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P
M>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z-3,@.1&EA;&]G
M(#!X,3 P,# P(')E='5R;F5D.B S,#$-"C$X.C U.C4S($5N9"!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R#0HQ.#HP-3HU,R!3:&]W1&EA;&]G<T=E=$1I86QO
M9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.T,# P,# L:6YD97@.],C(-"C$X.C U
M.C4S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# P#0HQ
M.#HP-3HU,R!"96=I;B!!8W1I;VXZ("!$;&=397)V:6-E<PT*,3@.Z,#8Z,#$@.
M4VAO=T1L9U-E<G9I8V5S(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!;1&QG4V5R
M=FEC97-=#0HQ.#HP-CHP,2!,;V-A;"U$;VUA:6X)/2 V,38X, T*,3@.Z,#8Z
M,#$@.075T;U-T87)T"0D](#$U#0HQ.#HP-CHP,2!344Q$;VUA:6X)"3T@.0TA%
M3%-/1E0-"C$X.C V.C Q(%-13$1O;6%I;D%C8W0)/2!!9&UI;FES=')A=&]R
M#0HQ.#HP-CHP,2!344Q$;VUA:6Y0=V0-"C$X.C V.C Q($%G=$1O;6%I;@.D)
M/2!#2$5,4T]&5 T*,3@.Z,#8Z,#$@.06=T1&]M86EN06-C= D]($%D;6EN:7-T
M<F%T;W(-"C$X.C V.C Q($%G=$1O;6%I;E!W9 T*,3@.Z,#8Z,#$@.4F5S=6QT
M"3T@.,0T*,3@.Z,#8Z,#$@.16YD($%C=&EO;B!$;&=397)V:6 -E<PT*,3@.Z,#8Z
M,#$@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ.#HP-CHP,2!N1G5L
M;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ.#HP-CHP,2!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D
M8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,#$@.1&EA;&]G(#!X
M-# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!%;F0@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<@.T*,3@.Z,#8Z,#$@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T
M=7)N960Z(&Y#=7)R96YT/3!X.# P,# P+&EN9&5X/3(S#0HQ.#HP-CHP,2!"
M96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#@.P,# P, T*,3@.Z,#8Z
M,#$@.0F5G:6X@.06-T:6]N.B @.1&QG4U%,4V5C=7)I='D-"C$X.C V.C,S(%-H
M;W=$;&=344Q396-U<FET>2!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S,@.3&]G:6Y-
M;V1E(#T@.,BQS>E!W9 T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!$;&=344Q396-U
M<FET>0T*,3@.Z,#8Z,S,@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-CHS,R!N1G5L;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS,R!5<&1A=&5D($1I86QO
M9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z
M,S,@.1&EA;&]G(#!X.# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR
M- T*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-
M"C$X.C V.C,S(%-H;W=$;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$X.C V
M.C,S(&-O;&QA=&EO;E]N86UE(#T@.4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#
M25]!4RQL;V-A;&5?;F%M92 ]($QA=&EN,5]'96YE<F%L+&QC:60@./2 P>#0P
M.2Q3;W)T260@./2 U,BQD=T-O;7!&;&%G<R ](#!X,S P,#$-"C$X.C V.C,S
M($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ.#HP-CHS,R!B96=I;B!3:&]W
M1&EA;&]G<U5P9&%T94UA<VL-"C$X.C V.C,S(&Y&=6QL36%S:R ](#!X8F1C
M,# S-RP@.;D-U<G)E;G0@./2 P>#$P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M.#HP-CHS,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B
M;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,S,@.1&EA;&]G(#!X,3 P,# P,"!R971U
M<FYE9#H@.,0T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$X.C V.C,S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#(P,# P,# L:6YD97@.],C4-"C$X.C V.C,S($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# P, T*,3@.Z,#8Z,S,@.0F5G:6X@.
M06-T:6]N.B @.1&QG3F5T=V]R:PT*,3@.Z,#8Z,S,@.4VAO=T1L9TYE='=O<FL@.
M<F5T=7)N960Z(#$-"C$X.C V.C,S(%M$;&=397)V97).971W;W)K70T*,3@.Z
M,#8Z,S,@.3F5T=V]R:TQI8G,@./2 R-34-"C$X.C V.C,S(%1#4%!O<G0@./2 P
M#0HQ.#HP-CHS,R!40U!0<GAY(#T@.1&5F875L= T*,3@.Z,#8Z,S,@.3DU04&EP
M94YA;64@./2!<7"Y<<&EP95Q-4U-13"1#4U!,,DM<<W%L7'%U97)Y#0HQ.#HP
M-CHS,R!297-U;'0@./2 Q#0HQ.#HP-CHS,R!%;F0@.06-T:6]N($1L9TYE='=O
M<FL-"C$X.C V.C,S(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z
M,#8Z,S,@.;D9U;&Q-87-K(#T@.,'AB9&,P,#,W+"!N0W5R<F5N=" ](#!X,C P
M,# P,"P@.;D1I<F5C=&EO;B ](#$-"C$X.C V.C,S(%5P9&%T960@.1&EA;&]G
M($UA<VLZ(#!X8F1C,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-CHS
M,R!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P,"QI;F1E>#TR
M-PT*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V13
M=&%R=$-O<'D-"C$X.C V.C,T($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D4W1A
M<G1#;W!Y#0HQ.#HP-CHS-"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-
M"C$X.C V.C,T(&Y&=6QL36%S:R ](#!X8F1C,# S-RP@.;D-U<G)E;G0@./2 P
M>#@.P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS-"!5<&1A=&5D($1I
M86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z
M,#8Z,S0@.1&EA;&]G(#!X.# P,# P,"!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S0@.
M16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C V.C,T(%-H;W=$:6%L
M;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP># L:6YD97@.], T*
M,3@.Z,#8Z,S0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<PT*,3@.Z,#8Z,S0@.0F5G
M:6X@.06-T:6]N(%!R;V-E<W-"969O<F5$871A36]V93H-"C$X.C V.C,T($1E
M:6YS=&%L;%-T87)T(')E='5R;F5D("A$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R7$U34U%,)$-34$PR2RDZ(# -"C$X.C V.C,T($5N
M9"!!8W1I;VX@.("!0<F]C97-S0F5F;W)E1&%T84UO=F4Z#0HQ.#HP-CHS-"!"
M96=I;B!!8W1I;VX@.4V5T5&]O;'-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP
M-CHS-"!#<F5A=&53971U<%1O<&]L;V=Y*$-34$PI+"!(86YD;&4@..B P>#$X
M.30Q-# L(')E='5R;F5D(#H@., T*,3@.Z,#8Z,S0@.0W)E871E4V5T=7!4;W!O
M;&]G>2!R971U<FYE9" Z(# L($AA;F1L92 Z(#!X,3@.Y-#$T, T*,3@.Z,#8Z
M,S0@.5&]P;VQO9WD@.5'EP92 Z(#$L(%)E='5R;B!686QU92 Z(# -"C$X.C V
M.C,T(%-47T=E=%!H>7-I8V%L3F]D92!R971U<FYE9" Z(# L(%!.2&%N9&QE
M(#H@.,'@.Q.#DT,38X#0HQ.#HP-CHS-"!03E]%;G5M97)A=&5%>"!R971U<FYE
M9" Z(# -"C$X.C V.C,T(%!.7T=E=%-13%-T871E<R!R971U<FYE9" Z(# L
M(%-Q;%-T871E<R Z(#!X,C(W#0HQ.#HP-CHS-"!03E]3=&%R=%-C86X@.6S!X
M,3@.Y-#$V.%T@.<F5T=7)N960@..B P#0HQ.#HP-CHS-"!03E]'971.97AT(%LP
M>#$X.30Q-CA=(')E='5R;F5D(#H@.,"P@.2&%N9&QE.B!;,'@.Q.#DU,#@.P70T *
M,3@.Z,#8Z,S0@.4U%,25]'9714>7!E(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.
M,"P@.;E1Y<&4Z(#!X,PT*,3@.Z,#8Z,S0@.4U%,25]'971);G-T86QL4&%T:"!;
M,'@.Q.#DU,#@.P72!R971U<FYE9" Z(# L(%!A=&@.@./2!$.EQ0<F]G<F%M($9I
M;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971$871A4&%T:"!;,'@.Q.#DU
M,#@.P72!R971U<FYE9" Z(# L($1A=&%0871H(#T@.1#I<4')O9W)A;2!&:6QE
M<UQ-4U-13#<-"C$X.C V.C,T(%-13$E?1V5T5F5R<VEO;B!;,'@.Q.#DU,#@.P
M72!R971U<FYE9" Z(# L(%9E<G-I;VX@./2 W+C P+C8R,PT*,3@.Z,#8Z,S0@.
M4U%,25]'971296=+97E2;V]T(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.,"P@.
M4F5G2V5Y4F]O=" ](%-O9G1W87)E7$UI8W)O<V]F=%Q-4U-13%-E<G9E<@.T*
M,3@.Z,#8Z,S0@.5&]O;',@.4&%T:#H@.(" @.($0Z7%!R;V=R86T@.1FEL97-<35-3
M44PW#0HQ.#HP-CHS-"!4;V]L<R!697)S:6]N.B @.-RXP,"XV,C,-"C$X.C V
M.C,T(%1O;VQS(%)E9VES=')Y.B!3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q3
M97)V97(-"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N
M960@..B Q."P@.2&%N9&QE.B!;,'@.P70T*,3@.Z,#8Z,S0@.1F]R8V4@.4'5R9V4-
M"C$X.C V.C,T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z
M(# -"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@.
M.B P+"!(86YD;&4Z(%LP>#$X.30V9CA=#0HQ.#HP-CHS-"!344Q)7T=E=$EN
M<W1A;&Q0871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.4 &%T:" ]($0Z
M7%!R;V=R86T@.1FEL97-<35-344PW#0HQ.#HP-CHS-"!344Q)7T=E=$1A=&%0
M871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.1&%T85!A= &@.@./2!$.EQ0
M<F]G<F%M($9I;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971697)S:6]N
M(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.5F5R<VEO;B ](#<N,# N-C(S
M#0HQ.#HP-CHS-"!344Q)7T=E=%)E9TME>5)O;W0@.6S!X,3@.Y-#9F.%T@.<F5T
M=7)N960@..B P+"!296=+97E2;V]T(#T@.4V]F='=A<F5<36EC<F]S;V9T7$U3
M4U%,4V5R=F5R#0HQ.#HP-CHS-"!03E]'971.97AT(%LP>#$X.30Q-CA=(')E
M='5R;F5D(#H@.,3@.L($AA;F1L93H@.6S!X,%T-"C$X.C V.C,T(%)E;&5A<V53
M971U<%1O<&]L;V=Y#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%-E=%1O;VQS0V]M
M<&]N96YT4V5L96-T:6]N.@.T*,3@.Z,#8Z,S0@.0F5G:6X@.06-T:6]N(%!R;V-E
M<W-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%!R
M;V-E<W-#;VUP;VYE;G1396QE8W1I;VX-"C$X.C V.C,T($)E9VEN($%C=&EO
M;B!,;V=396QE8W1E9$-O;7!O;F5N=',Z#0HQ.#HP-CHS-"!344Q0<F]G#0HQ
M.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R#0HQ.#HP-CHS-"!344Q0<F]G7%-1
M3%-E<G9R7$AE;' -"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<4T--1&5V
M#0HQ.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TUH#0HQ.#HP
M-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TU8.#9,8@.T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ344Q397)V<EQ30TU$979<4T--04QB#0HQ.#HP-CHS-"!3
M44Q0<F]G7%-13%-E<G9R7%)S,3 S,PT*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q3
M97)V<EQ2<TEN=&P-"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<06-T:79E
M6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q397)V<EQ3>7-T96T-"C$X.C V.C,T
M(%-13%!R;V=<4F5P;%-U<' -"C$X.C V.C,T(%-13%!R;V=<4F5P;%-U<'!<
M4F5P;$1A= T*,3@.Z,#8Z,S0@.4U%,4')O9UQ297!L4W5P<%Q297!#;VUM#0HQ
M.#HP-CHS-"!344Q0<F]G7%)E<&Q3=7!P7%)E<$YO1&L-"C$X.C V.C,T(%-1
M3%!R;V=<4F5P;%-U<'!<06-T:79E6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ);G-T
M86QL#0HQ.#HP-CHS-"!344Q0<F]G7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O
M9UQ3=G)%>'0-"C$X.C V.C,T(%-13%!R;V=<4W9R17AT7$AE;' -"C$X.C V
M.C,T(%-13%!R;V=<4W9R17AT7%-V<D5X=%)S#0HQ.#HP-CHS-"!344Q0<F]G
M7%-V<D5X=%Q297-);G1L#0HQ.#HP-CHS-"!344Q0<F]G7$1A= T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ$8713;7!L#0HQ.#HP-CHS-"!344Q0<F]G7$)A<V53>7,-
M"C$X.C V.C,T(%-13%!R;V=<0F%S94)I;FX-"C$X.C V.C,T(%-13%!R;V=<
M35-396%R8V@.-"C$X.C V.C,T(%-13%!R;V=<35-396%R8VA<2&5L< T*,3@.Z
M,#8Z,S0@.4U%,4')O9UQ-4U-E87)C:%Q!8W1I=F58#0HQ.#HP-CHS-"!344Q0
M<F]G7$)A<V5);G-T#0HQ.#HP-CHS-"!344Q0<F]G7%-Y;6)O;',-"C$X.C V
M.C,T(%-13%!R;V=<4WEM8F]L<UQ%6$4-"C$X.C V.C,T(%-13%!R;V=<4WEM
M8F]L<UQ$3$P-"C$X.C V.C,T(%-13%!R;V=<4&5R9FUO;@.T*,3@.Z,#8Z,S0@.
M4U%,4')O9UQ097)F;6]N7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O9UQ2;V]T
M#0HQ.#HP-CHS-"!-9W14;V]L#0HQ.#HP-CHS-"!-9W14;V]L7%-%30T*,3@.Z
M,#8Z,S0@.36=T5&]O;%Q314U<2%1-3 T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3@.-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4UE3#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q-4T0Y.%)E<PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3A(;' -"C$X.C V.C,T($UG=%1O;VQ<4T5-7$AE;' -"C$X.C V.C,T
M($UG=%1O;VQ<4T5-7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7%)E
M<TEN=&P-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4G-)#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q!8W1I=F58#0HQ.#HP-CHS-"!-9W14;V]L7%-%35Q!
M8W1I=F587%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$%C=&EV95A<
M4F5S26YT; T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<4V-R:7!T<PT*,3@.Z,#8Z
M,S0@.36=T5&]O;%Q314U<3TQ%1$(-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],
M141"7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],141"7%)E<TEN
M=&P-"C$X.C V.C,T($UG=%1O;VQ<4')O9FEL97(-"C$X.C V.C,T($UG=%1O
M;VQ<4')O9FEL97)<2&5L< T*,3@.Z,#8Z,S0@.36=T5&]O;%Q0<F]F:6QE<EQ2
M97,Q,#,S#0HQ.#HP-CHS-"!-9W14;V]L7%!R;V9I;&5R7%)E<TEN=&P-"C$X
M.C V.C,T($UG=%1O;VQ<47)Y86YL>@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q1<GEA
M;FQZ7$AE;' -"C$X.C V.C,T($UG=%1O;VQ<47)Y86YL>EQ297,Q,#,S#0HQ
M.#HP-CHS-"!-9W14;V]L7%%R>6%N;'I<4F5S26YT; T*,3@.Z,#8Z,S0@.36=T
M5&]O;%Q$5$-#3&D-"C$X.C V.C,T($UG=%1O;VQ<5WIC;F9L8W0-"C$X.C V
M.C,T($UG=%1O;VQ<5WIC;F9L8W1<5WIC;DAL< T*,3@.Z,#8Z,S0@.36=T5&]O
M;%Q7>F-N9FQC=%Q7>F-N,3 S,PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC
M=%Q7>F-N3W1H<@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC=%Q7>F-N0VUN
M#0HQ.#HP-CHS-"!-9W14;V]L7%5T:6Q3>7,-"C$X.C V.C,T($UG=%1O;VQ<
M571I;$)I;FX-"C$X.C V.C,T($-O;FYE8W0-"C$X.C V.C,T($-O;FYE8W1<
M0V]N;E-Y<PT*,3@.Z,#8Z,S0@.0F]O:W,-"C$X.C V.C,T($)O;VMS7$)O;VMS
M;PT*,3@.Z,#8Z,S0@.0F]O:W-<0F]O:W-O7%5T:6QS#0HQ.#HP-CHS-"!$9794
M;V]L<PT*,3@.Z,#8Z,S0@.1&5V5&]O;'-<1&)G($EN= T*,3@.Z,#8Z,S0@.1&5V
M5&]O;'-<1&)G($EN=%Q$8F<@.26YT($-O;6UO;@.T*,3@.Z,#8Z,S0@.1&5V5&]O
M;'-<1&)G($EN=%Q%6$4-"C$X.C V.C,T($-O<F5297!L#0HQ.#HP-CHS-"!#
M;W)E4F5P;%Q297,Q,#,S#0HQ.#HP-CHS-"!#;W)E4F5P;%Q297-);G1L#0HQ
M.#HP-CHS-"!#;W)E#0HQ.#HP-CHS-"!#;W)E7%)E<S$P,S,-"C$X.C V.C,T
M($-O<F5<4F5S3W1H97(-"C$X.C V.C,T(%)E<&]S=')Y#0HQ.#HP-CHS-"!2
M97!O<W1R>5Q297!S=%-Y<PT*,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R94UI<V,-
M"C$X.C V.C,T($-O<F5-:7-C7$%C=&EV95@.-"C$X.C V.C,T($-O<F5-:7-C
M7$%C=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.0V]R94UI<V-<06-T:79E6%Q2
M97-);G1L#0HQ.#HP-CHS-"!#;W)E36ES8UQ297,Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H#0HQ.#HP-CHS-"!-;VYA<F-H7$UO;G(Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H7$UO;G));G1L#0HQ.#HP-CHS-"!*970-"C$X.C V.C,T($-O<F5)
M;G-T#0HQ.#HP-CHS-"!#;W)E0T]-#0HQ.#HP-CHS-"!#;W)E0T]-7%)E<S$P
M,S,-"C$X.C V.C,T($-O<F5#3TU<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R951O
M;VP-"C$X.C V.C,T($-O<F54;V]L7%)E<S$P,S,-"C$X.C V.C,T($-O<F54
M;V]L7%)E<T]T:&5R#0HQ.#HP-CHS-"!$0DQI8D-L:0T*,3@.Z,#8Z,S0@.4T9%
M>'0-"C$X.C V.C,T(%-&17AT7$%C=&EV95@.-"C$X.C V.C,T(%-&17AT7$%C
M=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.4T9%>'1<06-T:79E6%Q297-);G1L
M#0HQ.#HP-CHS-"!31D5X=%Q297,Q,#,S#0HQ.#HP-CHS-"!31D5X=%Q297-)
M;G1L#0HQ.#HP-CHS-"!4<F%C90T*,3@.Z,#8Z,S0@.5')A8V5<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.5')A8V5<4F5S3W1H97(-"C$X.C V.C,T($UI<V-#;W)E#0HQ
M.#HP-CHS-"!-0PT*,3@.Z,#8Z,S0@.34-<34,Q,#,S#0HQ.#HP-CHS-"!-0UQ-
M0TEN=&P-"C$X.C V.C,T($U#7$AE;' -"C$X.C V.C,T(%-13$UG<@.T*,3@.Z
M,#8Z,S0@.4U%,36=R7%)E<S$P,S,-"C$X.C V.C,T(%-13$UG<EQ297-);G1L
M#0HQ.#HP-CHS-"!3=G)4;V]L#0HQ.#HP-CHS-"!3=G)4;V]L7%)E<S$P,S,-
M"C$X.C V.C,T(%-V<E1O;VQ<4F5S26YT; T*,3@.Z,#8Z,S0@.1%1354D-"C$X
M.C V.C,T($144U5)7%)E<S$P,S,-"C$X.C V.C,T($144U5)7%)E<TEN=&P-
M"C$X.C V.C,T($U33VQA< T*,3@.Z,#8Z,S0@.35-/;&%P7%)E<S$P,S,-"C$X
M.C V.C,T($U33VQA<%Q297-);G1L#0HQ.#HP-CHS-"!!5$P-"C$X.C V.C,T
M($%43%QW:6YN= T*,3@.Z,#8Z,S0@.051,7'=I;CEX#0HQ.#HP-CHS-"!-1D,T
M,E4-"C$X.C V.C,T(%9##0HQ.#HP-CHS-"!60@.T*,3@.Z,#8Z,S0@.4U%,061(
M;' -"C$X.C V.C,T(%-13$%D2&QP7%)E<S$P,S,-"C$X.C V.C,T(%-13$%D
M2&QP7%)E<T]T:&5R#0HQ.#HP-CHS-"![13 W1D1$0D4M-4$R,2TQ,60R+3E$
M040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.>T4P-T9$1$,W+35!,C$M,3%D
M,BTY1$%$+3 P0S T1C<Y1#0S-'T-"C$X.C V.C,T('M%,#=&1$1#,"TU03(Q
M+3$Q9#(M.41!1"TP,$,P-$8W.40T,S1]#0HQ.#HP-CHS-"![13 W1D1$0D8M
M-4$R,2TQ,60R+3E$040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.16YD($%C
M=&EO;B!,;V=396QE8W1E9$-O;7!O;F5N=',-"C$X.C V.C,T($)E9VEN($%C
M=&EO;B!);G-T86QL4&MG<SH-"C$X.C V.C,T($)E9VEN($%C=&EO;CH@.3&]C
M:V5D($-O;FYE8W1I=FET>2!&:6QE<R!#:&5C:PT*,3@.Z,#8Z,S8@.0V]N;F5C
M=&EV:71Y3&]C:V5D(')E='5R;F5D.B P#0HQ.#HP-CHS-B!4:&4@.;W!E<F%T
M:6]N(&-O;7!L971E9"!S=6-C97-S9G5L;'DN#0H-"C$X.C V.C,V($5N9"!!
M8W1I;VXZ($QO8VME9"!#;VYN96-T:79I='D@.1FEL97,@.0VAE8VL-"C$X.C V
M.C,V(%-E='5P(&ES(&EN<W1A;&QI;F<@.36EC<F]S;V9T($1A=&$@.06-C97-S
M($-O;7!O;F5N=',@.*$U$04,I("XN+@.T*,3@.Z,#8Z,S8@.7%Q#4U!,7 %-O9G1W
M87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<<W%L<F5D
M:7,N97AE("]Q.F$@.+T,Z(G-E='5P<F4N97AE(%=!4DX],2 M<R M4TU3(@.T*
M,3@.Z,#<Z,C @.17AI=$-O9&4Z(# -"C$X.C W.C(P(%-E='5P(&ES(&EN<W1A
M;&QI;F<@.36EC<F]S;V9T($1I<W1R:6)U=&5D(%1R86YS86-T:6]N($-O;W)D
M:6YA=&]R("A-4T140RD@.+BXN#0HQ.#HP-SHR," @.0SI<1$]#54U%?C%<041-
M24Y)?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<8VQD=&-S=' N97AE
M("U3=7!P;W)T1&ER(")#.EQ$3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q4
M96UP7%-Q;%-E='5P7$)I;B(@.+4140U!K9R B7%Q#4U!,7%-O9G1W87)E7$]T
M:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<9'1C<V5T=7 N97AE
M(B M3&]G1FEL92 B0SI<5TE.3E1<<W%L<W1P+FQO9R(-"C$X.C W.C(P(%!R
M;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ.#HP-SHR,"!);G-T86QL35-396%R
M8V@.@.:6YS=&%N8V4Z($-34$PR2PT*,3@.Z,#<Z,C @.4V]F='=A<F5<36EC<F]S
M;V9T7%-E87)C:%Q);G-T86QL.E9E<G-I;VX@.;F]T('!R97-E;G0-"C$X.C W
M.C(P($U34V5A<F-H(#(N,"!O<B!G<F5A=&5R('9E<G-I;VX@.8VAE8VL@.<F5T
M=7)N960@.+3$-"C$X.C W.C(Q(%-E='5P(&ES(&EN<W1A;&QI;F<@.=&AE($UI
M8W)O<V]F="!&=6QL+51E>'0@.4V5A<F-H($5N9VEN92 N+BX-"C$X.C W.C(Q
M(" B7%Q#4U!,7%-O9G1W87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8
M.#9<1G5L;%1E>'1<35-396%R8VA<4V5A<F-H7%-E87)C:%-T<"YE>&4B("]S
M("]A.E-13%-E<G9E<B1#4U!,,DL-"C$X.C W.C0U(%!R;V-E<W,@.17AI="!#
M;V1E.B H,"D@.#0HQ.#HP-SHT-2 @.+U$Z02 O5#I#.EQ$3T-5345^,5Q!1$U)
M3DE^,5Q,3T-!3%-^,5Q496UP7&EX<# P,2YT;7 -"C$X.C W.C0U(%-E='5P
M(&ES(&EN<W1A;&QI;F<@.2%1-3"!(96QP("XN+@.T*,3@.Z,#<Z-#8@.2%1-3"!(
M96QP(&EN<W1A;&QE<B!E>&ET(&-O9&4Z(# -"C$X.C X.C X($5N9"!!8W1I
M;VX@.26YS=&%L;%!K9W,-"C$X.C X.C X($)E9VEN($%C=&EO;B!-;W9E1FEL
M941A=&$Z#0HQ.#HP.#HP."!%;F%B;&5D(%-%3$9214=)4U1%4D)!5$-(#0HQ
M.#HP.#HP."!%;F%B;&5D($-/4D5#3TU03TY%3E1(04Y$3$E.1PT*,3@.Z,#DZ
M,# @.0F5G:6X@.06-T:6]N.B @.36]V949I;&5$871A4W!E8VEA; T*,3@.Z,#DZ
M,#$@.16YD($%C=&EO;CH@.($UO=F5&:6QE1&%T85-P96-I86P-"C$X.C Y.C Q
M($5N9"!!8W1I;VX@.("!-;W9E1FEL941A=&$-"C$X.C Y.C Q(%-E=%)E9D-O
M=6YT.B!#.EQ724Y.5%QS>7-T96TS,EQN='=D8FQI8BYD;&P@.*#4I#0HQ.#HP
M.3HP,2!"96=I;B!!8W1I;VX@.4')O8V5S<T%F=&5R1&%T84UO= F4Z#0HQ.#HP
M.3HP,2!<7$-34$Q<4V]F='=A<F5<3W1H97)S7%-13#(P,#!<1$5614Q/?C%<
M6#@.V7$)I;FY<:&AC;VPN97AE($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97)<.#!<5&]O;'-<0F]O:W,-"C$X.C Y.C R($5N9"!!8W1I
M;VX@.("!0<F]C97-S069T97)$871A36]V90T*,3@.Z,#DZ,#(@.0F5G:6X@.06-T
M:6]N($)U:6QD4V5R=F5R.@.T*,3@.Z,#DZ,#(@.0SI<1$]#54U%?C%<041-24Y)
M?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<<V-M+F5X92 @.+5-I;&5N
M=" Q("U!8W1I;VX@.-2 M17AE4&%T:" B1#I<4')O9W)A;2!&:6QE<UQ-:6-R
M;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DM<8FEN;EQS<6QS97)V<BYE
M>&4B("U397)V:6-E(")-4U-13"1#4U!,,DLB#0HQ.#HP.3HP,R!0<F]C97-S
M($5X:70@.0V]D93H@.*# I( T*,3@.Z,#DZ,#,@.0F5G:6X@.06-T:6]N.B!#<F5A
M=&5296=I<W1R>5-E=%-13 T*,3@.Z,#DZ,#,@.16YD($%C=&EO;CH@.0W)E871E
M4F5G:7-T<GE3971344P-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.4F5G5W)I
M=&53971U<$5N=')Y#0HQ.#HP.3HP,R!%;F0@.06-T:6]N.B!296=7<FET95-E
M='5P16YT<GD-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.0W)E871E4V5R#0HQ
M.#HP.3HP,R!%;F0@.06-T:6]N.B!#<F5A=&5397(-"C$X.C Y.C S($)E9VEN
M($%C=&EO;CH@.4VMU270-"C$X.C Y.C S($5N9"!!8W1I;VXZ(%-K=4ET#0HQ
M.#HP.3HP-"!3971&:6QE4V5C=7)I='E344Q!;F1!9&UI;B!F;W(@.1#I<4') O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DL@.
M<F5T=7)N960Z(# L(# -"C$X.C Y.C T(%-E=%)E9U-E8W5R:71Y4U%,06YD
M061M:6X@.9F]R(%-O9G1W87)E7$UI8W)O<V]F=%Q-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ#4U!,,DL@.<F5T=7)N960Z(# L(# -"C$X.C Y.C T($)E9VEN($%C
M=&EO;CH@.57!D871E4WES=&5M4&%T: T*,3@.Z,#DZ,#0@.4&%T:"!S=6-C97-S
M9G5L;'D@.=7!D871E9"X-"C$X.C Y.C T("5724XS,D1-25!!5$@.E7$))3CLE
M4WES=&5M4F]O="5<<WES=&5M,S([)5-Y<W1E;5)O;W0E.R53>7-T96U2;V]T
M)5Q3>7-T96TS,EQ78F5M.T0Z7%!R;V=R86T@.1FEL97-<35-344PW7$))3DX[
M0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L
M<UQ"24Y.#0HQ.#HP.3HP-"!%;F0@.06-T:6]N.B!5<&1A=&53>7-T96U0871H
M#0HQ.#HP.3HP-"!'<F%N="!2:6=H="!F;W(@.0TA%3%-/1E1<061M:6YI<W1R
M871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C T($=R86YT(%)I9VAT(&9O
M<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R;F5D(#H@.,2P@., T*,3@.Z
M,#DZ,#4@.1W)A;G0@.4FEG:'0@.9F]R($-(14Q33T947$%D;6EN:7-T<F%T;W(@.
M<F5T=7)N960@..B Q+" P#0HQ.#HP.3HP-2!'<F%N="!2:6=H="!F;W(@.0TA%
M3%-/1E1<061M:6YI<W1R871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C U
M($=R86YT(%)I9VAT(&9O<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R
M;F5D(#H@.,2P@., T*,3@.Z,#DZ,#8@.0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O
M9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L<UQ":6YN7&-N9F=S=G(N97AE(" M1B B
M0SI<5TE.3E1<<W%L<W1P+FQO9R(@.+4D@.0U-03#)+("U6(#$@.+4T@.," M42 B
M4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#25]!4R(@.+4@.@.,3DW,3(T("U5('-A
M("U0( T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C (R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(PT*#0H-
M"E-T87)T:6YG(%-E<G9I8V4@.+BXN#0H-"E-13%],871I;C%?1V5N97)A;%]#
M4#%?0TE?05,-"@.T*+6T@.+5$@.+50T,#(R("U4,S8U.0T*#0I#;VYN96-T:6YG
M('1O(%-E<G9E<B N+BX-"@.T*9')I=F5R/7MS<6P@.<V5R=F5R?3MS97)V97(]
M0U-03%Q#4U!,,DL[54E$/7-A.U!71#T[9&%T86)A<V4];6%S=&5R#0H-"EM-
M:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E<B!$<FEV97)=6U1#4"])4"!3;V-K
M971S74=E;F5R86P@.;F5T=V]R:R!E<G)O<BX@.0VAE8VL@.>6]U<B!N971W;W)K
M(&1O8W5M96YT871I;VXN#0H-"EM-:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E
M<B!$<FEV97)=6U1#4"])4"!3;V-K971S74-O;FYE8W1I;VY296%D("AR96-V
M*"DI+@.T*#0ID<FEV97(]>W-Q;"!S97)V97)].W-E<G9E<CU#4U!,7$-34$PR
M2SM5240]<V$[4%=$/3MD871A8F%S93UM87-T97(-"@.T*6TUI8W)O<V]F=%U;
M3T1"0R!344P@.4V5R=F5R($1R:79E<EU;5$-0+TE0(%-O8VME='-=1V5N97)A
M;"!N971W;W)K(&5R<F]R+B!#:&5C:R!Y;W5R(&YE='=O<FL@.9&]C=6UE;G1A
M=&EO;BX-"@.T*6TUI8W)O<V]F=%U;3T1"0R!344P@.4V5R=F5R($1R:79E<EU;
M5$-0+TE0(%-O8VME='-=0V]N;F5C=&EO;E)E860@.*')E8W8H*2DN#0H-"F1R
M:79E<CU[<W%L('-E<G9E<GT[<V5R=F5R/4-34$Q<0U-03#)+.U5)1#US83M0
M5T0].V1A=&%B87-E/6UA<W1E<@.T*#0I;36EC<F]S;V9T75M/1$)#(%-13"!3
M97)V97(@.1')I=F5R75M40U O25 @.4V]C:V5T<UU'96YE<F%L(&YE='=O<FL@.
M97)R;W(N($-H96-K('EO=7(@.;F5T=V]R:R!D;V-U;65N=&%T:6]N+@.T*#0I;
M36EC<F]S;V9T75M/1$)#(%-13"!397)V97(@.1')I=F5R75M40U O25 @.4V]C
M:V5T<UU#;VYN96-T:6]N4F5A9" H<F5C=B@.I*2X-"@.T*4U%,(%-E<G9E<B!C
M;VYF:6=U<F%T:6]N(&9A:6QE9"X-"@.T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(PT*#0HQ.#HP.3HS,R!0<F]C97-S($5X:70@.0V]D93H@.
M*"TQ*2 -"C$X.C$X.C(Y(%-E='5P(&9A:6QE9"!T;R!C;VYF:6=U<F4@.=&AE
M('-E<G9E<BX@.("!2969E<B!T;R!T:&4@.<V5R=F5R(&5R<F]R(&QO9W,@.86YD
M($,Z7%=)3DY47'-Q;'-T<"YL;V<@.9F]R(&UO<F4@.:6YF;W)M871I;VXN#0HQ
M.#HQ.#HR.2!!8W1I;VX@.0VQE86Y5<$EN<W1A;&PZ#0HQ.#HQ. #HR.2!#.EQ$
M3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q496UP7%-Q;%-E='5P7$)I;EQS
M8VTN97AE(" M4VEL96YT(#$@.+4%C=&EO;B T("U397)V:6-E(%-13$%G96YT
M)$-34$PR2PT*,3@.Z,3@.Z,CD@.4')O8V5S<R!%>&ET($-O9&4Z("@.Q,#8P*2!4
M:&4@.<W!E8VEF:65D('-E<G9I8V4@.9&]E<R!N;W0@.97AI<W0@.87,@.86X@.:6YS
M=&%L;&5D('-E<G9I8V4N#0H-"C$X.C$X.C(Y($,Z7$1/0U5-17XQ7$%$34E.
M27XQ7$Q/0T%,4WXQ7%1E;7!<4W%L4V5T=7!<0FEN7'-C;2YE>&4@.("U3:6QE
M;G0@.,2 M06-T:6]N(#0@.+5-E<G9I8V4@.35-344PD0U-03#)+#0HQ.#HQ.#HR
M.2!0<F]C97-S($5X:70@.0V]D93H@.*# I( T*,3@.Z,3@.Z,CD@.4W1A='-'96YE
M<F%T92!R971U<FYE9#H@.,@.T*,3@.Z,3@.Z,CD@.4W1A='-'96YE<F%T92 H,'@.R
M,C<L,'@.Q+#!X9C P+#!X,S P+#$P,S,L,S S+#!X,"PP>#$L,"PP+# -"C$X
M.C$X.C(Y(%-T871S1V5N97)A=&4@.+3$L061M:6YI<W1R871O<BD-"C$X.C$X
:.C(Y($EN<W1A;&QA=&EO;B!&86EL960N#0H`
`
end
You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand!
You the man! I was about to have a heart attack when i had uninstalled
our SQL Developer server and could not install Standard edition. Your
suggestion worked like a charm! Your advice is excellent even 6 months
later.
Blackened
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message537287.html

Problem in Installing SQL Server 2000 Personal

Hi... I recently reformatted my pc due to a very slow operation. Then I reinstall SQL Server 2000 Personal to my PC running Windows XP OS....As I run the setup, it will display INTERNAL ERROR and won't continue... What seemed to be the problem there? Before I reformatted the PC, it was installed well...

In windows XP I think you can only install Client tools ! ! ! anything from the setup log ?|||

Deepak... you can install Personal Edition on XP as well.. the problem seems to be something else... check error log or post the exact error what u get

BTW why u want to install 2000 , you have SQL Server 2005 Express downloadable edition. I think u should install that...

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

http://www.databasejournal.com/features/mssql/article.php/1442281

Madhu

|||Madhu, Thanks for pointing out my mistake.......apologize for my ignorance|||

No Deepak... we all make mistake... we all are there for a common cause to its help each other and there by improve our knowledge... so pse do not take it as personal...

Madhu

|||

Madhu, I didnt take it personnally.I am indeed happy that you pointed out my mistake Smile so that i can learn from my mistakes.......i just felt like apologising for providing a wrong information........thanks once again friend

|||

Hi...Thanks for your immediate replies...Madhu the exact error displays

"Internal Error. Contact Microsoft Technical Support."

I already have SQL Server 2005 Express installed and it does not allow connections to other pc...

I have found out about SQL Management Studio and used it instead....And it really has a good environment...

Thank for replying here.... Happy programming!

sql

Problem in getting SUM of Running Total Field

Hi buddy...

i m creating a report as below

--------------------------
Report Head ==>>> | Field1 |
--------------------------
Field2 Field3 Field4 Field5 Field6 Field7
--------------------------

Detail Section Here.....

--------------------------
sum(Field7)
--------------------------

Field7 is my Running Formula Field. i.e. Field7= (Field1 + Field5 - Field6)
nd thats working well.

Working ::

i m generating a report that nd gets the sum of Field7 as far as there is some record in details.

but when there is no record in the details section Sum of Field7 shows me nothing,
where as i am required to display the value of Field1 in it if there is nothing in the details section.

He who give solution will be considered a well qualified person.

with thanks nd admiration in advance

Silly StarCreate another formula with this :

If IsNull(Field7) then
Field1
else
Field7|||Hey KristyW

You Are Real Genius

Thats Worked Perfectly.

Thank u So much Sir but there r more Problems regarding Crystal Report
May i ask them

Silly Star|||u r a real "Silly Star"|||Hi ...

i m creating a report as below

--------------------------
GroupHeader ==>>> | Field1 |
--------------------------
Field2 Field3 Field4 Field5 Field6 Field7
--------------------------

Detail Section Here.....

--------------------------
GroupFooter==>> sum(Field7)
--------------------------

Field7 is the Running Formula Field. i.e. Field7= (Field1 + Field5 - Field6)
and i reset this formula on GroupChange
nd thats working well.

but when a group is changed it does not work properly (Meaning the desired result is not displayed)

He who give solution will be considered a well qualified person.

with thanks nd admiration in advance

Silly Star|||hai silly star

Edit the running field as

In the summary part give field 7 as the field to summarize and typeof summary is sum

In the evaluate column check the 'for each record' and

In the reset column check the 'on chage of group'

try this and it will work for you i believe

bye

viji

Monday, March 26, 2012

Problem in Configuring ASPState DB for .NET 2.0

Hi,

In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session.

Problem that we are facing: After going through couple of article for configuring the ASPState DB, We ran the InstallPersistSqlState.sql of .net 2.0 framework (log information is given below). Though the sql has updated the existing ASPState DB with the stored procedure corresponding to asp.net 2.0, still we get the following error

Exception: System.Web.HttpException
Message: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

For certain reasons, we are not able to use aspnetreg_sql.exe for setting up the ASPState database. Is there something that I am missing when I run InstallPersistSqlState.sql alone.

Appreciate your help.

Thanks,

Siva

PS: We ran the InstallPersistSqlState.sql in the local sqlserver2000 (residing in winxp) and it works fine.

Result Log:

Run 'aspnet_regsql.exe -?' for details.
--

Completed execution of UninstallPersistSqlState.SQL
Starting execution of InstallPersistSqlState.SQL

--
Note:
This file is included for backward compatibility
only. You should use aspnet_regsql.exe to install
and uninstall SQL session state.
Run 'aspnet_regsql.exe -?' for details.
--
The CREATE DATABASE process is allocating 0.63 MB on disk 'ASPState'.
The CREATE DATABASE process is allocating 0.49 MB on disk 'ASPState_log'.
If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61
The specified @.job_name ('ASPState_Job_DeleteExpiredSessions') does not exist.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
If the category already exists, an error from msdb.dbo.sp_add_category is expected.
Server: Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32
The specified @.name ('[Uncategorized (Local)]') already exists.
-
Completed execution of InstallPersistSqlState.SQL
-

First of all, this is not the right place for posting a question about the ASP.NET Session DB, this is a CLR in SQLServer related forum only. But from the logs posted the db should have been installed. Make sure that you are trying to connect to the right session database from your web.config file. Also try to monitor if the passwort / username provided are right.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Dod you solve the problem ?|||

Hi,

I got this problem resolved by running the aspnet_regsql.exe with command line options to setup the ASPState DB.

Anyways, Thanks for the suggestion.

Thanks,

Siva

Wednesday, March 21, 2012

Problem getting SQL Server 2000 EE to use more than 4GB of memory

We are trying to get our SQL Server 2000 Enterprise Edition server to
use more than 4GB of memory on a machine with 8GB of physical memory
(running Windows 2003 Server Enterprise Edition).
I have done the following:
1. Updated Boot.ini to have the /3GB /PAE switch
2. set Max Server Memory to 7168MB using sp_configure
3. set Min Server Memory to 1024MB using sp_configure
4. set AWE enabled using sp_configure
5. configured user account that SQL Server runs under (SYSTEM) to have
rights for the "Lock Page in Memory" policy
When I look at "total server memory" for SQL Server under the
peformance viewer, it is using 4GB of memory. When I look at the task
manager, we have 2GB of physical memory free. I understand that with
AWE, the OS needs 1GB of memory to manage the extended memory. With
the /3GB switch, the OS will allocate 1GB to the kernel. So that makes
6GB of memory... Why are there 2GB of memory free, and why can't SQL
Server use it? I even added up the memory of all processes running in
the task manager, and it adds up to maybe 30MB.
Any ideas why we only get 4GB for SQL Server? We want to put 16GB of
RAM in this server, but until we can prove that SQL Server can
actually use it, we can't justify it. Is this 2GB of "free" RAM really
free, or allocated to something else such that SQL Server cannot use
it?Has your workload driven the SQL instance sufficiently hard on memory? Note
that until SQL Server is pressured to use more memory, it won't.
Linchi
"advisortechnical" wrote:
> We are trying to get our SQL Server 2000 Enterprise Edition server to
> use more than 4GB of memory on a machine with 8GB of physical memory
> (running Windows 2003 Server Enterprise Edition).
> I have done the following:
> 1. Updated Boot.ini to have the /3GB /PAE switch
> 2. set Max Server Memory to 7168MB using sp_configure
> 3. set Min Server Memory to 1024MB using sp_configure
> 4. set AWE enabled using sp_configure
> 5. configured user account that SQL Server runs under (SYSTEM) to have
> rights for the "Lock Page in Memory" policy
> When I look at "total server memory" for SQL Server under the
> peformance viewer, it is using 4GB of memory. When I look at the task
> manager, we have 2GB of physical memory free. I understand that with
> AWE, the OS needs 1GB of memory to manage the extended memory. With
> the /3GB switch, the OS will allocate 1GB to the kernel. So that makes
> 6GB of memory... Why are there 2GB of memory free, and why can't SQL
> Server use it? I even added up the memory of all processes running in
> the task manager, and it adds up to maybe 30MB.
> Any ideas why we only get 4GB for SQL Server? We want to put 16GB of
> RAM in this server, but until we can prove that SQL Server can
> actually use it, we can't justify it. Is this 2GB of "free" RAM really
> free, or allocated to something else such that SQL Server cannot use
> it?
>|||On Apr 24, 8:28=A0am, Linchi Shea <LinchiS...@.discussions.microsoft.com>
wrote:
> Has your workload driven the SQL instance sufficiently hard on memory? Not=e
> that until SQL Server is pressured to use more memory, it won't.
> Linchi
>
> "advisortechnical" wrote:
> > We are trying to get our SQL Server 2000 Enterprise Edition server to
> > use more than 4GB of memory on a machine with 8GB of physical memory
> > (running Windows 2003 Server Enterprise Edition).
> > I have done the following:
> > 1. Updated Boot.ini to have the /3GB /PAE switch
> > 2. set Max Server Memory to 7168MB using sp_configure
> > 3. set Min Server Memory to 1024MB using sp_configure
> > 4. set AWE enabled using sp_configure
> > 5. configured user account that SQL Server runs under (SYSTEM) to have
> > rights for the "Lock Page in Memory" policy
> > When I look at "total server memory" for SQL Server under the
> > peformance viewer, it is using 4GB of memory. When I look at the task
> > manager, we have 2GB of physical memory free. I understand that with
> > AWE, the OS needs 1GB of memory to manage the extended memory. With
> > the /3GB switch, the OS will allocate 1GB to the kernel. So that makes
> > 6GB of memory... Why are there 2GB of memory free, and why can't SQL
> > Server use it? I even added up the memory of all processes running in
> > the task manager, and it adds up to maybe 30MB.
> > Any ideas why we only get 4GB for SQL Server? We want to put 16GB of
> > RAM in this server, but until we can prove that SQL Server can
> > actually use it, we can't justify it. Is this 2GB of "free" RAM really
> > free, or allocated to something else such that SQL Server cannot use
> > it... Hide quoted text -
> - Show quoted text -
It seems you have done all the things what is required to configure
SQL AWE. You can also stress the server by genearting some test data
on the same.
Please verify if you have SP4 and AWE patch is applied on above.
Thanks
Ajay Rengunthwar
MCTS,MCDBA,MCAD|||On Apr 24, 8:12=A0pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
> On Apr 24, 8:28=A0am, Linchi Shea <LinchiS...@.discussions.microsoft.com>
> wrote:
>
>
> > Has your workload driven the SQL instance sufficiently hard on memory? N=ote
> > that until SQL Server is pressured to use more memory, it won't.
> > Linchi
> > "advisortechnical" wrote:
> > > We are trying to get our SQL Server 2000 Enterprise Edition server to
> > > use more than 4GB of memory on a machine with 8GB of physical memory
> > > (running Windows 2003 Server Enterprise Edition).
> > > I have done the following:
> > > 1. Updated Boot.ini to have the /3GB /PAE switch
> > > 2. set Max Server Memory to 7168MB using sp_configure
> > > 3. set Min Server Memory to 1024MB using sp_configure
> > > 4. set AWE enabled using sp_configure
> > > 5. configured user account that SQL Server runs under (SYSTEM) to have=
> > > rights for the "Lock Page in Memory" policy
> > > When I look at "total server memory" for SQL Server under the
> > > peformance viewer, it is using 4GB of memory. When I look at the task
> > > manager, we have 2GB of physical memory free. I understand that with
> > > AWE, the OS needs 1GB of memory to manage the extended memory. With
> > > the /3GB switch, the OS will allocate 1GB to the kernel. So that makes=
> > > 6GB of memory... Why are there 2GB of memory free, and why can't SQL
> > > Server use it? I even added up the memory of all processes running in
> > > the task manager, and it adds up to maybe 30MB.
> > > Any ideas why we only get 4GB for SQL Server? We want to put 16GB of
> > > RAM in this server, but until we can prove that SQL Server can
> > > actually use it, we can't justify it. Is this 2GB of "free" RAM really=
> > > free, or allocated to something else such that SQL Server cannot use
> > > it... Hide quoted text -
> > - Show quoted text -
> It seems you have done all the things what is required to configure
> SQL AWE. You can also stress the server by genearting some test data
> on the same.
> Please verify if you have SP4 and AWE patch is applied on above.
> Thanks
> Ajay Rengunthwar
> MCTS,MCDBA,MCAD- Hide quoted text -
> - Show quoted text -
Thanks for the advice. I ran a stress test by opening several query
analyzer windows and running a select * query on a table with millions
of rows. I found that sql server->memory manger->target server memory
and total server memory stayed fixed at 4164408 (3.97 GB), however the
amount of available physical memory in the windows task manager had
shrunk to 1 GB from 2 GB (and it is continuing to shink as the test is
still running).
So I think on a machine with 8GB, with AWE and PAE enabled, SQL Server
can only take 3.97 GB of memory, because a certain amount of memory
needs to be free for Windows, even though it is "free" memory and the
kernel has 1GB of memory. This free memory is decreasing as the stress
test is running.
I am wondering if I add more RAM to this machine, will SQL Server will
be able to use it?|||On Apr 25, 4:08=A0pm, advisortechnical <chand.bel...@.caremark.com>
wrote:
> On Apr 24, 8:12=A0pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
>
>
> > On Apr 24, 8:28=A0am, Linchi Shea <LinchiS...@.discussions.microsoft.com>=
> > wrote:
> > > Has your workload driven the SQL instance sufficiently hard on memory?= Note
> > > that until SQL Server is pressured to use more memory, it won't.
> > > Linchi
> > > "advisortechnical" wrote:
> > > > We are trying to get our SQL Server 2000 Enterprise Edition server t=o
> > > > use more than 4GB of memory on a machine with 8GB of physical memory=
> > > > (running Windows 2003 Server Enterprise Edition).
> > > > I have done the following:
> > > > 1. Updated Boot.ini to have the /3GB /PAE switch
> > > > 2. set Max Server Memory to 7168MB using sp_configure
> > > > 3. set Min Server Memory to 1024MB using sp_configure
> > > > 4. set AWE enabled using sp_configure
> > > > 5. configured user account that SQL Server runs under (SYSTEM) to ha=ve
> > > > rights for the "Lock Page in Memory" policy
> > > > When I look at "total server memory" for SQL Server under the
> > > > peformance viewer, it is using 4GB of memory. When I look at the tas=k
> > > > manager, we have 2GB of physical memory free. I understand that with=
> > > > AWE, the OS needs 1GB of memory to manage the extended memory. With
> > > > the /3GB switch, the OS will allocate 1GB to the kernel. So that mak=es
> > > > 6GB of memory... Why are there 2GB of memory free, and why can't SQL=
> > > > Server use it? I even added up the memory of all processes running i=n
> > > > the task manager, and it adds up to maybe 30MB.
> > > > Any ideas why we only get 4GB for SQL Server? We want to put 16GB of=
> > > > RAM in this server, but until we can prove that SQL Server can
> > > > actually use it, we can't justify it. Is this 2GB of "free" RAM real=ly
> > > > free, or allocated to something else such that SQL Server cannot use=
> > > > it... Hide quoted text -
> > > - Show quoted text -
> > It seems you have done all the things what is required to configure
> > SQL AWE. You can also stress the server by genearting some test data
> > on the same.
> > Please verify if you have SP4 and AWE patch is applied on above.
> > Thanks
> > Ajay Rengunthwar
> > MCTS,MCDBA,MCAD- Hide quoted text -
> > - Show quoted text -
> Thanks for the advice. I ran a stress test by opening several query
> analyzer windows and running a select * query on a table with millions
> of rows. I found that sql server->memory manger->target server memory
> and total server memory stayed fixed at 4164408 (3.97 GB), however the
> amount of available physical memory in the windows task manager had
> shrunk to 1 GB from 2 GB (and it is continuing to shink as the test is
> still running).
> So I think on a machine with 8GB, with AWE and PAE enabled, SQL Server
> can only take 3.97 GB of memory, because a certain amount of memory
> needs to be free for Windows, even though it is "free" memory and the
> kernel has 1GB of memory. This free memory is decreasing as the stress
> test is running.
> I am wondering if I add more RAM to this machine, will SQL Server will
> be able to use it... Hide quoted text -
> - Show quoted text -
I think it is the system cache that needs this memory. When I run a
stress test, the amount of available memory decreases and the system
cache increases. It is confusing -- why would it say there are 2GB of
free memory, if it was allocated to the system cache? Of course, some
memory must be given to the system cache, otherwise these huge queries
couldn't do disk i/o efficiently. I changed one of the registry
settings to allow a large system cache, however I saw no change in SQL
Server memory utilization.sql

Monday, March 12, 2012

Problem Deploying SSAS Connection cannot be made. Ensure server running

I have a couple of questions. I've gotten Our SSAS Running against SS 2000 where the Server is separate from the Web Server running IIS by installing SSAS on the Web Server and Pointing it to the instance on the Database Server. This works on both mine and my bosses systems and I finally got it working on our internal server (the described situation above, our dev computers have all running on one box).

When I implement this on one of our client configurations that is the same as the first above (DB + SSAS and connected to IIS Server with SSAS as well) I cannot get it to connect and return the data.

The error I get via my Asp.net 2.0 webpage is :

A connection cannot be made. Ensure that the server is running.

I have checked every possible setting between the two sets of servers and I'm about to lose it Smile

Everything seems identical. Do you have any suggestions. I checked the services to see if the SSAS was running on the web server and it is.

Suggestions?

SSAS authenticates using windows authentication. In order to get an ASP.NET application to connect to SSAS, it needs to be running under an account that is in a role in SSAS that has rights to view the cube you want to query.

There are a couple of ways to do this:

For IIS6, you are best to setup an application pool running under a domain account, run your ASP.NET in that application pool and put that domain account in a role in SSAS.

For IIS5 instead of using an application pool you can set the account using the <Identity> tag in the web.config

Note: to SSAS, it will see all requests as coming from a single user so you cannot use role based security with this sort of setup. If you need role based security you would need to maybe look into setting up HTTP authentication.

|||

Ok I'm a bit confused. Sorry.

I've got on Server 1

IIS & Analysis Services

On Server 2

SQL Server 2000 & Analysis Services

As far as I got was installing Analysis Services on the Web Server.

There is an Application Pool that the website is running under but I'm not sure how to setup the Roles for that Pool.

I added user roles under the SSAS on the web server but it's still not working. Sorry for my confusion, I took over this project from another developer and have never worked with this before. Thank you so much for your assistance.

|||So why are there 2 AS servers? and which one has the database you want to connect to?

If you just want your web server to connect to the second server with AS and SQL on it then you don't need AS on the web server, you just need the OLEDB provider for Analysis Services (version 8.0 for AS 2000). The typical problem with web servers is that NTLM credentials will not do 2 hops. What this means is that the client can authenticate to the web server, but the web server cannot pass those credentials along to the second server (for security reasons).

There are actually 2 ways around this you can configure Kerberos authentication (there are a couple of whitepapers from MS on this, they should not be too hard to find). The only other thing you need is to have <Identity Impersonate="True" /> in your web.config.

Using the original method I described, I would actually create a new app pool, just for this application. In the app pool settings I think there is an Identity tab, you would set this to run as a specific domain user. Then on your AS server create a role with the same domain account and give it access to the database/cubes that the web app needs.

|||

I tried setting up Application Pool, didn't work. I'm not sure the client wants Kerberos installed on the machine. I have this working on our internal computers (2 workstations) and our development servers. I'm trying to put it on theirs and having difficulty.

I setup Roles on the AS server (I'd rather not use the same one as on the database server) on the IIS Server (running Windows Server 2003). I can connect to the DataMart and see the data. I can get to the page but it wont' connect from IIS to AS it seems.

Using <Identity...> blows it up says it's not recognized (I'm assuming you need IIS 5 or Kerberos for that to work).

I setup every way I could imagine in the App Pool settings. It defaults as Network. I tried that. Then I tried various user configurations.

So the DB server is on SQL 2000, our test was on SQL 2005.

Thanks for your help. Any more ideas?

|||

If you want to use the AS on the IIS box, then that makes things a bit easier. You only need Kerberos when IIS and AS are on separate machines.

The <Identity ...> tag is an ASP.NET setting and works for both IIS 5 and 6, but it is case sensitive and needs to be under the right section of the web.config file. But if you are using IIS 6 and don't need role based security then you are better off just using the app pool identity.

If you left the App Pool set to Network, you would need to go into the Role Manager for your database and either create a new role or add the "NETWORK" user to an existing role.

It's a lot simpler if IIS and AS are on the same box, the main "trick" is that it is the app pool account that connects to AS and needs to be in an appropriate role. If they are on the same machine you should not have trouble with firewalls and identities not crossing machine boundaries.

Problem deploying site developed with Sql Ex. To server running Sql Server 2005.

Can someone show me, or direct me, to a source,that shows me how, and what to change,when deploying a website from a development server running Sql Ex to a production server running Sql server 2005.I can’t get the sites to run under Sql server 2005.

They work in Sql Ex. what must I change?The connection string, to what format?and what else?I attached the dB to Sql 2005 and browsed the content in the Sql manager.But can’t get the aspx pages to work on the server.

Help please

What is the error code you get from your ASP application?

When connecting to SQL Express, you normally specify server as <servername>\sqlexpress. When you switch to sqlserver 2005, depending on it instance name, you need to change your connection string if you hard-code the connection string in your ASP app. For default instance, you can use <servername>, for named instance, you can use <servername>\<instancename>.

If you can't resolve your issue, please post your connection string, error message from ASP application and server connectivity configuration, such as whether it is name instance or default instance, whether you have TCP up or browser up and etc.

|||

Thanks Nan Tu for the assistance

This is the connection string error i get:

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

But i have setup the virtual drive as a app in the root.

This is theconnection string:

</connectionStrings>

also TCP and browser are enabled

|||The errormsg is not from connectivity driver, you probably need to ask either in ASP or IIS forums.

Friday, March 9, 2012

Problem deploying site developed with Sql Ex. To server running Sql Server 2005.

Can someone show me, or direct me, to a source, that shows me how, and what to change, when deploying a website from a development server running Sql Ex to a production server running Sql server 2005. I can't get the sites to run under Sql server 2005.

They work in Sql Ex. what must I change? The connection string, to what format? and what else? I attached the dB to Sql 2005 and browsed the content in the Sql manager. But can't get the aspx pages to work on the server.

Help please

The connection string format of SQL 2005 should be the same as SQL Ex, only the change should be the data source name and user/password. What the error you got after change to SQL2005?|||

It's configured properly as a application, And it is in the root of the application

Parser Error Message:It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

|||Your new error message seems to be an IIS issue, we'd better get help from IIS expert.|||As far as I know, the exception is thrown when an element that is only allowed in the application root is set in a web.config file that is in a subfolder. Please check.|||

We have the files in the root and we believe its some connection issue because of all the test we've run. This is a more detailed explanation of what me and my partner have been working on.

Any help would be very very much appreciated as I am about 15 hours into this :(

Background is a development system with ASP.NET 2.0 and SQL express 2005. The server is SQL 2005 standard edition. Any ASPX pages that connect to a database results in errors.

I have 2 identical servers with Windows server 2003, one has SQL Express and the other has SQL Server 2005 standard. that is the only difference between these systems. The scripts that work seamlessly when uploaded to the SQL Express server dont work on the SQL Server 2005

My connection string is

two interesting tidbits

1.) No matter what the initial catalog is pointing to, I get the same error. EVEN if the database doesnt exist

Cannot open database "C:\INETPUB\WWWROOT\test\app_data\aspnwet.MDF" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

2.) second interesting thing is this, if I change the datasource to "MSSQLSERVER" which is the instance name of SQL 2005. the error changes to

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)

I have reinstalled SQL server 2005

I have verified that under SQL Server 2005 Surface Area Configuration that remote connections has Both TCP and Named Pipes enabled

I have verified that under the Network Configuration that the protocols for TCP/IP and Named pipes are enabled.

I have tried atleast 20 different variations of Connectionstrings

I have ran aspnet_regsql against the database

I have verified that the SQL Server Browser is started

I have verified that the TCP/IP is set in Network Configuration to default port 1433

I have gave all authentication rights to Network Service and ASPNET accounts for testing against both the MASTER and ASPNET databases using Management Studio and attaching the Database

I have created a custom SQL account with access to the database in question and added the username password syntax to the connectionstring and get the same login failed message.

If anyone can give any insight that would be MUCH appreciated!! thanks in advance.

|||

You are using SQL 2005 Express default connection for ASPNETDB.MDF which is sitting in App_Data folder within your application. It will not work when you switch to sql 2005 standard because you don't have the SQL 2005 Express version anymore.

This is not for you to use under SQL Server 2005 or 2000.

You need a new customized connection to point to this database ASPNETDB.MDFor (all tables from this one). Useaspnet_regsql.exe to generate this database in your target database.

I assume you may combine this one with your database.

After the database is ready, create a connection in your web.config file. Importantly, you need to add customized role and membership provider to point back to your database.

I'll copy some code at the end that works.

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

</system.web>

</configuration>

Please try this.

Let me know if this works or new issues come out.

Have a good sleep and we will be there.

Problem Deleting Publications

I am running SQL Server 2000 with SP3. I receive the following message when trying to delete my publications:

SQL Server Enterprise Manager could not retrieve information about publication 'Named Publication'.

Error 2812: Could not find stored procedure ".

Also, for some reason the system is still trying to replicate even though it claims there is no distributor available... Any ideas would be greatly appreciated.

Thanks,

absoluttUse Profiler to check for command what EM is trying to execute and you will know what is going on.

Wednesday, March 7, 2012

Problem Creating Job and Running The JOb

Hello All,
I am having problem with my SQL Server 2000. I don't know this
is best place to put this question but i don't have any other way. I have sql
server with service pack 4 installed on it. I create a simple DTS package and
then Try to schedule it which will automatically create a Job. When i try to
run this job. It failed with the following error.
"The system cannot find the file specified"
Please any help .......................Does the job work when you run it manually?
Do you run it on your computer or the server when run manually.
Is it using any files that reside on the hard drive?
--
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Faisal Mirza" <Faisal Mirza@.discussions.microsoft.com> wrote in message
news:C2CCB594-B819-4E2C-BED3-4514D54AD102@.microsoft.com...
> Hello All,
> I am having problem with my SQL Server 2000. I don't know
> this
> is best place to put this question but i don't have any other way. I have
> sql
> server with service pack 4 installed on it. I create a simple DTS package
> and
> then Try to schedule it which will automatically create a Job. When i try
> to
> run this job. It failed with the following error.
> "The system cannot find the file specified"
> Please any help .......................|||Hi,
Thanks for quick reply. I run it manually and it fail. With the same
error. The dts is simple select statement. And i run it. it works fine.
Another information which i think is usefull:
When i try to run DTSRUN command from command prompt it will say Unknown
command. Which means it is the problem of installation.
I run the Installation file again and fix the registry but the problem is
still there.
I run again the service pack 4 but not help full
Thanks in advance......
"Nik Marshall-Blank" wrote:
> Does the job work when you run it manually?
> Do you run it on your computer or the server when run manually.
> Is it using any files that reside on the hard drive?
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Faisal Mirza" <Faisal Mirza@.discussions.microsoft.com> wrote in message
> news:C2CCB594-B819-4E2C-BED3-4514D54AD102@.microsoft.com...
> > Hello All,
> > I am having problem with my SQL Server 2000. I don't know
> > this
> > is best place to put this question but i don't have any other way. I have
> > sql
> > server with service pack 4 installed on it. I create a simple DTS package
> > and
> > then Try to schedule it which will automatically create a Job. When i try
> > to
> > run this job. It failed with the following error.
> > "The system cannot find the file specified"
> >
> > Please any help .......................
>
>|||If the installation is corrupted then applying SP4 will not fix it. You may
have to ununstall and re-install. If you do this take a backup of your user
databases or detach them first and copy them to another folder. You can copy
them back and restore/attach after re-installing.
--
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Faisal Mirza" <FaisalMirza@.discussions.microsoft.com> wrote in message
news:18C9C988-5F88-4C58-900D-3E69C4E7104A@.microsoft.com...
> Hi,
> Thanks for quick reply. I run it manually and it fail. With the same
> error. The dts is simple select statement. And i run it. it works fine.
> Another information which i think is usefull:
> When i try to run DTSRUN command from command prompt it will say Unknown
> command. Which means it is the problem of installation.
> I run the Installation file again and fix the registry but the problem is
> still there.
> I run again the service pack 4 but not help full
> Thanks in advance......
> "Nik Marshall-Blank" wrote:
>> Does the job work when you run it manually?
>> Do you run it on your computer or the server when run manually.
>> Is it using any files that reside on the hard drive?
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> Linz, Austria
>> "Faisal Mirza" <Faisal Mirza@.discussions.microsoft.com> wrote in message
>> news:C2CCB594-B819-4E2C-BED3-4514D54AD102@.microsoft.com...
>> > Hello All,
>> > I am having problem with my SQL Server 2000. I don't know
>> > this
>> > is best place to put this question but i don't have any other way. I
>> > have
>> > sql
>> > server with service pack 4 installed on it. I create a simple DTS
>> > package
>> > and
>> > then Try to schedule it which will automatically create a Job. When i
>> > try
>> > to
>> > run this job. It failed with the following error.
>> > "The system cannot find the file specified"
>> >
>> > Please any help .......................
>>|||Hi Faisal,
Do sql Agent is runing.
Is sql agent running under local system user account
Can u manually create a job.
HTH
from
Doller
Faisal Mirza wrote:
> Hi,
> Thanks for quick reply. I run it manually and it fail. With the same
> error. The dts is simple select statement. And i run it. it works fine.
> Another information which i think is usefull:
> When i try to run DTSRUN command from command prompt it will say Unknown
> command. Which means it is the problem of installation.
> I run the Installation file again and fix the registry but the problem is
> still there.
> I run again the service pack 4 but not help full
> Thanks in advance......
> "Nik Marshall-Blank" wrote:
> > Does the job work when you run it manually?
> > Do you run it on your computer or the server when run manually.
> > Is it using any files that reside on the hard drive?
> >
> > --
> > Nik Marshall-Blank MCSD/MCDBA
> > Linz, Austria
> >
> > "Faisal Mirza" <Faisal Mirza@.discussions.microsoft.com> wrote in message
> > news:C2CCB594-B819-4E2C-BED3-4514D54AD102@.microsoft.com...
> > > Hello All,
> > > I am having problem with my SQL Server 2000. I don't know
> > > this
> > > is best place to put this question but i don't have any other way. I have
> > > sql
> > > server with service pack 4 installed on it. I create a simple DTS package
> > > and
> > > then Try to schedule it which will automatically create a Job. When i try
> > > to
> > > run this job. It failed with the following error.
> > > "The system cannot find the file specified"
> > >
> > > Please any help .......................
> >
> >
> >

Problem creating folder through package

hi !

I am creating a directory folder inside the package. At first attempt while running the package it creates without any errors but when i run it second time it throws up warning message : Directory already exists. but the package succeeds.

When i try running it from another server through command line it fails. saying that Device it not Ready.

What is the proble here !!!!!!! Any help please

Jas

Guess you should be getting some error like the following - "Error: 0xC002F304 at File System Task, File System Task: An error occurred with the following error message: "The device is not ready."

Please check whether the drive and the path to the folder which you are trying to create exist in the Server.

Thanks,
Loonysan

|||

yes it does!!!!!

When i tried duplicating this problem from my machine accecssing a drive which was not there i got the same error SO i could understand that the drive and path should be correct to create the directory. When i tried the correct drive and path it work.

what are the methods to find what else the probelm could be? Permissions etc.

Thanks,

Jasmine

Saturday, February 25, 2012

Problem creating database diagram

I have both SQL Server 2000 and SQL Server 2005 installed on my PC running windows XP SP2.

In the Microsoft SQL Server Management Studio, when I right click Database Diagram in the Object Explorer, I cannot find any option to create a database diagram. What is given is "Working with SQL Server 2000 diagrams".

How can I fix my configuration so that I am able to create database diagrams in the SQL Server 2005?

Did you expand the database diagrams folder first to get the support objects created in the database?

What menu items do you get when you right click on the database diagrams folder?

Also in Help -> about, what version of SQL Server Management Studio do you have installed?

|||1. There isn't anything to expand under the database diagrams folder.
2. Right clicking on this folder gives three items:
a. Working with SQL Server 2000 diagrams
b. Reports --> Custom Report ...
c. Refresh
3. Version info:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Hope these info help. Thanks.

Monday, February 20, 2012

Problem Connecting to Sql Server 2005 locally by Name

Configuration:
Sql server running on a test machine with mirrored drive for OS and SAN for
data.
Problem:
A week ago a mirrored drive went down. We reconfigured the drive and
updated the drivers on the drive. About the same time the backups stopped
running. The sqlagent reported errors like this one:
2007-08-09 19:03:16 - ! [382] Logon to server 'DatabaseName' failed
(ConnAttemptCachableOp)
2007-08-09 19:03:46 - ! [298] SQLServer Error: 87, SQL Network Interfaces:
Connection string is not valid [87]. [SQLSTATE 08001]
Also note that when trying to connect to the database via the Sql Server
Management Studio using the name on the local machine an error is thrown
stating that a connection couldn't be made; however, when using the IP there
is no problem.
Note that there is no problem connecting to the machine from remote machines
and that the problem is only when trying to connect to the db using the name
from the machine. Reporting services can no longer connect nor the sql agent.
Hmmm. When connecting locally the SQL Server Native Client will attempt to
connect using the Shared Memory protocol. If you connect locally using the
IP address, the SQL Server Native Client will attempt to connect using TCP.
So I'm guessing the problem is with shared memory. Is it still enabled on
both the server and for client connections on the server? You can use SQL
Server Configuration Manager to check both.
Did the server forget it's name? What is the result of SELECT name FROM
sys.servers ?
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wes" <Wes@.discussions.microsoft.com> wrote in message
news:D0BA4742-F782-44AC-A7A8-86E4C8E7ACEA@.microsoft.com...
> Configuration:
> Sql server running on a test machine with mirrored drive for OS and SAN
> for
> data.
> Problem:
> A week ago a mirrored drive went down. We reconfigured the drive and
> updated the drivers on the drive. About the same time the backups stopped
> running. The sqlagent reported errors like this one:
> 2007-08-09 19:03:16 - ! [382] Logon to server 'DatabaseName' failed
> (ConnAttemptCachableOp)
> 2007-08-09 19:03:46 - ! [298] SQLServer Error: 87, SQL Network Interfaces:
> Connection string is not valid [87]. [SQLSTATE 08001]
> Also note that when trying to connect to the database via the Sql Server
> Management Studio using the name on the local machine an error is thrown
> stating that a connection couldn't be made; however, when using the IP
> there
> is no problem.
> Note that there is no problem connecting to the machine from remote
> machines
> and that the problem is only when trying to connect to the db using the
> name
> from the machine. Reporting services can no longer connect nor the sql
> agent.
|||Rick,
Thx for the reply.
1. Q:Did the server forget it's name?
-- Running the supplied query returns the correct name of the server. So,
this is okay.
2. Q:Is it still enabled on both the server and for client connections on
the server?
-- Yes. I disabled Shared Memory for both the client & server and tried
again to connect and still recieve the message " Cannot connect to {database
name}. 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: 25 - Connection string is not
valid) (Microsoft SQL Server, Error: 87)"
*note: I have no problem connecting remotely. However - I do have a
problem connection locally and the services all throw similar errors when
trying to connect to the database. Also, I cannot apply any service packs
because I can not authenticate locally.
"Rick Byham, (MSFT)" wrote:

> Hmmm. When connecting locally the SQL Server Native Client will attempt to
> connect using the Shared Memory protocol. If you connect locally using the
> IP address, the SQL Server Native Client will attempt to connect using TCP.
> So I'm guessing the problem is with shared memory. Is it still enabled on
> both the server and for client connections on the server? You can use SQL
> Server Configuration Manager to check both.
> Did the server forget it's name? What is the result of SELECT name FROM
> sys.servers ?
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Wes" <Wes@.discussions.microsoft.com> wrote in message
> news:D0BA4742-F782-44AC-A7A8-86E4C8E7ACEA@.microsoft.com...
>
|||I can’t explain it (yet) and it may just be coincidence but I was testing
connections to the database in the ODBC Data Source Administrator and created
a connection using the sqlsrv33 driver and then the sqlncli driver and now
all my local connections work and the processes run fine. One thing is the
default value for the pipe name came up incorrectly. I corrected the pipe
there and the test connection worked. It doesn’t make sense to me that this
value would be persisted anywhere and that this fixed the problem. Anyway it
is working now and we’ll see for how long. If anyone has a valid explanation
on if this is just a coincidence or if it actually corrected the issue,
please share. Thx.
"Wes" wrote:
[vbcol=seagreen]
> Rick,
> Thx for the reply.
> 1. Q:Did the server forget it's name?
> -- Running the supplied query returns the correct name of the server. So,
> this is okay.
> 2. Q:Is it still enabled on both the server and for client connections on
> the server?
> -- Yes. I disabled Shared Memory for both the client & server and tried
> again to connect and still recieve the message " Cannot connect to {database
> name}. 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: 25 - Connection string is not
> valid) (Microsoft SQL Server, Error: 87)"
> *note: I have no problem connecting remotely. However - I do have a
> problem connection locally and the services all throw similar errors when
> trying to connect to the database. Also, I cannot apply any service packs
> because I can not authenticate locally.
> "Rick Byham, (MSFT)" wrote:
|||When you connect locally by name, SQL Server Native Client uses shared
memory. And shared memory is a local pipe. So when you fixed something in
named pipes, it does make sense that it might have fixed shared memory.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wes" <Wes@.discussions.microsoft.com> wrote in message
news:4D86C15C-5B9D-4DEB-B61B-FF392985D5B1@.microsoft.com...[vbcol=seagreen]
>I can’t explain it (yet) and it may just be coincidence but I was testing
> connections to the database in the ODBC Data Source Administrator and
> created
> a connection using the sqlsrv33 driver and then the sqlncli driver and now
> all my local connections work and the processes run fine. One thing is
> the
> default value for the pipe name came up incorrectly. I corrected the pipe
> there and the test connection worked. It doesn’t make sense to me that
> this
> value would be persisted anywhere and that this fixed the problem. Anyway
> it
> is working now and we’ll see for how long. If anyone has a valid
> explanation
> on if this is just a coincidence or if it actually corrected the issue,
> please share. Thx.
> "Wes" wrote:

Friday, March 30, 2012

Problem in installing SQLSERVER2000 Developer Edition

Problem in Installing SQL Server 2000 Personal

Problem in getting SUM of Running Total Field

Monday, March 26, 2012

Problem in Configuring ASPState DB for .NET 2.0

Wednesday, March 21, 2012

Problem getting SQL Server 2000 EE to use more than 4GB of memory

Monday, March 12, 2012

Problem Deploying SSAS Connection cannot be made. Ensure server running

Problem deploying site developed with Sql Ex. To server running Sql Server 2005.

Friday, March 9, 2012

Problem deploying site developed with Sql Ex. To server running Sql Server 2005.

Problem Deleting Publications

Wednesday, March 7, 2012

Problem Creating Job and Running The JOb

Problem Creating Job and Running The JOb

Problem Creating Job and Running The JOb

Problem creating folder through package

Saturday, February 25, 2012

Problem creating database diagram

Monday, February 20, 2012

Problem Connecting to Sql Server 2005 locally by Name

connecting to SSAS

Blog Archive

About Me