connecting to SSAS: machine

Showing posts with label machine. 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

Monday, March 26, 2012

problem in connecting to SQL2005 on 64 bit machine

Hi,
I am using the following code to connect to SQL2005 database
ADODB::_ConnectionPtr m_pConnection;
m_pConnection. CreateInstance(__uuidof(ADODB::Connectio
n));
m_pConnection->open(Server=aron1;Driver={SQL
Server};database=master;"","",NULL)
if(m_pConnection->GetState() != ADODB::adStateOpen)
done
else
error.
it works fine with SQL2005(32 bit) installed on 32 bit windows XP
machine.
but when I try to connect to SQL2005(either 32bit or 64 bit) installed
on a 64 bit XP machine.it gives me an error
Provider is not specified and there is no designated default provider.
how can I solve this issue ?
Thanks in advance.Can you connect to the said SQL2005 instance with a tool such as Query
Analyzer or osql?
Linchi
"kk.simhadri@.gmail.com" wrote:

> Hi,
> I am using the following code to connect to SQL2005 database
> ADODB::_ConnectionPtr m_pConnection;
> m_pConnection. CreateInstance(__uuidof(ADODB::Connectio
n));
> m_pConnection->open(Server=aron1;Driver={SQL
> Server};database=master;"","",NULL)
> if(m_pConnection->GetState() != ADODB::adStateOpen)
> done
> else
> error.
> it works fine with SQL2005(32 bit) installed on 32 bit windows XP
> machine.
> but when I try to connect to SQL2005(either 32bit or 64 bit) installed
> on a 64 bit XP machine.it gives me an error
> Provider is not specified and there is no designated default provider.
> how can I solve this issue ?
> Thanks in advance.
>|||When you say that you are trying to connect to a 32 or 64 bit machine, you
don't say if you are trying to do this from this new machine or from the
first 32 bit machine; so it's hard to say if you have problem connecting to
a remote machine or if you have problem connecting to a 64 bit machine or
from a 64 bit environment. You don't even tell us if you are able to
connect with SSMS or SSMSE.
If you have problem connecting to a remote machine, make the usual check
about the firewall, the permissions on the remote machine and on the remote
SQL-Server and try using TCP instead of named pipes or the multi-protocol.
If you have problem connecting to a 64 bit machine, try using TCP instead of
named pipes or the multi-protocol.
If you have problem connecting from a 64 machine, first check if you are
running in the simulated 32 bit environment (WOW64) or in the 64 bit
environment. Many older protocols won't be able to run in the 64 bit
environment or to make calls to the 64 bit environment from WOW64. If it
cannot run from the 64 bit environment, use another protocol, if it cannot
make calls to the 64 bit environment, try using TCP instead of named pipes
or use another protocol such as the SQL Native Provider. More info and
troubleshooting:
http://www.connectionstrings.com/?carrier=sqlserver2005
http://blogs.msdn.com/sqlexpress/ar.../05/415084.aspx
http://blogs.msdn.com/sqlexpress/ar.../23/192044.aspx
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
http://www.datamasker.com/SSE2005_NetworkCfg.htm (connection strings for
sql providers)
For SSMSE:
http://www.microsoft.com/downloads/...B8-5A0F62BF7796
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
<kk.simhadri@.gmail.com> wrote in message
news:1175009603.109380.73620@.y80g2000hsf.googlegroups.com...
> Hi,
> I am using the following code to connect to SQL2005 database
> ADODB::_ConnectionPtr m_pConnection;
> m_pConnection. CreateInstance(__uuidof(ADODB::Connectio
n));
> m_pConnection->open(Server=aron1;Driver={SQL
> Server};database=master;"","",NULL)
> if(m_pConnection->GetState() != ADODB::adStateOpen)
> done
> else
> error.
> it works fine with SQL2005(32 bit) installed on 32 bit windows XP
> machine.
> but when I try to connect to SQL2005(either 32bit or 64 bit) installed
> on a 64 bit XP machine.it gives me an error
> Provider is not specified and there is no designated default provider.
> how can I solve this issue ?
> Thanks in advance.
>

problem in connecting to SQL2005 on 64 bit machine

Hi,
I am using the following code to connect to SQL2005 database
ADODB::_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
m_pConnection->open(Server=aron1;Driver={SQL
Server};database=master;"","",NULL)
if(m_pConnection->GetState() != ADODB::adStateOpen)
done
else
error.
it works fine with SQL2005(32 bit) installed on 32 bit windows XP
machine.
but when I try to connect to SQL2005(either 32bit or 64 bit) installed
on a 64 bit XP machine.it gives me an error
Provider is not specified and there is no designated default provider.
how can I solve this issue ?
Thanks in advance.Can you connect to the said SQL2005 instance with a tool such as Query
Analyzer or osql?
Linchi
"kk.simhadri@.gmail.com" wrote:
> Hi,
> I am using the following code to connect to SQL2005 database
> ADODB::_ConnectionPtr m_pConnection;
> m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
> m_pConnection->open(Server=aron1;Driver={SQL
> Server};database=master;"","",NULL)
> if(m_pConnection->GetState() != ADODB::adStateOpen)
> done
> else
> error.
> it works fine with SQL2005(32 bit) installed on 32 bit windows XP
> machine.
> but when I try to connect to SQL2005(either 32bit or 64 bit) installed
> on a 64 bit XP machine.it gives me an error
> Provider is not specified and there is no designated default provider.
> how can I solve this issue ?
> Thanks in advance.
>|||When you say that you are trying to connect to a 32 or 64 bit machine, you
don't say if you are trying to do this from this new machine or from the
first 32 bit machine; so it's hard to say if you have problem connecting to
a remote machine or if you have problem connecting to a 64 bit machine or
from a 64 bit environment. You don't even tell us if you are able to
connect with SSMS or SSMSE.
If you have problem connecting to a remote machine, make the usual check
about the firewall, the permissions on the remote machine and on the remote
SQL-Server and try using TCP instead of named pipes or the multi-protocol.
If you have problem connecting to a 64 bit machine, try using TCP instead of
named pipes or the multi-protocol.
If you have problem connecting from a 64 machine, first check if you are
running in the simulated 32 bit environment (WOW64) or in the 64 bit
environment. Many older protocols won't be able to run in the 64 bit
environment or to make calls to the 64 bit environment from WOW64. If it
cannot run from the 64 bit environment, use another protocol, if it cannot
make calls to the 64 bit environment, try using TCP instead of named pipes
or use another protocol such as the SQL Native Provider. More info and
troubleshooting:
http://www.connectionstrings.com/?carrier=sqlserver2005
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
http://www.datamasker.com/SSE2005_NetworkCfg.htm (connection strings for
sql providers)
For SSMSE:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
<kk.simhadri@.gmail.com> wrote in message
news:1175009603.109380.73620@.y80g2000hsf.googlegroups.com...
> Hi,
> I am using the following code to connect to SQL2005 database
> ADODB::_ConnectionPtr m_pConnection;
> m_pConnection.CreateInstance(__uuidof(ADODB::Connection));
> m_pConnection->open(Server=aron1;Driver={SQL
> Server};database=master;"","",NULL)
> if(m_pConnection->GetState() != ADODB::adStateOpen)
> done
> else
> error.
> it works fine with SQL2005(32 bit) installed on 32 bit windows XP
> machine.
> but when I try to connect to SQL2005(either 32bit or 64 bit) installed
> on a 64 bit XP machine.it gives me an error
> Provider is not specified and there is no designated default provider.
> how can I solve this issue ?
> Thanks in advance.
>

Problem in connecting after service pack 3a installed in MSDE 2000

Hi All,
I have installed MSDE 2000 server and i installed service pack
3a. The server machine has SQL Server 2000 client connectivity. When i
connect from client machine to Server machine it is showing error.
[Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
SQL Server does not exists or access denied.
I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
Any suggestion would be greatly appreciated.
Regards,
A.Chellam.How do you connect? Try specify the IP for the server/data source and see if
you
can connect.
-oj
http://www.rac4sql.net
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>|||Verify on the MSDE machine using Server Network Utility what netlibs it is
listening on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>

Friday, March 23, 2012

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem in browsing cube and dimension data

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem in accessing the database.. please help!

Hi There !!

CAn you please help me to solve my probelm and i will appreciate it if you help me. I installed SQL server on my machine and i installed tables in a database called "otters" when i run the application, i got an error message on the browser as shown below although in the application it says that it recognise the source of the dastabase. CAn you please help me to sort out tis problem and please try to look back to this thread after givingf me the soultion as it might not work and i need more assistant. I really, appreciate your help and thank you in advance. Please read the error message below
**************************************************

Server Error in '/Otters' Application.
------------------------

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:

Line 403: Dim conn As New SqlConnection(connStr)
Line 404: cmd.Connection = conn
Line 405: conn.Open()
Line 406:
Line 407: ' Allocate an empty array list to hold the performance objects found

Source File: C:\CSE506\Theater\Performance.vb Line: 405

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
Theater.Performance.Find(SqlCommand cmd) in C:\CSE506\Theater\Performance.vb:405
Theater.Performance.FindByDateRange(DateTime st, DateTime et) in C:\CSE506\Theater\Performance.vb:369
Otters.admin.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Otters\secure\admin.aspx.vb:67
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET

------------------------Show your connection string. Are you using integrated security?|||Hi Sir !!

Thank you for your message. T o be honest with you, I do not know how can i show the connection string or where would i find it and i do not know about the integrated security?....... :( i am very soooorry

I wish you can help me. I have a code that need to build a data base. I did install SQL Server and the database with all tables. when i run the application as you can see i had the error message. I wish if you can help me.

The material in the application is very important to me run as i am new in web development and .NET Framework. I am really grateful and will be more grateful if you can help as much as you can to sort this problem out.|||In this code:

Dim conn As New SqlConnection(connStr)

The string connStr is what you need to show (if there are usernames and passwords, just change them to USER and PASSWORD).|||Hi Mr Douglas.reilly !!

This is the code below, it does not have a password or user name. Can you please advice what to do. Thank you again and i look froward to hearing from you.

****************** Code ***********************************
' Write a new customer object out to the primary database, retrieving the
' newly allocated identity field. Should only be called from inside a
' constructor.

Private Function Insert() As Integer

' Copy the customer out to the table of customers.

Dim conn As New SqlConnection(connStr)
Dim cmd As New SqlCommand("INSERT INTO Customers (Name, Address, " _
& "Email) VALUES ( @.nm, @.ad, @.em);" _
& "SELECT ID FROM Customers WHERE (ID = SCOPE_IDENTITY())", conn)
cmd.Parameters.Add("@.nm", custName)
cmd.Parameters.Add("@.ad", custAddress)
cmd.Parameters.Add("@.em", custEmail)

' Now execute the insertion onto the primary table

conn.Open()
Dim identity As Integer = CType(cmd.ExecuteScalar(), Integer)
conn.Close()
Return identity

End Function|||SOMEPLACE in the code, connStr is set. Find out where it is. Or, if you are not using OPTION EXPLICIT, perhaps it is not ever set, and that would also explain the problem. In your code, connStr MUST be a valid connection string, as specified in the link I have previously posted. If you do not know what must be in that string, it is not really something anyone else can help with.|||Hi Mr Douglas!!

Thank you again for your message. I searched the whole file and i could not find it. It is very disappointed for me that you can help. I can attached the application with the datadase .sql files to see yourself and if you do not mind i can email it to you. I wish you will be able to help it is very important to me and please, do not let me down. I wish i do not embaress you or ask you for what you can not do.

I wish you will able to help and anything i will do to sort this problem out.|||Do a control-F and search for 'connStr'

if you can't find a place where it specifically assigns a connection string (the way your script 'connects' to the database), then it won't work any way - - you must connect to the database, in order to display or edit data.
it will look like:
connStr = "...your connection 'string' will be here..."

Problem in accessing the database(Sqlserver 2005) from client machine

We have upgraded sql server 2000 to sqlserver 2005 on the development server.

To access the database server, we installed the sql server management studio on the client PC with Admin Account. The .Net framework and sqlserver management studio were installed and I am able to access the database from the client PC using Admin Login. Then we logged off and tried to login as user account on the client PC. From the user account login we are unable to open the sql server management studio. The error is as follows

“The proper type library could not be found in system registry”

The client PC configuration : windows 2000 Professional ( sp4)

Regards,

K.S.Subba Rao

Hi K.S. Subba,

What is probably happening is the non-Admin user that you are logging on with does not have permissions to read the appropriate type library informations for SQL-specific COM components from registry. The fastest approach you can take to troubleshoot that is to use RegMon from http://www.microsoft.com/technet/sysinternals/SystemInformation/Regmon.mspx, find out which keys are "Access Denied" or "Not Found" and when logged as Admin, grant the permissions to those to the non-Admin user. As a lazy alternative you could try to grant permissions to the user to HKEY_LOCAL_MACHINE\SOFTWARE\Classes and all the subcomponents, but that might expose a security risk.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

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 discovering local SQL Server

I found that SMO sometimes does not return the correct list of available SQL servers.

1. I have SQL development installed in my machine. When I use SMO to retrieve list of server, it does not return anything. But when I use "OSQL -L" command, it returns (local) server.

This is my code.

Cursor.Current = Cursors.WaitCursor

cmbServerName.Items.Clear()

Dim dtSQLServers As DataTable = SmoApplication.EnumAvailableSqlServers()

Dim I As Integer

For I = 0 To dtSQLServers.Rows.Count - 1

Dim ServerName As String = dtSQLServers.Rows(I)("Server").ToString()

If (dtSQLServers.Rows(I)("Instance") IsNot Nothing And dtSQLServers.Rows(I)("Instance").ToString().Length > 0) Then

ServerName = ServerName + "\" + dtSQLServers.Rows(I)("Instance").ToString()

cmbServerName.Items.Add(ServerName)

End If

Next I

Cursor.Current = Cursors.Default

2. When I install SQL 2005 Express in any machine, I cannot retreive its existance via SMO with the same code (on local and remote machine).

Anyone experiencing this situation before? Is there something wrong in my code? How can I fix this?

Thank you,

Hi,

consider the differences with Server and InstanceName, I once wrote an Article about that:

http://sqlserver2005.de/Articles/1/

I saw that you wanted to add the data of ServerName to instance name which would be wrong in your case.

2. Is SQL Server brwoser running ? Otherwise it could be that instances running on other server can′t be retrieved if hosted on different ports.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Problem Deploying Subreports with Main Report

Hi All,

Here's my problem. I have an SSRS report with subreports on it. The main report and subreports work fine on my machine when I run the main report. However, when I deploy them to our test server and change the server name of the shared datasource, only the main report brings back data. The subreports show an error of something like "Error in displaying the subreport" for each subreport. The subreports require parameters that I believe I am supplying from the main report. What am I doing wrong? Is it really necessary to deploy the subreports with the main report to the new server. With Crystal Reports, I didn't have to do this. Any thoughts or suggestions would be appreciated.

Are you sure that the subreports are using the shared datasource? Can you run any of the subreports by themself?

|||

SteffoS,

Thanks for replying. Yes, I can run the subreports individually and get data. Thanks again. Any other suggestions?

|||

Hi All,

I found the answer to my problem. When I right clicked on the subreport and chose properties then went to the parameters tab, I chose the Fields.fieldName.Value for the the value of my parameter. This is incorrect. What I needed to do and did was choose the <expression> item in the dropdown box then click on parameters and choose the correct parameter from the main report to be the value for the parameters in my subreport. Worked like a charm, but I'm not getting too excited. I've read too much that things just started working for people and they could not explain why. That's scary too. Thanks.

Problem Deploying Subreports with Main Report

Hi All,

Are you sure that the subreports are using the shared datasource? Can you run any of the subreports by themself?

|||

SteffoS,

Thanks for replying. Yes, I can run the subreports individually and get data. Thanks again. Any other suggestions?

|||

Hi All,

Friday, March 9, 2012

Problem Deploying Reports when using SSL

Here is my current setup. I have Report Services sp1 installed on a Windows
2000 machine with SQL Server 2000. We have successfully configured RS to
produce reports over the internet via SSL. The actual viewing of the report
over the internet works great. However, in Visual Studio I receive the
following error when trying to deploy the reports...
"The underlying connection was closed. Could not establish trust
relationship with remote server"
The only work around I have found so far is to modify the
rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
Then I am able to deploy the reports and do not receive this message.
Because SSL is a must, I then have to change the secureconnectionlevel= back
to 2.
Users externally are accessing the report server via
http://FQDN/reportserver. I had gone into the rswebapplication.config file
and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl> to
<ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck. My
certificate name uses the FQDN as the site name.
My question is why I am not able to deploy my reports when the SSL is turned
on?
I hope this makes sense and I am sure I left something out. Please let me
know your thoughts. Thanks!Sounds like you're hitting the issue in this KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;823177. Are you
specifying the FQDN in VS when deploying the reports?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:B42B3849-C5FA-45AB-AEDA-D769D49ED57D@.microsoft.com...
> Here is my current setup. I have Report Services sp1 installed on a
> Windows
> 2000 machine with SQL Server 2000. We have successfully configured RS to
> produce reports over the internet via SSL. The actual viewing of the
> report
> over the internet works great. However, in Visual Studio I receive the
> following error when trying to deploy the reports...
> "The underlying connection was closed. Could not establish trust
> relationship with remote server"
> The only work around I have found so far is to modify the
> rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
> Then I am able to deploy the reports and do not receive this message.
> Because SSL is a must, I then have to change the secureconnectionlevel=> back
> to 2.
> Users externally are accessing the report server via
> http://FQDN/reportserver. I had gone into the rswebapplication.config
> file
> and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl>
> to
> <ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck.
> My
> certificate name uses the FQDN as the site name.
> My question is why I am not able to deploy my reports when the SSL is
> turned
> on?
> I hope this makes sense and I am sure I left something out. Please let me
> know your thoughts. Thanks!
>

Problem deploying Custom Report Item

Hello,

I am having a problem with deploying a CRI.

On my local machine the CRI works fine, only at the development machine it doens't works.

I did the following steps:

copy the .dll to the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

copy the .dll to the C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin

put this code in rsreportserver.config:

</ReportItems>

put this code in rssrvpolicy.config:

<CodeGroup

class="UnionCodeGroup"

Version="1"

PermissionSetName="FullTrust"

Name="BusinessConnectCodeGroup"

Description="Code group for the Business connect diagrammer">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1"

PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010051C346CB2A79947C83804E550CF1561729DB2B5C7DEFF93758E419F16390A295DF4906ADD8FD9A29559D5E3C8BFA73D8D21B64724B1B0E688091C1541FD54D5290D6968C73E9ACA842B1E42AB3DE369F7B545933C8E101A737BB7D22F937921E7F02E00C5121D1DC312DBE96154E5A4E47BD7F489A655A09CF08EABCFB6AB7C1"

</CodeGroup>

put this code in rsreportdesigner.config

</ReportItems>

</ReportItemDesigner

I get the following error message:

Could not load file or assembly 'ReportingServicesWebServer,

Also when i stop Reporting Services it won't start again. I get a timeout.

Hi,

I am also getting the same error. Even my Report manager is not working.

But, as i was digging thru, I was able to get it working by doing some changes in the Encryption Keys options in the Report Server Configuration manager. But it stopped again by giving some security exception for the CRi assembly.

Can u tell me, how you got the PublicKeyBlob value in rssrvpolicy.config file?

Thanks,

Monday, February 20, 2012

Problem connecting using Windows XP Professional

Greetings,

I installed SQL Express 2005 on my machine with XP Professional. My machine name is ROBERT and my user name is Rob. I did not get asked during the installation to supply an administrator password.

Following the installation when I try to connect using a C# app and setting IntegratedSecurity to true I get told that ROBERT\Rob is not authorised to connect to the database (paraphrased as I do not have the exact error message with me).

How do I go about adding my user name to the database if I do not know what the "sa" password is ?

Thanks,

Robert

Hi Robert...you are having trouble with your Windows user most likely because you are not a valid user on the server as of yet...by default, the only valid users on the server are members of the BUILTIN\Administrators group and the SQL service account(s) and the sa (if appropriate).

If you don't know the sa password, you'll have to get somebody who is either a member of the Administrators group or who knows the SQL service account password(s) to login and add your windows user as a valid server login and provide the appropriate permissions to the appropriate database(s).

Look for the following commands in SQL Books Online for more help there:

CREATE LOGIN...

CREATE USER...

HTH,

Problem connecting to SQL Server via Query Analyzer

Hi there, I see this thread is back from 2004. I am having an issue connecting to a sql server located on another machine on my Intranet. I recieve the following error:
unable to connect to server ...
server: Msg 17, Level 16, State 1
Microsoft odbc sql server driver odbnetlib sql server does not exit or access
I tried to connect to other sql servers, and I got no problem, except for this particular server. any ideas?
From http://www.developmentnow.com/g/118_2004_1_0_0_468284/Problem-connecting-to-SQL-Server-via-Query-Analyzer.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
1. Server does exist (server name spellign corrcet)?
2. You sure you have permission to access it?
3. Network library compatible?
"Efrain Juarez" <stranger_tepa@.hotmail.com> wrote in message
news:1bf20371-0394-4c54-a975-764a23b202d5@.developmentnow.com...
> Hi there, I see this thread is back from 2004. I am having an issue
> connecting to a sql server located on another machine on my Intranet. I
> recieve the following error:
> unable to connect to server ...
> server: Msg 17, Level 16, State 1
> Microsoft odbc sql server driver odbnetlib sql server does not exit or
> access
> I tried to connect to other sql servers, and I got no problem, except for
> this particular server. any ideas?
> From
> http://www.developmentnow.com/g/118_2004_1_0_0_468284/Problem-connecting-to-SQL-Server-via-Query-Analyzer.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

Problem connecting to SQL Server 2006 Express

I have been trying literally for months to get SQL Server 2005 Express to work on my Dell Dimension WinXPPro machine. I have installed and reinstalled both the server and the 'Management System'. I have shut down and restarted all of the related Local Component Services on my machine (with the exception of the SQL Server Active Directory Helper which will not start ?).

I have reviewed much of what is in this Forum related to SQL Server 2005 Express and I find that many have had similar problems. When a connection is attempted, the following message or some minor variation appears:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

In desparation, and at the suggestion of one of this forum's moderators, I went to try to download the SQL Server 2005 Express, Service Pack 2. I threaded my way through what I felt was an unecessarily complex set of links and finally reached a download site - but it was unclear whether or not the service pack was for SQL Server 2005 or the Express version. Giving up in dispair, it turn to you (once again BTW, I received no real help with this same question about a month ago).

Even though I seriously doubt if anyone will help me, I am willing to give it another try - mainly because I am home sick with the flu and having nothing better to do on a Sunday afternoon.

Thanks

Hi,

the SQL Server Express Edition are already slipstreamed with the Service pack. So doenloading the SP2 for SQL Server Express will automatically bring you to the current SP level. it would be helpful to see with which application you tried to connect (and the connectionstring if you use one). Make also sure to enable remote connections which is disabled by default. See the Screencast on my site for more information about this.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

General E Pist wrote:
<font size="2">I have been trying literally for months to get SQL Server 2005 Express to work on my Dell Dimension WinXPPro machine. I have installed and reinstalled both the server and the 'Management System'. I have shut down and restarted all of the related Local Component Services on my machine (with the exception of the SQL Server Active Directory Helper which will not start ?).</font>
I have reviewed much of what is in this Forum related to SQL Server 2005 Express and I find that many have had similar problems. When a connection is attempted, the following message or some minor variation appears:
<blockquote><table width="85%"><tbody><tr><td class="quoteTable"><table width="100%"><tbody><tr><td class="txt4" valign="top" width="100%"><br>An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)<br></td></tr></tbody></table></td></tr></tbody></table></blockquote>
In desparation, and at the suggestion of one of this forum's moderators, I went to try to download the SQL Server 2005 Express, Service Pack 2. I threaded my way through what I felt was an unecessarily complex set of links and finally reached a download site - but it was unclear whether or not the service pack was for SQL Server 2005 or the Express version. Giving up in dispair, it turn to you (once again BTW, I received no real help with this same question about a month ago).
Even though I seriously doubt if anyone will help me, I am willing to give it another try - mainly because I am home sick with the flu and having nothing better to do on a Sunday afternoon.
Thanks

I have found this same problem. I am trying to connect across a workgroup LAN, one PC W2kPro, One WinXPPro. I have now tried installing SQLExpress on both PCs. I have MS-SM Studio Express on both PCs. I still cannot connect to the WinXP machine from the W2K machine. Even the sseutil command line utility will not find the server running on the XP box when I use the -listsrv remote params. I disconnected from the internet, and turned off all firewalls, and still no conection. Tried IP address with Port, and still no joy. I was using the sa login and the correct password. I uninstalled SQLExpress, and re-installed. No good! The one thing that may be a problem, is that I have SQL 2000 Developer installed on both machines, but it is stopped. Using Studio Express on the XP box, I can connect to the local SQL Express and to the remote one on the W2K box. But what will it take to get a connection from the W2K box to the XP Box?|||Please post the error message you are getting. if you are in a workgroup you cannot use Windows authenntication, make sure you are using SQL Server authentication for connecting. Did you start SQL Browser on the computer in order to find the instances using -listsrv ? Did you also enabled remote connection ? You can find a screencast on my site how to enable it.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Jens K. Suessmeyer wrote:
Please post the error message you are getting. if you are in a workgroup you cannot use Windows authenntication, make sure you are using SQL Server authentication for connecting. Did you start SQL Browser on the computer in order to find the instances using -listsrv ? Did you also enabled remote connection ? You can find a screencast on my site how to enable it.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de

The error msg I get is..

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

I am using the sa login and password.
SQL Browser is running (have stopped and started it several times) on both PCs.
SQL Express is set to mixed mode authentication.
SQL Express was installed with the DISABLENETWORKPROTOCOLS=0 setting and all are showing enabled.

I have set the connection timout up to 40 seconds, from the default 15, just in case that helped.

I have been at this for about 12 hours today, and did get a connection once, about 15 minutes ago. But now when I try and re-connect, I am back where I was this morning. Time for bed now, try again tomorrow.. :-( Maybe rebooting both PCs again may help.

I will have a look at your screencast in case I have missed something.

Thanks
John G|||On rebooting both PCs this morning, I am now able to reliable connect and re-connect between the two PCs on the workgroup LAN.

I looked at Jen's Screencast and when I checked all my configuration items, they were already set to correct values.

I still do not know what the problem was yesterday, but thanks to the pointers from Jens and others, it all now works as expected.

Next time, I shall remember to try several reboots.

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

Monday, March 26, 2012

problem in connecting to SQL2005 on 64 bit machine

problem in connecting to SQL2005 on 64 bit machine

problem in connecting to SQL2005 on 64 bit machine

Problem in connecting after service pack 3a installed in MSDE 2000

Friday, March 23, 2012

Problem in browsing cube and dimension data

Problem in browsing cube and dimension data

Problem in accessing the database.. please help!

Problem in accessing the database(Sqlserver 2005) from client machine

Wednesday, March 21, 2012

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

Monday, March 12, 2012

Problem discovering local SQL Server

Problem Deploying Subreports with Main Report

Problem Deploying Subreports with Main Report

Friday, March 9, 2012

Problem Deploying Reports when using SSL

Problem deploying Custom Report Item

Monday, February 20, 2012

Problem connecting using Windows XP Professional

Problem connecting to SQL Server via Query Analyzer

Problem connecting to SQL Server 2006 Express

Problem Connecting to Sql Server 2005 locally by Name

connecting to SSAS

Blog Archive

About Me