When i tried to install a virtue sql server on just one node(the other was
evicted and shutdown), i also encountered the same errors just as before.
So i'm confused.
I have read a lot of docs about sql cluster, and most of them told me that
it's simple to install sql cluster after the mscs and msdtc r installed.
hp proliant dl580+ raid array 4100 / 2 xeon cpus(so the hypethreading may
appear 4 cups and i have tried 2-cpu licence and 4-cpu licence, both fails)
win2k ad
Thanks
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> д?
news:6kS2Lo%23REHA.2260@.cpmsftngxa10.phx.gbl...
> There should be other sqlstp.logs on the systems. Possibly SQLstp0.log.
> Each node should have one. If you can post these we can get a better idea
> of what went wrong.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
"Sanjoy Wong" <sanjoy@.sinolines.com> д?
news:uEqMA4JSEHA.628@.TK2MSFTNGP11.phx.gbl...
> When i tried to install a virtue sql server on just one node(the other was
> evicted and shutdown), i also encountered the same errors just as before.
> So i'm confused.
> I have read a lot of docs about sql cluster, and most of them told me that
> it's simple to install sql cluster after the mscs and msdtc r installed.
> hp proliant dl580+ raid array 4100 / 2 xeon cpus(so the hypethreading may
> appear 4 cups and i have tried 2-cpu licence and 4-cpu licence, both
fails)[vbcol=seagreen]
> win2k ad
>
> Thanks
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> д?
> news:6kS2Lo%23REHA.2260@.cpmsftngxa10.phx.gbl...
idea[vbcol=seagreen]
rights.
>
begin 666 sqlstp.log
M,C Z,3 Z,3<@.0F5G:6X@.4V5T=7 -"C(P.C$P.C$W(#@.N,# N,3DT#0HR,#HQ
M,#HQ-R!-;V1E(#T@.3F]R;6%L#0HR,#HQ,#HQ-R!-;V1E5'EP92 ]($Y/4DU!
M3 T*,C Z,3 Z,3@.@.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'@.P#0HR,#HQ,#HQ."!686QU94944R!R971U<FYE9 #H@.,0T*,C Z
M,3 Z,3@.@.5F%L=650240@.<F5T=7)N960Z(#$-"C(P.C$P.C$X(%9A;'5E3&EC
M(')E='5R;F5D.B Q#0HR,#HQ,#HQ."!3>7-T96TZ(%=I;F1O=W,@.3E0@.16YT
M97)P<FES92!397)V97(-"C(P.C$P.C$X(%-13"!397)V97(@.4')O9'5C=%1Y
M<&4Z($5N=&5R<')I<V4@.161I=&EO;B!;,'@.S70T*,C Z,3 Z,3@.@.27-.5$-L
M=7-T97(@.<F5T=7)N960Z(#$-"C(P.C$P.C$X($)E9VEN($%C=&EO;CH@.4V5T
M=7!);FET:6%L:7IE( T*,C Z,3 Z,3@.@.16YD($%C=&EO;B!3971U<$EN:71I
M86QI>F4-"C(P.C$P.C$X($)E9VEN($%C=&EO;CH@.(%-E='5P26YS=&%L; T*
M,C Z,3 Z,3@.@.4F5A9&EN9R!3;V9T=V%R95Q-:6-R;W-O9G1<5VEN9&]W<UQ#
M=7)R96YT5F5R<VEO;EQ#;VUM;VY&:6QE<T1I<B N+BX-"C(P.C$P.C$X($-O
M;6UO;D9I;&5S1&ER/4,Z7%!R;V=R86T@.1FEL97-<0V]M;6]N($9I;&5S#0HR
M,#HQ,#HQ."!7:6YD;W=S($1I<F5C=&]R>3U#.EQ724Y.5%P-"C(P.C$P.C$X
M(%!R;V=R86T@.1FEL97,]0SI<4')O9W)A;2!&:6QE<UP-"C(P.C$P.C$X(%1%
M35!$25(]0SI<5TE.3E1<5$5-4%P-"C(P.C$P.C$X($)E9VEN($%C=&EO;CH@.
M(%-E='5P26YS=&%L; T*,C Z,3 Z,3@.@.9&EG<&ED('-I>F4@..B R-38-"C(P
M.C$P.C$X(&1I9W!I9"!S:7IE(#H@.,38T#0HR,#HQ,#HQ."!"9 6=I;B!!8W1I
M;VXZ("!#:&5C:T9I>&5D4F5Q=6ER96UE;G1S#0HR,#HQ,#HQ. "!0;&%T9F]R
M;2!)1#H@.,'AF,# P,# -"C(P.C$P.C$X(%9E<G-I;VXZ(#4N,"XR,3DU#0HR
M,#HQ,#HQ."!&:6QE(%9E<G-I;VX@.+2!#.EQ724Y.5%QS>7-T96TS,EQS:&1O
M8W9W+F1L;#H@.-2XP+C,W,# N-C8V. T*,C Z,3 Z,3@.@.16YD($%C=&EO;CH@.
M($-H96-K1FEX961297%U:7)E;65N=',-"C(P.C$P.C$X($)E9VEN($%C=&EO
M;CH@.(%-H;W=$:6%L;V=S#0HR,#HQ,#HQ."!);FET:6%L($1I86QO9R!-87-K
M.B P>#$X,S P,&8W+"!$:7-A8FQE($)A8VL],'@.Q#0HR,#HQ,#HQ."!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$-"C(P.C$P.C$X($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39%=E;&-O;64-"C(P.C$P.C$Y($5N9"!!
M8W1I;VX@.($1I86QO9U-H;W=39%=E;&-O;64-"C(P.C$P.C$Y($1I86QO9R P
M>#$@.<F5T=7)N960Z(#$-"C(P.C$P.C$Y($5N9"!!8W1I;VX@.4VAO=T1I86QO
M9W-(;'!R#0HR,#HQ,#HQ.2!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE
M9#H@.;D-U<G)E;G0],'@.R+&EN9&5X/3$-"C(P.C$P.C$Y($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,@.T*,C Z,3 Z,3D@.0F5G:6X@.06-T:6]N
M.B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C(P.C$P.C(V(%-H;W=$;&=-
M86-H:6YE(')E='5R;F5D.B Q#0HR,#HQ,#HR-B!.86UE(#T@.4U%,5$535"P@.
M5'EP92 ](#!X,3 P,# P,#@.-"C(P.C$P.C(V($)E9VEN($%C=&EO;CH@.($-H
M96-K4F5Q=6ER96UE;G1S#0HR,#HQ,#HR-B!0<F]C97-S;W(@.07)C:&ET96-T
M=7)E.B!X.#8@.*%!E;G1I=6TI#0HR,#HQ,#HR-B!397)V:6-E(%!A8VLZ(" Q
M,#(T#0HR,#HQ,#HR-B!#;VUP=71E<DYA;64Z($$-"C(P.C$P.C(V(%5S97(@.
M3F%M93H@.061M:6YI<W1R871O<@.T*,C Z,3 Z,C8@.27-!;&Q!8V-E<W-!;&QO
M=V5D(')E='5R;F5D.B Q#0HR,#HQ,#HR-B!/4R!,86YG=6%G93H@.,'@.X,#0-
M"C(P.C$P.C(V($5N9"!!8W1I;VX@.0VAE8VM297%U:7)E;65N= ',-"C(P.C$P
M.C(V(%1H:7,@.8V]M8FEN871I;VX@.;V8@.4&%C:V%G92!A;F0@.3W!E<F%T:6YG
M(%-Y<W1E;2!A;&QO=W,@.82!F=6QL('!R;V1U8W0@.:6YS=&%L;"X-"C(P.C$P
M.C(V($5N9"!!8W1I;VX@.($1I86QO9U-H;W=39$UA8VAI;F5.86UE#0HR,#HQ
M,#HR-B!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$P.C(V(&Y&
M=6QL36%S:R ](#!X,3@.S,# P9C<L(&Y#=7)R96YT(#T@.,'@.R+"!N1&ER96-T
M:6]N(#T@., T*,C Z,3 Z,C8@.57!D871E9"!$:6%L;V<@.36%S:SH@.,'AB9C-C
M,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C(P.C$P.C(V($1I86QO9R P>#(@.
M<F5T=7)N960Z(# -"C(P.C$P.C(V($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(
M;'!R#0HR,#HQ,#HR-B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.
M;D-U<G)E;G0],'@.T+&EN9&5X/3(-"C(P.C$P.C(V($)E9VEN($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(Z(#!X- T*,C Z,3 Z,C8@.0F5G:6X@.06-T:6]N.B @.
M1&EA;&]G4VAO=U-D26YS=&%L;$UO9&4-"C(P.C$P.C(V($EN<W1A;&Q-;V1E
M(#H@.,'@.Q#0HR,#HQ,#HR-B!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T
M86QL36]D90T*,C Z,3 Z,C8@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K
M#0HR,#HQ,#HR-B!N1G5L;$UA<VL@./2 P>&)F,V,P,S<L(&Y#=7)R96YT(#T@.
M,'@.T+"!N1&ER96-T:6]N(#T@.,0T*,C Z,3 Z,C8@.57!D871E9"!$:6%L;V<@.
M36%S:SH@.,'@.Q8F8W8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HR,#HQ,#HR
M-B!$:6%L;V<@.,'@.T(')E='5R;F5D.B Q#0HR,#HQ,#HR-B!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,C Z,3 Z,C8@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 L:6YD97@.]- T*,C Z,3 Z,C8@.
M0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q, T*,C Z,3 Z,C8@.
M0F5G:6X@.06-T:6]N.B @.1&EA;&]G4VAO=U-D4F5G:7-T97)5<V5R17@.-"C(P
M.C$P.C(W($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D4F5G:7-T97)5<V5R17@.-
M"C(P.C$P.C(W(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,C Z,3 Z
M,C<@.;D9U;&Q-87-K(#T@.,'@.Q8F8W8S S-RP@.;D-U<G)E;G0@./2 P>#$P+"!N
M1&ER96-T:6]N(#T@.,0T*,C Z,3 Z,C<@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F8W8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HR,#HQ,#HR-R!$:6%L
M;V<@.,'@.Q,"!R971U<FYE9#H@.,0T*,C Z,3 Z,C<@.16YD($%C=&EO;B!3:&]W
M1&EA;&]G<TAL<'(-"C(P.C$P.C(W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E
M='5R;F5D.B!N0W5R<F5N=#TP>#(P+&EN9&5X/34-"C(P.C$P.C(W($)E9VEN
M($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C -"C(P.C$P.C(W($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39$QI8V5N<V4-"C(P.C$P.C(X($5N9"!!
M8W1I;VX@.1&EA;&]G4VAO=U-D3&EC96YS90T*,C Z,3 Z,C@.@.1&EA;&]G(#!X
M,C @.<F5T=7)N960Z(#$-"C(P.C$P.C(X($5N9"!!8W1I;VX@.4VAO=T1I86QO
M9W-(;'!R#0HR,#HQ,#HR."!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE
M9#H@.;D-U<G)E;G0],'@.T,# P+&EN9&5X/3$T#0HR,#HQ,#HR."!"96=I;B!!
M8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#0P,# -"C(P.C$P.C(X($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39%9I<G1U86Q397)V97(-"C(P.C$P.C0W
M(%-H;W=$;&=6:7)T=6%L4V5R=F5R(')E='5R;F5D.B P#0HR,#HQ,#HT-R!)
M<&%D9')E<W,@./2 Q.3(N,38X+C N,C$P+#(U-2XR-34N,C4U+C L<'5B;&EC
M#0HR,#HQ,#HT-R!S>DYE=TQI<W0@./2 Q.3(N,38X+C N,C$P+#(U-2XR-34N
M,C4U+C L<'5B;&EC#0HR,#HQ,#HT-R!S>DUO9&EF:65D3&ES=" ]( T*,C Z
M,3 Z-#<@.<WI296UO=F5D3&ES=" ]( T*,C Z,3 Z-#<@.16YD($%C=&EO;B @.
M1&EA;&]G4VAO=U-D5FER='5A;%-E<G9E<@.T*,C Z,3 Z-#<@.8F5G:6X@.4VAO
M=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,#HT-R!N1G5L;$UA<VL@./2 P>#%B
M9C=C,#,W+"!N0W5R<F5N=" ](#!X-# P,"P@.;D1I<F5C=&EO;B ](#$-"C(P
M.C$P.C0W(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)F-V,P,S<L($1I<V%B
M;&4@.0F%C:R ](#!X,0T*,C Z,3 Z-#<@.1&EA;&]G(#!X-# P,"!R971U<FYE
M9#H@.,0T*,C Z,3 Z-#<@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C(P
M.C$P.C0W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N
M=#TP>#@.P,# L:6YD97@.],34-"C(P.C$P.C0W($)E9VEN($%C=&EO;B!3:&]W
M1&EA;&]G<TAL<'(Z(#!X.# P, T*,C Z,3 Z-#<@.0F5G:6X@.06-T:6]N(#H@.
M($1I86QO9U-H;W=39$1I<VM'<F]U<',-"C(P.C$P.C4P(%-H;W=$;&=$:7-K
M1W)O=7!S(')E='5R;F5D.B Q#0HR,#HQ,#HU,"!$:7-K($=R;W5P(#T@.1&ES
M:R!'<F]U<" Q#0HR,#HQ,#HU,"!%;F0@.06-T:6]N(#H@.($1I86QO9U-H;W=3
M9$1I<VM'<F]U<',-"C(P.C$P.C4P(&)E9VEN(%-H;W=$:6%L;V=S57!D871E
M36%S:PT*,C Z,3 Z-3 @.;D9U;&Q-87-K(#T@.,'@.Q8F8W8S S-RP@.;D-U<G)E
M;G0@./2 P>#@.P,# L(&Y$:7)E8W1I;VX@./2 Q#0HR,#HQ,#HU,"!5<&1A=&5D
M($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-
M"C(P.C$P.C4P($1I86QO9R P>#@.P,# @.<F5T=7)N960Z(#$-"C(P.C$P.C4P
M($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HR,#HQ,#HU,"!3:&]W1&EA
M;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.Q,# P,"QI;F1E
M>#TQ-@.T*,C Z,3 Z-3 @.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.
M,'@.Q,# P, T*,C Z,3 Z-3 @.0F5G:6X@.06-T:6]N.B @.1&EA;&]G4VAO=U-D
M0VQU<W1E<D1E9@.T*,C Z,3 Z-3$@.4VAO=T1L9T-L=7-T97)$968@.<F5T=7)N
M960Z(#$-"C(P.C$P.C4Q(%!R969/=VYE<G,@./2!!+"!.=6U)<" ](#$-"C(P
M.C$P.C4Q($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C(P
M.C$P.C4Q($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C(P
M.C$P.C4Q($5N9"!!8W1I;VX@..B!686QI9&%T94YO9&5!8W1I; VYS#0HR,#HQ
M,#HU,2!%;F0@.06-T:6]N(#H@.5F%L:61A=&5.;V1E06-T:6]N<PT*,C Z,3 Z
M-3$@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQU<W1E<D1E9@.T*,C Z,3 Z
M-3$@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,#HU,2!N1G5L
M;$UA<VL@./2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 P,# L(&Y$:7)E
M8W1I;VX@./2 Q#0HR,#HQ,#HU,2!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B
M9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C(P.C$P.C4Q($1I86QO9R P
M>#$P,# P(')E='5R;F5D.B Q#0HR,#HQ,#HU,2!%;F0@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<@.T*,C Z,3 Z-3$@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T
M=7)N960Z(&Y#=7)R96YT/3!X,C P,# L:6YD97@.],3<-"C(P.C$P.C4Q($)E
M9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# -"C(P.C$P.C4Q
M($)E9VEN($%C=&EO;B Z($-L=7-T97(@.4V5C=7)I='D@.+2!$;&=!8V-T#0HR
M,#HQ,3HP,B!3:&]W1&QG06-C="!R971U<FYE9#H@.,0T*,C Z,3$Z,#(@.6T1L
M9T%C8V]U;G1=#0HR,#HQ,3HP,B!$;VUA:6X@./2!324Y/3$E.15,-"C(P.C$Q
M.C R($1O;6%I;D%C8W0@./2!C;'5S=&5R#0HR,#HQ,3HP,B!$;VUA:6Y0=V0-
M"C(P.C$Q.C R(%)E<W5L=" ](#$-"C(P.C$Q.C R($5N9"!!8W1I;VX@..B!#
M;'5S=&5R(%-E8W5R:71Y("T@.1&QG06-C= T*,C Z,3$Z,#(@.8F5G:6X@.4VAO
M=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,3HP,B!N1G5L;$UA<VL@./2 P>#%B
M9C=C,#,W+"!N0W5R<F5N=" ](#!X,C P,# L(&Y$:7)E8W1I;VX@./2 Q#0HR
M,#HQ,3HP,B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A
M8FQE($)A8VL@./2 P>#$-"C(P.C$Q.C R($1I86QO9R P>#(P,# P(')E='5R
M;F5D.B Q#0HR,#HQ,3HP,B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*
M,C Z,3$Z,#(@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R
M96YT/3!X-# P,# L:6YD97@.],3@.-"C(P.C$Q.C R($)E9VEN($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C(P.C$Q.C R($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,C Z,3$Z,#(@.1&ES<&QA>5-Y<W1E
M;5!R95)E<0T*,C Z,3$Z,#(@.4VAO=T1L9T-L:65N=%-E<G9E<E-E;&5C="!R
M971U<FYE9#H@.,0T*,C Z,3$Z,#(@.5'EP92 Z(#!X,@.T*,C Z,3$Z,#(@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R#0HR,#HQ,3HP,B!B96=I;B!3
M:&]W1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$Q.C R(&Y&=6QL36%S:R ](#!X
M,6)F-V,P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,"P@.;D1I<F5C=&EO;B ](#$-
M"C(P.C$Q.C R(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)F9F,P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z,#(@.1&EA;&]G(#!X-# P,# @.<F5T
M=7)N960Z(#$-"C(P.C$Q.C R($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HR,#HQ,3HP,B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.X,# P,"QI;F1E>#TQ.0T*,C Z,3$Z,#(@.0F5G:6X@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X,# P, T*,C Z,3$Z,#(@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D26YS=&%N8V5.86UE#0HR,#HQ,3HP,B!"96=I
M;B!!8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C(P.C$Q.C S($5N9"!!
M8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C(P.C$Q.C S(%-H;W=$;&=)
M;G-T86YC94YA;64@.<F5T=7)N960@..B Q#0HR,#HQ,3HP,R!);G-T86YC94YA
M;64@..B!-4U-13%-%4E9%4@.T*,C Z,3$Z,#8@.0W)E871E4V5T=7!4;W!O;&]G
M>2A344Q415-4*2P@.2&%N9&QE(#H@.,'@.Q.3@.T,&8P+"!R971U<FYE9" Z(# -
M"C(P.C$Q.C V($-R96%T95-E='5P5&]P;VQO9WD@.<F5T=7)N960@..B P+"!(
M86YD;&4@..B P>#$Y.#0P9C -"C(P.C$Q.C V(%1O<&]L;V=Y(%1Y<&4@..B S
M-"P@.4F5T=7)N(%9A;'5E(#H@., T*,C Z,3$Z,#8@.4U1?1V5T4&AY<VEC86Q.
M;V1E(')E='5R;F5D(#H@.,"P@.4$Y(86YD;&4@..B P>#$Y.#0Q,3@.-"C(P.C$Q
M.C V(%!.7T5N=6UE<F%T945X(')E='5R;F5D(#H@., T*,C Z,3$Z,#8@.4$Y?
M1V5T4U%,4W1A=&5S(')E='5R;F5D(#H@.,"P@.4W%L4W1A=&5S( #H@.,'@.P#0HR
M,#HQ,3HP-B!03E]3=&%R=%-C86X@.6S!X,3DX-#$Q.%T@.<F5T=7)N960@..B P
M#0HR,#HQ,3HP-B!03E]'971.97AT(%LP>#$Y.#0Q,3A=(')E='5R;F5D(#H@.
M,3@.L($AA;F1L93H@.6S!X,%T-"C(P.C$Q.C V($YO(&UO<F4@.:71E;7,@.:6X@.
M96YU;65R871I;VXN#0HR,#HQ,3HP-B!296QE87-E4V5T=7!4;W!O;&]G>0T*
M,C Z,3$Z,#8@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D26YS=&%N8V5.86UE
M#0HR,#HQ,3HP-B!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$Q
M.C V(&Y&=6QL36%S:R ](#!X,6)F9F,P,S<L(&Y#=7)R96YT(#T@.,'@.X,# P
M,"P@.;D1I<F5C=&EO;B ](#$-"C(P.C$Q.C V(%5P9&%T960@.1&EA;&]G($UA
M<VLZ(#!X,6)F9F,P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z,#8@.
M1&EA;&]G(#!X.# P,# @.<F5T=7)N960Z(#$-"C(P.C$Q.C V($5N9"!!8W1I
M;VX@.4VAO=T1I86QO9W-(;'!R#0HR,#HQ,3HP-B!3:&]W1&EA;&]G<T=E=$1I
M86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.Q,# P,# L:6YD97@.],C -"C(P
M.C$Q.C V($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P
M#0HR,#HQ,3HP-B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V13971U<%1Y
M<&4-"C(P.C$Q.C V($)E9VEN($%C=&EO;CH@.4V5T=7 @.5'EP90T*,C Z,3$Z
M,#<@.4U%,('!R;V=R86T@.9F]L9&5R.B!#.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R#0HR,#HQ,3HP-R!344P@.9&%T82!F;VQD97(Z(%HZ
M7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C(P.C$Q.C W
M(%=I;F1O=W,@.<WES=&5M(&9O;&1E<CH@.0SI<5TE.3E1<<WES= &5M,S)<#0HR
M,#HQ,3HP-R!0<F]G(')E<3H@.,S@.R,#4L($1A=&$@.<F5Q.B S-C4T-"P@.4WES
M(')E<3H@.,3DS-3<Y#0HR,#HQ,3HP-R!0<F]G(&%V86EL.B Q,C T,34U-BP@.
M1&%T82!A=F%I;#H@.,30R,3@.U,3DV+"!3>7,@.879A:6PZ(#$R, #0Q-34V#0HR
M,#HQ,3HP-R!0<F]G(')E<2!V<RX@.879A:6PL(#(S,3<X-"P@.,3(P-#$U-38-
M"C(P.C$Q.C W($1A=&$@.<F5Q('9S+B!A=F%I;"P@.,S8U-#0L(#$T,C$X-3$Y
M-@.T*,C Z,3$Z,#<@.4WES(')E<2!V<RX@.879A:6PL(#$Y,S4W.2P@.,3(P-#$U
M-38-"C(P.C$Q.C W($1I<W!L87E3>7-T96U0<F5297$-"C(P.C$Q.C W(%M3
M971U<%1Y<&5344Q=#0HR,#HQ,3HP-R!S>D1I<B ]($,Z7%!R;V=R86T@.1FEL
M97-<36EC<F]S;V9T(%-13"!397)V97(-"C(P.C$Q.C W('-Z1&ER(#T@.0SI<
M4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,C Z,3$Z,#<@.
M4F5S=6QT(#T@.,S Q#0HR,#HQ,3HP-R!S>D1A=&%$:7(@./2!:.EQ0<F]G<F%M
M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HR,#HQ,3HP-R!S>D1A=&%$
M:7(@./2!:.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HR
M,#HQ,3HP-R!%;F0@.06-T:6]N.B!3971U<"!4>7!E#0HR,#HQ,3HP-R!3971U
M<"!4>7!E.B!4>7!I8V%L("@.S,#$I#0HR,#HQ,3HP-R!%;F0@.06-T:6]N("!$
M:6%L;V=3:&]W4V13971U<%1Y<&4-"C(P.C$Q.C W(&)E9VEN(%-H;W=$:6%L
M;V=S57!D871E36%S:PT*,C Z,3$Z,#<@.;D9U;&Q-87-K(#T@.,'@.Q8F9F8S S
M-RP@.;D-U<G)E;G0@./2 P>#$P,# P,"P@.;D1I<F5C=&EO;B ](#,P,0T*,C Z
M,3$Z,#<@.57!D871E9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L
M92!"86-K(#T@.,'@.Q#0HR,#HQ,3HP-R!$:6%L;V<@.,'@.Q,# P,# @.<F5T=7)N
M960Z(#,P,0T*,C Z,3$Z,#<@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C(P.C$Q.C W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#0P,# P,"QI;F1E>#TR,@.T*,C Z,3$Z,#<@.0F5G:6X@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<CH@.,'@.T,# P,# -"C(P.C$Q.C W($)E9VEN($%C
M=&EO;CH@.($1L9U-E<G9I8V5S#0HR,#HQ,3HQ-R!3:&]W1&QG4V5R=FEC97,@.
M<F5T=7)N960Z(#$-"C(P.C$Q.C$W(%M$;&=397)V:6-E<UT-"C(P.C$Q.C$W
M($QO8V%L+41O;6%I;@.D](#8Q-C@.P#0HR,#HQ,3HQ-R!!=71O4W1A<G0)"3T@.
M, T*,C Z,3$Z,3<@.4U%,1&]M86EN"0D](%-)3D],24Y%4PT*,C Z,3$Z,3<@.
M4U%,1&]M86EN06-C= D](&-L=7-T97(-"C(P.C$Q.C$W(%-13$1O;6%I;E!W
M9 T*,C Z,3$Z,3<@.06=T1&]M86EN"0D](%-)3D],24Y%4PT*,C Z,3$Z,3<@.
M06=T1&]M86EN06-C= D](&-L=7-T97(-"C(P.C$Q.C$W($%G=$1O;6%I;E!W
M9 T*,C Z,3$Z,3<@.4F5S=6QT"3T@.,0T*,C Z,3$Z,3<@.16YD($%C=&EO;B!$
M;&=397)V:6-E<PT*,C Z,3$Z,3<@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-
M87-K#0HR,#HQ,3HQ-R!N1G5L;$UA<VL@./2 P>#%B9&9C,#,W+"!N0W5R<F5N
M=" ](#!X-# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,C Z,3$Z,3<@.57!D871E
M9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q
M#0HR,#HQ,3HQ-R!$:6%L;V<@.,'@.T,# P,# @.<F5T=7)N960Z(#$-"C(P.C$Q
M.C$W($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HR,#HQ,3HQ-R!3:&]W
M1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.X,# P,# L
M:6YD97@.],C,-"C(P.C$Q.C$W($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL
M<'(Z(#!X.# P,# P#0HR,#HQ,3HQ-R!"96=I;B!!8W1I;VXZ("!$;&=344Q3
M96-U<FET>0T*,C Z,3$Z,C0@.4VAO=T1L9U-13%-E8W5R:71Y(')E='5R;F5D
M.B Q#0HR,#HQ,3HR-"!,;V=I;DUO9&4@./2 R+'-Z4'=D#0HR,#HQ,3HR-"!%
M;F0@.06-T:6]N($1L9U-13%-E8W5R:71Y#0HR,#HQ,3HR-"!B96=I;B!3:&]W
M1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$Q.C(T(&Y&=6QL36%S:R ](#!X,6)D
M9F,P,S<L(&Y#=7)R96YT(#T@.,'@.X,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HR
M,#HQ,3HR-"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A
M8FQE($)A8VL@./2 P>#$-"C(P.C$Q.C(T($1I86QO9R P>#@.P,# P,"!R971U
M<FYE9#H@.,0T*,C Z,3$Z,C0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C(P.C$Q.C(T(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#$P,# P,# L:6YD97@.],C0-"C(P.C$Q.C(T($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P, T*,C Z,3$Z,C0@.0F5G:6X@.
M06-T:6]N.B @.1&QG0V]L;&%T:6]N#0HR,#HQ,3HR-R!3:&]W1&QG0V]L;&%T
M:6]N(')E='5R;F5D.B Q#0HR,#HQ,3HR-R!C;VQL871I;VY?;F%M92 ]($-H
M:6YE<V5?4%)#7T-)7T%3+&QO8V%L95]N86UE(#T@.0VAI;F5S95]04D,L;&-I
M9" ](#!X.# T+%-O<G1)9" ](# L9'=#;VUP1FQA9W,@./2 P>#,P,# Q#0HR
M,#HQ,3HR-R!%;F0@.06-T:6]N($1L9T-O;&QA=&EO;@.T*,C Z,3$Z,C<@.8F5G
M:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,3HR-R!N1G5L;$UA<VL@.
M/2 P>#%B9&9C,#,W+"!N0W5R<F5N=" ](#!X,3 P,# P,"P@.;D1I<F5C=&EO
M;B ](#$-"C(P.C$Q.C(W(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)D9F,P
M,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z,C<@.1&EA;&]G(#!X,3 P
M,# P,"!R971U<FYE9#H@.,0T*,C Z,3$Z,C<@.16YD($%C=&EO;B!3:&]W1&EA
M;&]G<TAL<'(-"C(P.C$Q.C(W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R
M;F5D.B!N0W5R<F5N=#TP>#(P,# P,# L:6YD97@.],C4-"C(P.C$Q.C(W($)E
M9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# P, T*,C Z,3$Z
M,C<@.0F5G:6X@.06-T:6]N.B @.1&QG3F5T=V]R:PT*,C Z,3$Z,C<@.4VAO=T1L
M9TYE='=O<FL@.<F5T=7)N960Z(#$-"C(P.C$Q.C(W(%M$;&=397)V97).971W
M;W)K70T*,C Z,3$Z,C<@.3F5T=V]R:TQI8G,@./2 R-34-"C(P.C$Q.C(W(%1#
M4%!O<G0@./2 Q-#,S#0HR,#HQ,3HR-R!40U!0<GAY(#T@.1&5F875L= T*,C Z
M,3$Z,C<@.3DU04&EP94YA;64@./2!<7"Y<<&EP95QS<6Q<<75E<GD-"C(P.C$Q
M.C(W(%)E<W5L=" ](#$-"C(P.C$Q.C(W($5N9"!!8W1I;VX@.1&QG3F5T=V]R
M:PT*,C Z,3$Z,C<@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ
M,3HR-R!N1G5L;$UA<VL@./2 P>#%B9&9C,#,W+"!N0W5R<F5N=" ](#!X,C P
M,# P,"P@.;D1I<F5C=&EO;B ](#$-"C(P.C$Q.C(W(%5P9&%T960@.1&EA;&]G
M($UA<VLZ(#!X,6)D9F,P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z
M,C<@.1&EA;&]G(#!X,C P,# P,"!R971U<FYE9#H@.,0T*,C Z,3$Z,C<@.16YD
M($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C(P.C$Q.C(W(%-H;W=$:6%L;V=S
M1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#@.P,# P,# L:6YD97@.]
M,C<-"C(P.C$Q.C(W($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X
M.# P,# P, T*,C Z,3$Z,C<@.0F5G:6X@.06-T:6]N.B @.1&EA;&]G4VAO=U-D
M4W1A<G1#;W!Y#0HR,#HQ,3HR."!%;F0@.06-T:6]N($1I86QO9U-H;W=39%-T
M87)T0V]P>0T*,C Z,3$Z,C@.@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K
M#0HR,#HQ,3HR."!N1G5L;$UA<VL@./2 P>#%B9&9C,#,W+"!N0W5R<F5N=" ]
M(#!X.# P,# P,"P@.;D1I<F5C=&EO;B ](#$-"C(P.C$Q.C(X(%5P9&%T960@.
M1&EA;&]G($UA<VLZ(#!X,6)D9F,P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*
M,C Z,3$Z,C@.@.1&EA;&]G(#!X.# P,# P,"!R971U<FYE9#H@.,0T*,C Z,3$Z
M,C@.@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C(P.C$Q.C(X(%-H;W=$
M:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#$P,# P,# P
M+&EN9&5X/3(X#0HR,#HQ,3HR."!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(
M;'!R.B P>#$P,# P,# P#0HR,#HQ,3HR."!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V1,:6-E;G-E36]D90T*,C Z,3$Z,S @.4VAO=T1L9TQI8V5N<V4@.
M<F5T=7)N960Z(#$-"C(P.C$Q.C,P(%-H;W=$;&=,:6-E;G-E(')E='5R;F5D
M.B!,:6-E;G-E36]D92 ](#(L($QI8V5N<V5,:6UI=" ](#(-"C(P.C$Q.C,P
M($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D3&EC96YS94UO9&4-"C(P.C$Q.C,P
M($1I86QO9R P>#$P,# P,# P(')E='5R;F5D.B Q#0HR,#HQ,3HS,"!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,C Z,3$Z,S @.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,"QI;F1E>#TP#0HR,#HQ
M,3HS,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S#0HR,#HQ,3HS,"!.;W<@.8F5G
M:6X@.:6YS=&%L;&EN9R!-:6-R;W-O9G0@.1&ES=')I8G5T960@.5')A;G-A8W1I
M;VX@.0V]O<F1I;F%T;W(@.*$U31%1#*2 N+BX-"C(P.C$Q.C,P("!#.EQ724Y.
M5%Q414U07%-Q;%-E='5P7$)I;EQC;&1T8W-T<"YE>&4@.+5-U<'!O<G1$:7(@.
M(D,Z7%=)3DY47%1%35!<4W%L4V5T=7!<0FEN(B M1%1#4&MG(")#.EQ%3E1<
M>#@.V7$]T:&5R7&1T8W-E='5P+F5X92(@.+4QO9T9I;&4@.(D,Z7%=)3DY47'-Q
M;'-T<"YL;V<B("U#='A!8V-T(")324Y/3$E.15-<8VQU<W1E<B(@.+4-T>$50
M=V0-"C(P.C$Q.C,P(%!R;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HR,#HQ,3HS
M,"!"96=I;B!!8W1I;VX@..B!#;'5S=&5R4V5T=7!(96QP97( -"C(P.C$Q.C,P
M($)E9VEN($%C=&EO;B Z($-R96%T94-L=7-T25-31FEL97,-"C(P.C$Q.C,P
M($5N9"!!8W1I;VX@..B!#<F5A=&5#;'5S=$E34T9I;&5S#0HR, #HQ,3HS,"!"
M96=I;B!!8W1I;VX@..B!#;'5S=&5R5W)I=&5296U);FD-"C(P.C$Q.C,P($5N
M9"!!8W1I;VX@..B!#;'5S=&5R5W)I=&5296U);FD-"C(P.C$Q.C,P($)E9VEN
M($%C=&EO;B Z(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO9&5S#0I;87)G<UT-
M"DYU;5)E;6]T95-E<G9E<G,],@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E4V5R
M=FEC97,],0T*,2YA<' ]7%Q!7$,D7$5.5%QX.#9<<V5T=7!<<V5T=7!S<6PN
M97AE#0HQ+G-C<FEP=#U<7$%<861M:6XD7%]-4U-13%-%4E9%4BYI<W,-"C$N
M8VUD;&EN969O<FUA=#TE<R!K/4-L4V5C(&L]4FT@.:SU#;" M4TU3("US("UF
M,2 E<R M;R B<W%L<W1P+F5X92(@.#0HQ+G5S97(]4TE.3TQ)3D537&-L=7-T
M97(-"C$N<&%S<W=O<F0],3,W8S4R8S8Q,V5A8C-B,6$Y-6$W-35A-#)C9 T*
M,2YN86UE/5-13%-E='5P,0T*,2YS<6QS971U<#U9#0HQ+F-O<'EE>&4]8VYV
M<W9C,2YE>&4-"EM397)V97(N,ET-"DYU;5)E;6]T95-E<G9I8V5S/3$-"C$N
M87!P/5Q<05Q#)%Q%3E1<>#@.V7'-E='5P7'-E='5P<W%L+F5X90T*,2YS8W)I
M<'0]7%Q!7&%D;6EN)%Q?35-344Q315)615(N:7-S#0HQ+F-M9&QI;F5F;W)M
M870])7,@.:SU#;%-E8R!K/5)M(&L]0VP@.+5--4R M<R M9B B7%Q!7$,D7$5.
M5%QX.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.)7,@.+68R(")<7%QA9&UI;B1<
M<V5T=7 N;&]G(B M92 B<W1P<VEL;G0N7V5X(B @.+7@.@.(D,Z7"(-"C$N=7-E
M<CU324Y/3$E.15-<8VQU<W1E<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S96%B
M,V(Q83DU83<U-6$T,F-D#0HQ+FYA;64]4U%,4V5T=7 R#0HQ+G-Q;'-E='5P
M/5D-"C$N8V]P>65X93UC;G9S=F,R+F5X90T*,C Z,3$Z,S @.($EN<W1A;&QS
M:&EE;&0@.:7,@.:6YS=&%L;&EN9R!S;VUE('!R;V=R86T@.;VX@.= &AE(&YO9&4L
M('1H:7,@.;6%Y(&YE960@.<V]M92!M:6YU=&5S*+"RU["SS-#RU?W4VLBZO*^]
MVK7CR<_6M-#0T.C2JK7$LMG7]Z&CU>*_R<3<T.C2JLK]M];6TRXN+BD-"C(P
M.C$Q.C,P("!#.EQ724Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE
M>&4@.0SI<5TE.3E1<<F5M<V5T=7 N:6YI#0HR,#HQ,3HS,"!0<F]C97-S($5X
M:70@.0V]D93H@.*"TQ*2 -"C(P.C$Q.C,P($)E9VEN($%C=&EO;B Z($=E=%)E
M;7-E='5P4F5T0V]D90T*,C Z,3$Z,S @.26YS=&%L;&%T:6]N(')E='5R;B!S
M=&%T=7,@.;VX@.(#H@.+3$-"C(P.C$Q.C,P($EN<W1A;&QA=&EO;B!R971U<FX@.
M<W1A='5S(&]N(" Z("TQ#0HR,#HQ,3HS,"!%;F0@.06-T:6]N(#H@.1V5T4F5M
M<V5T=7!2971#;V1E#2,C(R,@.4U%,(%-E<G9E<B#4MK/,L++7L+/,T/(@.H:H@.
MOZK*O,JQO.0@.,#8O,#(O,#0@.,C Z,3$Z,S @.(R,C(PT*#0IT:&4@.9VEV96X@.
M87)G=6UE;G1S(&%R92!I;G9A;&ED*,OYS.&YJ;7$RN3(Z]:USM[0IRFCH0T*
M#0K+^=*JQ_.UQ++.ROT@.4V5R=F5R+C$@.U-J]VJ.H87)G<Z.IUM##N]/0U=*U
MO:.A#0I4:&4@.<F5Q=65S=&5D(&%R9W5M96YT('-E<G9E<BYS(&-A;FYO="!B
M92!F;W5N9"!I;B!A<F=S#0K+^<SAN:FUQ,KDR.O6M<[>T*>CH 0T*#0K+^=*J
MQ_.UQ++.ROT@.4V5R=F5R+C(@.U-J]VJ.H87)G<Z.IUM##N]/0U=*UO:.A#0H-
M"M3:U,O0T-2VL\POSM[6M;NDL++7L+/,T/+*L;>BR?K2N[CVN_*VX+CVM.W.
M\Z&C#0H-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" -"C(P.C$Q.C,P($5N9"!!8W1I;VX@..B!2=6X@.<V5T=7 @.
M;VX@.8VQU<W1E<B!N;V1E<PT*,C Z,3$Z,S @.96YC;W5N=&5R(&]N92!O<B!S
M;VUE(&9A=6QT<R!W:&5N(')U;B!S;VUE(')E;6]T92!P<F]G<F%M;65S(-3:
MR+J\K[7$O,;+X[OZR<_4R]#0U+:SS+"RU["SS-#RRK&CK+/VS];2N[CVN_*V
MX+CVM.W.\Z&C#0HR,#HQ,3HS,2!3971U<"!F86EL960@.=&\@.< &5R9F]R;2!T
M:&4@.<F5Q=6ER960@.;W!E<F%T:6]N(&]N('1H92!C;'5S=&5R(&YO9&5S(+"R
MU["SS-#RU-K(NKROO=JUX\G/UK30T-*JQ_.UQ++9U_?*I[#<H:,-"C(P.C$Q
M.C,Q($)E9VEN($%C=&EO;B Z($-L=7-T97)%<G)O<D-L96%N=7 -"C(P.C$Q
M.C,Q($5N9"!!8W1I;VX@..B!#;'5S=&5R17)R;W)#;&5A;G5P# 0HR,#HQ,3HS
C,2!%;F0@.06-T:6]N(#H@.0VQU<W1E<E-E='5P2&5L<&5R#0H`
`
end
Showing posts with label errors. Show all posts
Showing posts with label errors. Show all posts
Sunday, March 25, 2012
Friday, February 24, 2012
client-requested SSL encryption errors
I did not get any useful response the last time I posted this, so now I'm
posting a more detailed version of the question.
We are having difficulty getting client-requested SSL encryption to work
with SQL Server 2000 Enterprise SP4.
Using "Force All Clients to Use SSL" is not an option for us. We need to be
able to have certain clients (extranet)use encryption without forcing other
clients (intranet) to also use encryption. Hence, we need to know how to
make "Force Protocol Encryption" work from the Client Network Utility with
SQL Query Analyzer.
Ultimately, our goal is to enable encryption in certain connection requests
from custom client applications we are writing. However, we will be happy
for now if we can at least get it working from a standard MS tool as
described in the SQL Server documentation and KB articles.
Has anyone else managed to make client-requested encryption work without
using a commercial CA? For that matter, has anyone suceeded in making it
work *with* a commercial CA?
When I connect using SQL Query Analyzer without Force Protocol Encryption in
the Client Network Utility, everything works fine. When I select Force
Protocol Encryption, then I get the following error:
====
unable to connect to server
server: msg 18, level 16, state 1
[microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
====
The server is running Windows Server 2003 Enterprise SP1. As mentioned
earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
The Server Authentication certificate is installed correctly on the SQL
Server 2000 machine. It was generated by Microsoft Certificate Services
configured as a stand-alone root CA. The certificate chain is OK according
to MMC snap-in and works fine with no warnings for HTTPS connections to IIS,
so I don't see how the certificate could be malformed. There definitely is
only one certificate installed on the server (at least according to the MMC
snap-in for Certificates). The Root CA chain is installed on the client and
is OK according to MMC. This seems to be validated by the fact that IE
doesn't give any warnings when making an HTTPS connection to the server
(i.e., it recognizes the certificate chain as a trusted source).
I've read every KB article I can find on the subject, followed all the
instructions with meticulous care, and reinstalled everything from scratch
twice already (including the CA, thus generating a new root certificate and
new server authentication certificate). The client still fails to connect
whenever I force client encryption (it's not feasible for us to set force
encryption on the server).
I've even tried creating various aliases for the server in the Client
Network Utility, as suggested in one KB article, but that doesn't seem to
help either.
Perhaps I'm overlooking something really obvious, but I'm seriously
beginning to doubt whether SQL Server really supports client-initiated SSL
connections at all. Has anyone else gotten this to work? If so, what was the
trick to making it work?
Any suggestions would be greatly appreciated.
Hello Aubrey,
I don't think you need a commercial certfiicate to do this.
If you want to enable Force Protocol Encryption on the client, you must
have a certificate on the server and the client must have the Trusted Root
Authority updated to trust the server certificate. You can install your own
CA and get certficate from it on the server, and install root CA
certificate on the client.
You may have reviewed the following articles but the steps to enable SSL
from client are verified to work properly.
316898 How to enable SSL encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
316779 PRB: Clients with Force Protocol Encryption Set On May Fail to
Connect
http://support.microsoft.com/?id=316779
276553 How to enable SSL encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Also, to make sure the certificate installed on the SQL server is correct,
we suggest that you enable "Force Protocol Encryption" temporarily and
disable "Force Protocol Encryption" on client to test the situation. If it
works under this situation, the server certificate itself has no issues.
Note: EVEN IF YOU ARE ENABLING FORCE PROTOCOL ENCRYPTION ON THE CLIENT SIDE
ONLY, YOU STILL NEED TO RESTART SQL SERVER FOR THE CERTIFICATE TO BECOME
EFFECTIVE AND USED BY SQL SERVER.
If "Force Protocol Encryption" on server does not work, please check the
certificate property to make sure it is for FQDN for the SQL server.
839617 BUG: You cannot connect to an instance of SQL Server on a server
http://support.microsoft.com/?id=839617
You may want to check if the issue occurs on different client computers to
isolate the issue.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Aubrey McAuley" <winaix@.nospam.nospam>
| Subject: client-requested SSL encryption errors
| Date: Wed, 27 Jul 2005 16:10:49 -0500
| Lines: 65
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Gi#t#ukFHA.2852@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: rrcs-67-79-5-147.sw.biz.rr.com 67.79.5.147
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:64999
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I did not get any useful response the last time I posted this, so now I'm
| posting a more detailed version of the question.
|
| We are having difficulty getting client-requested SSL encryption to work
| with SQL Server 2000 Enterprise SP4.
|
| Using "Force All Clients to Use SSL" is not an option for us. We need to
be
| able to have certain clients (extranet)use encryption without forcing
other
| clients (intranet) to also use encryption. Hence, we need to know how to
| make "Force Protocol Encryption" work from the Client Network Utility
with
| SQL Query Analyzer.
|
| Ultimately, our goal is to enable encryption in certain connection
requests
| from custom client applications we are writing. However, we will be happy
| for now if we can at least get it working from a standard MS tool as
| described in the SQL Server documentation and KB articles.
|
| Has anyone else managed to make client-requested encryption work without
| using a commercial CA? For that matter, has anyone suceeded in making it
| work *with* a commercial CA?
|
| When I connect using SQL Query Analyzer without Force Protocol Encryption
in
| the Client Network Utility, everything works fine. When I select Force
| Protocol Encryption, then I get the following error:
|
| ====
| unable to connect to server
| server: msg 18, level 16, state 1
| [microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
|
| ====
|
| The server is running Windows Server 2003 Enterprise SP1. As mentioned
| earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
|
| The Server Authentication certificate is installed correctly on the SQL
| Server 2000 machine. It was generated by Microsoft Certificate Services
| configured as a stand-alone root CA. The certificate chain is OK
according
| to MMC snap-in and works fine with no warnings for HTTPS connections to
IIS,
| so I don't see how the certificate could be malformed. There definitely
is
| only one certificate installed on the server (at least according to the
MMC
| snap-in for Certificates). The Root CA chain is installed on the client
and
| is OK according to MMC. This seems to be validated by the fact that IE
| doesn't give any warnings when making an HTTPS connection to the server
| (i.e., it recognizes the certificate chain as a trusted source).
|
| I've read every KB article I can find on the subject, followed all the
| instructions with meticulous care, and reinstalled everything from
scratch
| twice already (including the CA, thus generating a new root certificate
and
| new server authentication certificate). The client still fails to connect
| whenever I force client encryption (it's not feasible for us to set force
| encryption on the server).
|
| I've even tried creating various aliases for the server in the Client
| Network Utility, as suggested in one KB article, but that doesn't seem to
| help either.
|
| Perhaps I'm overlooking something really obvious, but I'm seriously
| beginning to doubt whether SQL Server really supports client-initiated
SSL
| connections at all. Has anyone else gotten this to work? If so, what was
the
| trick to making it work?
|
| Any suggestions would be greatly appreciated.
|
|
|
posting a more detailed version of the question.
We are having difficulty getting client-requested SSL encryption to work
with SQL Server 2000 Enterprise SP4.
Using "Force All Clients to Use SSL" is not an option for us. We need to be
able to have certain clients (extranet)use encryption without forcing other
clients (intranet) to also use encryption. Hence, we need to know how to
make "Force Protocol Encryption" work from the Client Network Utility with
SQL Query Analyzer.
Ultimately, our goal is to enable encryption in certain connection requests
from custom client applications we are writing. However, we will be happy
for now if we can at least get it working from a standard MS tool as
described in the SQL Server documentation and KB articles.
Has anyone else managed to make client-requested encryption work without
using a commercial CA? For that matter, has anyone suceeded in making it
work *with* a commercial CA?
When I connect using SQL Query Analyzer without Force Protocol Encryption in
the Client Network Utility, everything works fine. When I select Force
Protocol Encryption, then I get the following error:
====
unable to connect to server
server: msg 18, level 16, state 1
[microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
====
The server is running Windows Server 2003 Enterprise SP1. As mentioned
earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
The Server Authentication certificate is installed correctly on the SQL
Server 2000 machine. It was generated by Microsoft Certificate Services
configured as a stand-alone root CA. The certificate chain is OK according
to MMC snap-in and works fine with no warnings for HTTPS connections to IIS,
so I don't see how the certificate could be malformed. There definitely is
only one certificate installed on the server (at least according to the MMC
snap-in for Certificates). The Root CA chain is installed on the client and
is OK according to MMC. This seems to be validated by the fact that IE
doesn't give any warnings when making an HTTPS connection to the server
(i.e., it recognizes the certificate chain as a trusted source).
I've read every KB article I can find on the subject, followed all the
instructions with meticulous care, and reinstalled everything from scratch
twice already (including the CA, thus generating a new root certificate and
new server authentication certificate). The client still fails to connect
whenever I force client encryption (it's not feasible for us to set force
encryption on the server).
I've even tried creating various aliases for the server in the Client
Network Utility, as suggested in one KB article, but that doesn't seem to
help either.
Perhaps I'm overlooking something really obvious, but I'm seriously
beginning to doubt whether SQL Server really supports client-initiated SSL
connections at all. Has anyone else gotten this to work? If so, what was the
trick to making it work?
Any suggestions would be greatly appreciated.
Hello Aubrey,
I don't think you need a commercial certfiicate to do this.
If you want to enable Force Protocol Encryption on the client, you must
have a certificate on the server and the client must have the Trusted Root
Authority updated to trust the server certificate. You can install your own
CA and get certficate from it on the server, and install root CA
certificate on the client.
You may have reviewed the following articles but the steps to enable SSL
from client are verified to work properly.
316898 How to enable SSL encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
316779 PRB: Clients with Force Protocol Encryption Set On May Fail to
Connect
http://support.microsoft.com/?id=316779
276553 How to enable SSL encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Also, to make sure the certificate installed on the SQL server is correct,
we suggest that you enable "Force Protocol Encryption" temporarily and
disable "Force Protocol Encryption" on client to test the situation. If it
works under this situation, the server certificate itself has no issues.
Note: EVEN IF YOU ARE ENABLING FORCE PROTOCOL ENCRYPTION ON THE CLIENT SIDE
ONLY, YOU STILL NEED TO RESTART SQL SERVER FOR THE CERTIFICATE TO BECOME
EFFECTIVE AND USED BY SQL SERVER.
If "Force Protocol Encryption" on server does not work, please check the
certificate property to make sure it is for FQDN for the SQL server.
839617 BUG: You cannot connect to an instance of SQL Server on a server
http://support.microsoft.com/?id=839617
You may want to check if the issue occurs on different client computers to
isolate the issue.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Aubrey McAuley" <winaix@.nospam.nospam>
| Subject: client-requested SSL encryption errors
| Date: Wed, 27 Jul 2005 16:10:49 -0500
| Lines: 65
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Gi#t#ukFHA.2852@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: rrcs-67-79-5-147.sw.biz.rr.com 67.79.5.147
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:64999
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I did not get any useful response the last time I posted this, so now I'm
| posting a more detailed version of the question.
|
| We are having difficulty getting client-requested SSL encryption to work
| with SQL Server 2000 Enterprise SP4.
|
| Using "Force All Clients to Use SSL" is not an option for us. We need to
be
| able to have certain clients (extranet)use encryption without forcing
other
| clients (intranet) to also use encryption. Hence, we need to know how to
| make "Force Protocol Encryption" work from the Client Network Utility
with
| SQL Query Analyzer.
|
| Ultimately, our goal is to enable encryption in certain connection
requests
| from custom client applications we are writing. However, we will be happy
| for now if we can at least get it working from a standard MS tool as
| described in the SQL Server documentation and KB articles.
|
| Has anyone else managed to make client-requested encryption work without
| using a commercial CA? For that matter, has anyone suceeded in making it
| work *with* a commercial CA?
|
| When I connect using SQL Query Analyzer without Force Protocol Encryption
in
| the Client Network Utility, everything works fine. When I select Force
| Protocol Encryption, then I get the following error:
|
| ====
| unable to connect to server
| server: msg 18, level 16, state 1
| [microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
|
| ====
|
| The server is running Windows Server 2003 Enterprise SP1. As mentioned
| earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
|
| The Server Authentication certificate is installed correctly on the SQL
| Server 2000 machine. It was generated by Microsoft Certificate Services
| configured as a stand-alone root CA. The certificate chain is OK
according
| to MMC snap-in and works fine with no warnings for HTTPS connections to
IIS,
| so I don't see how the certificate could be malformed. There definitely
is
| only one certificate installed on the server (at least according to the
MMC
| snap-in for Certificates). The Root CA chain is installed on the client
and
| is OK according to MMC. This seems to be validated by the fact that IE
| doesn't give any warnings when making an HTTPS connection to the server
| (i.e., it recognizes the certificate chain as a trusted source).
|
| I've read every KB article I can find on the subject, followed all the
| instructions with meticulous care, and reinstalled everything from
scratch
| twice already (including the CA, thus generating a new root certificate
and
| new server authentication certificate). The client still fails to connect
| whenever I force client encryption (it's not feasible for us to set force
| encryption on the server).
|
| I've even tried creating various aliases for the server in the Client
| Network Utility, as suggested in one KB article, but that doesn't seem to
| help either.
|
| Perhaps I'm overlooking something really obvious, but I'm seriously
| beginning to doubt whether SQL Server really supports client-initiated
SSL
| connections at all. Has anyone else gotten this to work? If so, what was
the
| trick to making it work?
|
| Any suggestions would be greatly appreciated.
|
|
|
client-requested SSL encryption errors
I did not get any useful response the last time I posted this, so now I'm
posting a more detailed version of the question.
We are having difficulty getting client-requested SSL encryption to work
with SQL Server 2000 Enterprise SP4.
Using "Force All Clients to Use SSL" is not an option for us. We need to be
able to have certain clients (extranet)use encryption without forcing other
clients (intranet) to also use encryption. Hence, we need to know how to
make "Force Protocol Encryption" work from the Client Network Utility with
SQL Query Analyzer.
Ultimately, our goal is to enable encryption in certain connection requests
from custom client applications we are writing. However, we will be happy
for now if we can at least get it working from a standard MS tool as
described in the SQL Server documentation and KB articles.
Has anyone else managed to make client-requested encryption work without
using a commercial CA? For that matter, has anyone suceeded in making it
work *with* a commercial CA?
When I connect using SQL Query Analyzer without Force Protocol Encryption in
the Client Network Utility, everything works fine. When I select Force
Protocol Encryption, then I get the following error:
==== unable to connect to server
server: msg 18, level 16, state 1
[microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
====
The server is running Windows Server 2003 Enterprise SP1. As mentioned
earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
The Server Authentication certificate is installed correctly on the SQL
Server 2000 machine. It was generated by Microsoft Certificate Services
configured as a stand-alone root CA. The certificate chain is OK according
to MMC snap-in and works fine with no warnings for HTTPS connections to IIS,
so I don't see how the certificate could be malformed. There definitely is
only one certificate installed on the server (at least according to the MMC
snap-in for Certificates). The Root CA chain is installed on the client and
is OK according to MMC. This seems to be validated by the fact that IE
doesn't give any warnings when making an HTTPS connection to the server
(i.e., it recognizes the certificate chain as a trusted source).
I've read every KB article I can find on the subject, followed all the
instructions with meticulous care, and reinstalled everything from scratch
twice already (including the CA, thus generating a new root certificate and
new server authentication certificate). The client still fails to connect
whenever I force client encryption (it's not feasible for us to set force
encryption on the server).
I've even tried creating various aliases for the server in the Client
Network Utility, as suggested in one KB article, but that doesn't seem to
help either.
Perhaps I'm overlooking something really obvious, but I'm seriously
beginning to doubt whether SQL Server really supports client-initiated SSL
connections at all. Has anyone else gotten this to work? If so, what was the
trick to making it work?
Any suggestions would be greatly appreciated.Hello Aubrey,
I don't think you need a commercial certfiicate to do this.
If you want to enable Force Protocol Encryption on the client, you must
have a certificate on the server and the client must have the Trusted Root
Authority updated to trust the server certificate. You can install your own
CA and get certficate from it on the server, and install root CA
certificate on the client.
You may have reviewed the following articles but the steps to enable SSL
from client are verified to work properly.
316898 How to enable SSL encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
316779 PRB: Clients with Force Protocol Encryption Set On May Fail to
Connect
http://support.microsoft.com/?id=316779
276553 How to enable SSL encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Also, to make sure the certificate installed on the SQL server is correct,
we suggest that you enable "Force Protocol Encryption" temporarily and
disable "Force Protocol Encryption" on client to test the situation. If it
works under this situation, the server certificate itself has no issues.
Note: EVEN IF YOU ARE ENABLING FORCE PROTOCOL ENCRYPTION ON THE CLIENT SIDE
ONLY, YOU STILL NEED TO RESTART SQL SERVER FOR THE CERTIFICATE TO BECOME
EFFECTIVE AND USED BY SQL SERVER.
If "Force Protocol Encryption" on server does not work, please check the
certificate property to make sure it is for FQDN for the SQL server.
839617 BUG: You cannot connect to an instance of SQL Server on a server
http://support.microsoft.com/?id=839617
You may want to check if the issue occurs on different client computers to
isolate the issue.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Aubrey McAuley" <winaix@.nospam.nospam>
| Subject: client-requested SSL encryption errors
| Date: Wed, 27 Jul 2005 16:10:49 -0500
| Lines: 65
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Gi#t#ukFHA.2852@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: rrcs-67-79-5-147.sw.biz.rr.com 67.79.5.147
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:64999
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I did not get any useful response the last time I posted this, so now I'm
| posting a more detailed version of the question.
|
| We are having difficulty getting client-requested SSL encryption to work
| with SQL Server 2000 Enterprise SP4.
|
| Using "Force All Clients to Use SSL" is not an option for us. We need to
be
| able to have certain clients (extranet)use encryption without forcing
other
| clients (intranet) to also use encryption. Hence, we need to know how to
| make "Force Protocol Encryption" work from the Client Network Utility
with
| SQL Query Analyzer.
|
| Ultimately, our goal is to enable encryption in certain connection
requests
| from custom client applications we are writing. However, we will be happy
| for now if we can at least get it working from a standard MS tool as
| described in the SQL Server documentation and KB articles.
|
| Has anyone else managed to make client-requested encryption work without
| using a commercial CA? For that matter, has anyone suceeded in making it
| work *with* a commercial CA?
|
| When I connect using SQL Query Analyzer without Force Protocol Encryption
in
| the Client Network Utility, everything works fine. When I select Force
| Protocol Encryption, then I get the following error:
|
| ====| unable to connect to server
| server: msg 18, level 16, state 1
| [microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
|
| ====|
| The server is running Windows Server 2003 Enterprise SP1. As mentioned
| earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
|
| The Server Authentication certificate is installed correctly on the SQL
| Server 2000 machine. It was generated by Microsoft Certificate Services
| configured as a stand-alone root CA. The certificate chain is OK
according
| to MMC snap-in and works fine with no warnings for HTTPS connections to
IIS,
| so I don't see how the certificate could be malformed. There definitely
is
| only one certificate installed on the server (at least according to the
MMC
| snap-in for Certificates). The Root CA chain is installed on the client
and
| is OK according to MMC. This seems to be validated by the fact that IE
| doesn't give any warnings when making an HTTPS connection to the server
| (i.e., it recognizes the certificate chain as a trusted source).
|
| I've read every KB article I can find on the subject, followed all the
| instructions with meticulous care, and reinstalled everything from
scratch
| twice already (including the CA, thus generating a new root certificate
and
| new server authentication certificate). The client still fails to connect
| whenever I force client encryption (it's not feasible for us to set force
| encryption on the server).
|
| I've even tried creating various aliases for the server in the Client
| Network Utility, as suggested in one KB article, but that doesn't seem to
| help either.
|
| Perhaps I'm overlooking something really obvious, but I'm seriously
| beginning to doubt whether SQL Server really supports client-initiated
SSL
| connections at all. Has anyone else gotten this to work? If so, what was
the
| trick to making it work?
|
| Any suggestions would be greatly appreciated.
|
|
|
posting a more detailed version of the question.
We are having difficulty getting client-requested SSL encryption to work
with SQL Server 2000 Enterprise SP4.
Using "Force All Clients to Use SSL" is not an option for us. We need to be
able to have certain clients (extranet)use encryption without forcing other
clients (intranet) to also use encryption. Hence, we need to know how to
make "Force Protocol Encryption" work from the Client Network Utility with
SQL Query Analyzer.
Ultimately, our goal is to enable encryption in certain connection requests
from custom client applications we are writing. However, we will be happy
for now if we can at least get it working from a standard MS tool as
described in the SQL Server documentation and KB articles.
Has anyone else managed to make client-requested encryption work without
using a commercial CA? For that matter, has anyone suceeded in making it
work *with* a commercial CA?
When I connect using SQL Query Analyzer without Force Protocol Encryption in
the Client Network Utility, everything works fine. When I select Force
Protocol Encryption, then I get the following error:
==== unable to connect to server
server: msg 18, level 16, state 1
[microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
====
The server is running Windows Server 2003 Enterprise SP1. As mentioned
earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
The Server Authentication certificate is installed correctly on the SQL
Server 2000 machine. It was generated by Microsoft Certificate Services
configured as a stand-alone root CA. The certificate chain is OK according
to MMC snap-in and works fine with no warnings for HTTPS connections to IIS,
so I don't see how the certificate could be malformed. There definitely is
only one certificate installed on the server (at least according to the MMC
snap-in for Certificates). The Root CA chain is installed on the client and
is OK according to MMC. This seems to be validated by the fact that IE
doesn't give any warnings when making an HTTPS connection to the server
(i.e., it recognizes the certificate chain as a trusted source).
I've read every KB article I can find on the subject, followed all the
instructions with meticulous care, and reinstalled everything from scratch
twice already (including the CA, thus generating a new root certificate and
new server authentication certificate). The client still fails to connect
whenever I force client encryption (it's not feasible for us to set force
encryption on the server).
I've even tried creating various aliases for the server in the Client
Network Utility, as suggested in one KB article, but that doesn't seem to
help either.
Perhaps I'm overlooking something really obvious, but I'm seriously
beginning to doubt whether SQL Server really supports client-initiated SSL
connections at all. Has anyone else gotten this to work? If so, what was the
trick to making it work?
Any suggestions would be greatly appreciated.Hello Aubrey,
I don't think you need a commercial certfiicate to do this.
If you want to enable Force Protocol Encryption on the client, you must
have a certificate on the server and the client must have the Trusted Root
Authority updated to trust the server certificate. You can install your own
CA and get certficate from it on the server, and install root CA
certificate on the client.
You may have reviewed the following articles but the steps to enable SSL
from client are verified to work properly.
316898 How to enable SSL encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
316779 PRB: Clients with Force Protocol Encryption Set On May Fail to
Connect
http://support.microsoft.com/?id=316779
276553 How to enable SSL encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Also, to make sure the certificate installed on the SQL server is correct,
we suggest that you enable "Force Protocol Encryption" temporarily and
disable "Force Protocol Encryption" on client to test the situation. If it
works under this situation, the server certificate itself has no issues.
Note: EVEN IF YOU ARE ENABLING FORCE PROTOCOL ENCRYPTION ON THE CLIENT SIDE
ONLY, YOU STILL NEED TO RESTART SQL SERVER FOR THE CERTIFICATE TO BECOME
EFFECTIVE AND USED BY SQL SERVER.
If "Force Protocol Encryption" on server does not work, please check the
certificate property to make sure it is for FQDN for the SQL server.
839617 BUG: You cannot connect to an instance of SQL Server on a server
http://support.microsoft.com/?id=839617
You may want to check if the issue occurs on different client computers to
isolate the issue.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Aubrey McAuley" <winaix@.nospam.nospam>
| Subject: client-requested SSL encryption errors
| Date: Wed, 27 Jul 2005 16:10:49 -0500
| Lines: 65
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Gi#t#ukFHA.2852@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: rrcs-67-79-5-147.sw.biz.rr.com 67.79.5.147
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:64999
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I did not get any useful response the last time I posted this, so now I'm
| posting a more detailed version of the question.
|
| We are having difficulty getting client-requested SSL encryption to work
| with SQL Server 2000 Enterprise SP4.
|
| Using "Force All Clients to Use SSL" is not an option for us. We need to
be
| able to have certain clients (extranet)use encryption without forcing
other
| clients (intranet) to also use encryption. Hence, we need to know how to
| make "Force Protocol Encryption" work from the Client Network Utility
with
| SQL Query Analyzer.
|
| Ultimately, our goal is to enable encryption in certain connection
requests
| from custom client applications we are writing. However, we will be happy
| for now if we can at least get it working from a standard MS tool as
| described in the SQL Server documentation and KB articles.
|
| Has anyone else managed to make client-requested encryption work without
| using a commercial CA? For that matter, has anyone suceeded in making it
| work *with* a commercial CA?
|
| When I connect using SQL Query Analyzer without Force Protocol Encryption
in
| the Client Network Utility, everything works fine. When I select Force
| Protocol Encryption, then I get the following error:
|
| ====| unable to connect to server
| server: msg 18, level 16, state 1
| [microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
|
| ====|
| The server is running Windows Server 2003 Enterprise SP1. As mentioned
| earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
|
| The Server Authentication certificate is installed correctly on the SQL
| Server 2000 machine. It was generated by Microsoft Certificate Services
| configured as a stand-alone root CA. The certificate chain is OK
according
| to MMC snap-in and works fine with no warnings for HTTPS connections to
IIS,
| so I don't see how the certificate could be malformed. There definitely
is
| only one certificate installed on the server (at least according to the
MMC
| snap-in for Certificates). The Root CA chain is installed on the client
and
| is OK according to MMC. This seems to be validated by the fact that IE
| doesn't give any warnings when making an HTTPS connection to the server
| (i.e., it recognizes the certificate chain as a trusted source).
|
| I've read every KB article I can find on the subject, followed all the
| instructions with meticulous care, and reinstalled everything from
scratch
| twice already (including the CA, thus generating a new root certificate
and
| new server authentication certificate). The client still fails to connect
| whenever I force client encryption (it's not feasible for us to set force
| encryption on the server).
|
| I've even tried creating various aliases for the server in the Client
| Network Utility, as suggested in one KB article, but that doesn't seem to
| help either.
|
| Perhaps I'm overlooking something really obvious, but I'm seriously
| beginning to doubt whether SQL Server really supports client-initiated
SSL
| connections at all. Has anyone else gotten this to work? If so, what was
the
| trick to making it work?
|
| Any suggestions would be greatly appreciated.
|
|
|
client-requested SSL encryption errors
I did not get any useful response the last time I posted this, so now I'm
posting a more detailed version of the question.
We are having difficulty getting client-requested SSL encryption to work
with SQL Server 2000 Enterprise SP4.
Using "Force All Clients to Use SSL" is not an option for us. We need to be
able to have certain clients (extranet)use encryption without forcing other
clients (intranet) to also use encryption. Hence, we need to know how to
make "Force Protocol Encryption" work from the Client Network Utility with
SQL Query Analyzer.
Ultimately, our goal is to enable encryption in certain connection requests
from custom client applications we are writing. However, we will be happy
for now if we can at least get it working from a standard MS tool as
described in the SQL Server documentation and KB articles.
Has anyone else managed to make client-requested encryption work without
using a commercial CA? For that matter, has anyone suceeded in making it
work *with* a commercial CA?
When I connect using SQL Query Analyzer without Force Protocol Encryption in
the Client Network Utility, everything works fine. When I select Force
Protocol Encryption, then I get the following error:
====
unable to connect to server
server: msg 18, level 16, state 1
[microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
====
The server is running Windows Server 2003 Enterprise SP1. As mentioned
earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
The Server Authentication certificate is installed correctly on the SQL
Server 2000 machine. It was generated by Microsoft Certificate Services
configured as a stand-alone root CA. The certificate chain is OK according
to MMC snap-in and works fine with no warnings for HTTPS connections to IIS,
so I don't see how the certificate could be malformed. There definitely is
only one certificate installed on the server (at least according to the MMC
snap-in for Certificates). The Root CA chain is installed on the client and
is OK according to MMC. This seems to be validated by the fact that IE
doesn't give any warnings when making an HTTPS connection to the server
(i.e., it recognizes the certificate chain as a trusted source).
I've read every KB article I can find on the subject, followed all the
instructions with meticulous care, and reinstalled everything from scratch
twice already (including the CA, thus generating a new root certificate and
new server authentication certificate). The client still fails to connect
whenever I force client encryption (it's not feasible for us to set force
encryption on the server).
I've even tried creating various aliases for the server in the Client
Network Utility, as suggested in one KB article, but that doesn't seem to
help either.
Perhaps I'm overlooking something really obvious, but I'm seriously
beginning to doubt whether SQL Server really supports client-initiated SSL
connections at all. Has anyone else gotten this to work? If so, what was the
trick to making it work?
Any suggestions would be greatly appreciated.Hello Aubrey,
I don't think you need a commercial certfiicate to do this.
If you want to enable Force Protocol Encryption on the client, you must
have a certificate on the server and the client must have the Trusted Root
Authority updated to trust the server certificate. You can install your own
CA and get certficate from it on the server, and install root CA
certificate on the client.
You may have reviewed the following articles but the steps to enable SSL
from client are verified to work properly.
316898 How to enable SSL encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
316779 PRB: Clients with Force Protocol Encryption Set On May Fail to
Connect
http://support.microsoft.com/?id=316779
276553 How to enable SSL encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Also, to make sure the certificate installed on the SQL server is correct,
we suggest that you enable "Force Protocol Encryption" temporarily and
disable "Force Protocol Encryption" on client to test the situation. If it
works under this situation, the server certificate itself has no issues.
Note: EVEN IF YOU ARE ENABLING FORCE PROTOCOL ENCRYPTION ON THE CLIENT SIDE
ONLY, YOU STILL NEED TO RESTART SQL SERVER FOR THE CERTIFICATE TO BECOME
EFFECTIVE AND USED BY SQL SERVER.
If "Force Protocol Encryption" on server does not work, please check the
certificate property to make sure it is for FQDN for the SQL server.
839617 BUG: You cannot connect to an instance of SQL Server on a server
http://support.microsoft.com/?id=839617
You may want to check if the issue occurs on different client computers to
isolate the issue.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Aubrey McAuley" <winaix@.nospam.nospam>
| Subject: client-requested SSL encryption errors
| Date: Wed, 27 Jul 2005 16:10:49 -0500
| Lines: 65
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Gi#t#ukFHA.2852@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: rrcs-67-79-5-147.sw.biz.rr.com 67.79.5.147
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:64999
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I did not get any useful response the last time I posted this, so now I'm
| posting a more detailed version of the question.
|
| We are having difficulty getting client-requested SSL encryption to work
| with SQL Server 2000 Enterprise SP4.
|
| Using "Force All Clients to Use SSL" is not an option for us. We need to
be
| able to have certain clients (extranet)use encryption without forcing
other
| clients (intranet) to also use encryption. Hence, we need to know how to
| make "Force Protocol Encryption" work from the Client Network Utility
with
| SQL Query Analyzer.
|
| Ultimately, our goal is to enable encryption in certain connection
requests
| from custom client applications we are writing. However, we will be happy
| for now if we can at least get it working from a standard MS tool as
| described in the SQL Server documentation and KB articles.
|
| Has anyone else managed to make client-requested encryption work without
| using a commercial CA? For that matter, has anyone suceeded in making it
| work *with* a commercial CA?
|
| When I connect using SQL Query Analyzer without Force Protocol Encryption
in
| the Client Network Utility, everything works fine. When I select Force
| Protocol Encryption, then I get the following error:
|
| ====
| unable to connect to server
| server: msg 18, level 16, state 1
| [microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security erro
r
|
| ====
|
| The server is running Windows Server 2003 Enterprise SP1. As mentioned
| earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
|
| The Server Authentication certificate is installed correctly on the SQL
| Server 2000 machine. It was generated by Microsoft Certificate Services
| configured as a stand-alone root CA. The certificate chain is OK
according
| to MMC snap-in and works fine with no warnings for HTTPS connections to
IIS,
| so I don't see how the certificate could be malformed. There definitely
is
| only one certificate installed on the server (at least according to the
MMC
| snap-in for Certificates). The Root CA chain is installed on the client
and
| is OK according to MMC. This seems to be validated by the fact that IE
| doesn't give any warnings when making an HTTPS connection to the server
| (i.e., it recognizes the certificate chain as a trusted source).
|
| I've read every KB article I can find on the subject, followed all the
| instructions with meticulous care, and reinstalled everything from
scratch
| twice already (including the CA, thus generating a new root certificate
and
| new server authentication certificate). The client still fails to connect
| whenever I force client encryption (it's not feasible for us to set force
| encryption on the server).
|
| I've even tried creating various aliases for the server in the Client
| Network Utility, as suggested in one KB article, but that doesn't seem to
| help either.
|
| Perhaps I'm overlooking something really obvious, but I'm seriously
| beginning to doubt whether SQL Server really supports client-initiated
SSL
| connections at all. Has anyone else gotten this to work? If so, what was
the
| trick to making it work?
|
| Any suggestions would be greatly appreciated.
|
|
|
posting a more detailed version of the question.
We are having difficulty getting client-requested SSL encryption to work
with SQL Server 2000 Enterprise SP4.
Using "Force All Clients to Use SSL" is not an option for us. We need to be
able to have certain clients (extranet)use encryption without forcing other
clients (intranet) to also use encryption. Hence, we need to know how to
make "Force Protocol Encryption" work from the Client Network Utility with
SQL Query Analyzer.
Ultimately, our goal is to enable encryption in certain connection requests
from custom client applications we are writing. However, we will be happy
for now if we can at least get it working from a standard MS tool as
described in the SQL Server documentation and KB articles.
Has anyone else managed to make client-requested encryption work without
using a commercial CA? For that matter, has anyone suceeded in making it
work *with* a commercial CA?
When I connect using SQL Query Analyzer without Force Protocol Encryption in
the Client Network Utility, everything works fine. When I select Force
Protocol Encryption, then I get the following error:
====
unable to connect to server
server: msg 18, level 16, state 1
[microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
====
The server is running Windows Server 2003 Enterprise SP1. As mentioned
earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
The Server Authentication certificate is installed correctly on the SQL
Server 2000 machine. It was generated by Microsoft Certificate Services
configured as a stand-alone root CA. The certificate chain is OK according
to MMC snap-in and works fine with no warnings for HTTPS connections to IIS,
so I don't see how the certificate could be malformed. There definitely is
only one certificate installed on the server (at least according to the MMC
snap-in for Certificates). The Root CA chain is installed on the client and
is OK according to MMC. This seems to be validated by the fact that IE
doesn't give any warnings when making an HTTPS connection to the server
(i.e., it recognizes the certificate chain as a trusted source).
I've read every KB article I can find on the subject, followed all the
instructions with meticulous care, and reinstalled everything from scratch
twice already (including the CA, thus generating a new root certificate and
new server authentication certificate). The client still fails to connect
whenever I force client encryption (it's not feasible for us to set force
encryption on the server).
I've even tried creating various aliases for the server in the Client
Network Utility, as suggested in one KB article, but that doesn't seem to
help either.
Perhaps I'm overlooking something really obvious, but I'm seriously
beginning to doubt whether SQL Server really supports client-initiated SSL
connections at all. Has anyone else gotten this to work? If so, what was the
trick to making it work?
Any suggestions would be greatly appreciated.Hello Aubrey,
I don't think you need a commercial certfiicate to do this.
If you want to enable Force Protocol Encryption on the client, you must
have a certificate on the server and the client must have the Trusted Root
Authority updated to trust the server certificate. You can install your own
CA and get certficate from it on the server, and install root CA
certificate on the client.
You may have reviewed the following articles but the steps to enable SSL
from client are verified to work properly.
316898 How to enable SSL encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
316779 PRB: Clients with Force Protocol Encryption Set On May Fail to
Connect
http://support.microsoft.com/?id=316779
276553 How to enable SSL encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Also, to make sure the certificate installed on the SQL server is correct,
we suggest that you enable "Force Protocol Encryption" temporarily and
disable "Force Protocol Encryption" on client to test the situation. If it
works under this situation, the server certificate itself has no issues.
Note: EVEN IF YOU ARE ENABLING FORCE PROTOCOL ENCRYPTION ON THE CLIENT SIDE
ONLY, YOU STILL NEED TO RESTART SQL SERVER FOR THE CERTIFICATE TO BECOME
EFFECTIVE AND USED BY SQL SERVER.
If "Force Protocol Encryption" on server does not work, please check the
certificate property to make sure it is for FQDN for the SQL server.
839617 BUG: You cannot connect to an instance of SQL Server on a server
http://support.microsoft.com/?id=839617
You may want to check if the issue occurs on different client computers to
isolate the issue.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Aubrey McAuley" <winaix@.nospam.nospam>
| Subject: client-requested SSL encryption errors
| Date: Wed, 27 Jul 2005 16:10:49 -0500
| Lines: 65
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Gi#t#ukFHA.2852@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: rrcs-67-79-5-147.sw.biz.rr.com 67.79.5.147
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:64999
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I did not get any useful response the last time I posted this, so now I'm
| posting a more detailed version of the question.
|
| We are having difficulty getting client-requested SSL encryption to work
| with SQL Server 2000 Enterprise SP4.
|
| Using "Force All Clients to Use SSL" is not an option for us. We need to
be
| able to have certain clients (extranet)use encryption without forcing
other
| clients (intranet) to also use encryption. Hence, we need to know how to
| make "Force Protocol Encryption" work from the Client Network Utility
with
| SQL Query Analyzer.
|
| Ultimately, our goal is to enable encryption in certain connection
requests
| from custom client applications we are writing. However, we will be happy
| for now if we can at least get it working from a standard MS tool as
| described in the SQL Server documentation and KB articles.
|
| Has anyone else managed to make client-requested encryption work without
| using a commercial CA? For that matter, has anyone suceeded in making it
| work *with* a commercial CA?
|
| When I connect using SQL Query Analyzer without Force Protocol Encryption
in
| the Client Network Utility, everything works fine. When I select Force
| Protocol Encryption, then I get the following error:
|
| ====
| unable to connect to server
| server: msg 18, level 16, state 1
| [microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security erro
r
|
| ====
|
| The server is running Windows Server 2003 Enterprise SP1. As mentioned
| earlier, MSSQLSERVER version is SQL Server 2000 Enterprise SP4.
|
| The Server Authentication certificate is installed correctly on the SQL
| Server 2000 machine. It was generated by Microsoft Certificate Services
| configured as a stand-alone root CA. The certificate chain is OK
according
| to MMC snap-in and works fine with no warnings for HTTPS connections to
IIS,
| so I don't see how the certificate could be malformed. There definitely
is
| only one certificate installed on the server (at least according to the
MMC
| snap-in for Certificates). The Root CA chain is installed on the client
and
| is OK according to MMC. This seems to be validated by the fact that IE
| doesn't give any warnings when making an HTTPS connection to the server
| (i.e., it recognizes the certificate chain as a trusted source).
|
| I've read every KB article I can find on the subject, followed all the
| instructions with meticulous care, and reinstalled everything from
scratch
| twice already (including the CA, thus generating a new root certificate
and
| new server authentication certificate). The client still fails to connect
| whenever I force client encryption (it's not feasible for us to set force
| encryption on the server).
|
| I've even tried creating various aliases for the server in the Client
| Network Utility, as suggested in one KB article, but that doesn't seem to
| help either.
|
| Perhaps I'm overlooking something really obvious, but I'm seriously
| beginning to doubt whether SQL Server really supports client-initiated
SSL
| connections at all. Has anyone else gotten this to work? If so, what was
the
| trick to making it work?
|
| Any suggestions would be greatly appreciated.
|
|
|
Tuesday, February 14, 2012
Client found response content type of ''text/html; charset=utf-8'', but expected ''text/xm
Hi,
I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.
Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.
Error message on browser:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR![[:#]](http://pics.10026.com/?src=http://forums.microsoft.com/MSDN/emoticons/emotion-16.gif)
3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.
Any ideas?
Thanks,
-waslam
Maybe this will help you:
http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
Client found response content type of ''text/html; charset=utf-8'', but expected ''text/xm
Hi,
I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.
Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.
Error message on browser:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.
Any ideas?
Thanks,
-waslam
Maybe this will help you:
http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
Client EM produce OS "failed login errors"
hi all, have anyone else met with the following problem.
we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3,
this cluster in using AD.
I've found that whenever I use Enterprise Manager on my local computer
to register the above instance, it will constantly produce "Failed
login for <Domain>\<DomainUser>" errors in the Windows Security Log of
the database server machine. There's no failed login in the SQL error
log and I can work normally with the Enterprise Manager. The OS failed
logins error are gone once I un-register the instance from my
Enterprise Manager.
Does anyone know or met with this before?"New MSSQL DBA" <boscong88@.gmail.com> wrote in message
news:1120635376.062877.121860@.z14g2000cwz.googlegr oups.com...
> hi all, have anyone else met with the following problem.
> we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3,
> this cluster in using AD.
> I've found that whenever I use Enterprise Manager on my local computer
> to register the above instance, it will constantly produce "Failed
> login for <Domain>\<DomainUser>" errors in the Windows Security Log of
> the database server machine. There's no failed login in the SQL error
> log and I can work normally with the Enterprise Manager. The OS failed
> logins error are gone once I un-register the instance from my
> Enterprise Manager.
> Does anyone know or met with this before?
I don't really know, but as a complete guess, EM is trying to connect to the
operating system to get information about the MSSQL service state, and your
Windows account doesn't have those permissions. If this isn't helpful, you
might consider posting the full error details from the log.
Simon
Sunday, February 12, 2012
Clicking through to errors
When I click on an error message in the messages/results screen, it no longer highlights the correct section of code to show where the error is - somehow it has gone out of sync and just highlights a random piece of code.
Does anyone know how to reset it so that the error in the messages screen matches up to the correct line of code?
Thanks
Clicking through to errors
When I click on an error message in the messages/results screen, it no longer highlights the correct section of code to show where the error is - somehow it has gone out of sync and just highlights a random piece of code.
Does anyone know how to reset it so that the error in the messages screen matches up to the correct line of code?
Thanks
Friday, February 10, 2012
Clearing Assembly cache
I have several reports that worked pre-sp1. Now I receive Reporting errors
such as Data is Null, etc. I believe it may have to do with the cached
copies of the old assemblies based on the searching I have done throughout
this newsgroup. I even re-installed Report Services and didn't apply the
patch and the reports worked fine again. I require the hidden parameter
functionality of SP1.
Can someone please explain to me how to clear old assemblies?
ShawnTo clear your private assembly cache, delete the folder C:\Documents and
Settings\<username>\Local Settings\Application Data\assembly .
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> I have several reports that worked pre-sp1. Now I receive Reporting
errors
> such as Data is Null, etc. I believe it may have to do with the cached
> copies of the old assemblies based on the searching I have done throughout
> this newsgroup. I even re-installed Report Services and didn't apply the
> patch and the reports worked fine again. I require the hidden parameter
> functionality of SP1.
> Can someone please explain to me how to clear old assemblies?
> Shawn
>|||I located my Application Data folder but I do not have an "assembly" folder.
I even have all of the hidden folders showing and I don't have it?
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> To clear your private assembly cache, delete the folder C:\Documents and
> Settings\<username>\Local Settings\Application Data\assembly .
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > I have several reports that worked pre-sp1. Now I receive Reporting
> errors
> > such as Data is Null, etc. I believe it may have to do with the cached
> > copies of the old assemblies based on the searching I have done
throughout
> > this newsgroup. I even re-installed Report Services and didn't apply
the
> > patch and the reports worked fine again. I require the hidden parameter
> > functionality of SP1.
> >
> > Can someone please explain to me how to clear old assemblies?
> >
> > Shawn
> >
> >
>|||Then you don't have a private assembly cache. The problems must be due to
another reason. Could you please details about the specific problem you are
having?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> I located my Application Data folder but I do not have an "assembly"
folder.
> I even have all of the hidden folders showing and I don't have it?
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > To clear your private assembly cache, delete the folder C:\Documents and
> > Settings\<username>\Local Settings\Application Data\assembly .
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > I have several reports that worked pre-sp1. Now I receive Reporting
> > errors
> > > such as Data is Null, etc. I believe it may have to do with the
cached
> > > copies of the old assemblies based on the searching I have done
> throughout
> > > this newsgroup. I even re-installed Report Services and didn't apply
> the
> > > patch and the reports worked fine again. I require the hidden
parameter
> > > functionality of SP1.
> > >
> > > Can someone please explain to me how to clear old assemblies?
> > >
> > > Shawn
> > >
> > >
> >
> >
>|||First of all, thanks Albert for helping me with this issue.
I had the trial version of Report Services installed on my development
machine. I have account information with email addresses stored in SQL
Server 2000 SP3. I created a very basic report that consisted of a table
that displayed the account names and email addresses. Everything worked
fine in the design environment, Report Manager, and deployed it to my
asp.net application.
Due to some hidden parameter issues, I had to install RS SP1. The report
that required the fix worked great, however my Account Email does not work
anymore in the Report Manager or in my application. It does work in the
design environment though. Really strange. I have several reports with the
same issue.
I uninstalled Report Services completely and reinstalled without SP1 and
everything worked fine again. As soon as I installed SP1 the same issue
occurred. Please see the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Data is Null. This method or property cannot be called on Null
values.
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> Then you don't have a private assembly cache. The problems must be due to
> another reason. Could you please details about the specific problem you
are
> having?
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > I located my Application Data folder but I do not have an "assembly"
> folder.
> > I even have all of the hidden folders showing and I don't have it?
> >
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > To clear your private assembly cache, delete the folder C:\Documents
and
> > > Settings\<username>\Local Settings\Application Data\assembly .
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > I have several reports that worked pre-sp1. Now I receive Reporting
> > > errors
> > > > such as Data is Null, etc. I believe it may have to do with the
> cached
> > > > copies of the old assemblies based on the searching I have done
> > throughout
> > > > this newsgroup. I even re-installed Report Services and didn't
apply
> > the
> > > > patch and the reports worked fine again. I require the hidden
> parameter
> > > > functionality of SP1.
> > > >
> > > > Can someone please explain to me how to clear old assemblies?
> > > >
> > > > Shawn
> > > >
> > > >
> > >
> > >
> >
> >
>|||Albert? Help! : )
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> First of all, thanks Albert for helping me with this issue.
> I had the trial version of Report Services installed on my development
> machine. I have account information with email addresses stored in SQL
> Server 2000 SP3. I created a very basic report that consisted of a table
> that displayed the account names and email addresses. Everything worked
> fine in the design environment, Report Manager, and deployed it to my
> asp.net application.
> Due to some hidden parameter issues, I had to install RS SP1. The report
> that required the fix worked great, however my Account Email does not work
> anymore in the Report Manager or in my application. It does work in the
> design environment though. Really strange. I have several reports with
the
> same issue.
> I uninstalled Report Services completely and reinstalled without SP1 and
> everything worked fine again. As soon as I installed SP1 the same issue
> occurred. Please see the following error:
>
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Data is Null. This method or property cannot be called on Null
> values.
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > Then you don't have a private assembly cache. The problems must be due
to
> > another reason. Could you please details about the specific problem you
> are
> > having?
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > I located my Application Data folder but I do not have an "assembly"
> > folder.
> > > I even have all of the hidden folders showing and I don't have it?
> > >
> > >
> > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > To clear your private assembly cache, delete the folder C:\Documents
> and
> > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > >
> > > > --
> > > > Albert Yen
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > I have several reports that worked pre-sp1. Now I receive
Reporting
> > > > errors
> > > > > such as Data is Null, etc. I believe it may have to do with the
> > cached
> > > > > copies of the old assemblies based on the searching I have done
> > > throughout
> > > > > this newsgroup. I even re-installed Report Services and didn't
> apply
> > > the
> > > > > patch and the reports worked fine again. I require the hidden
> > parameter
> > > > > functionality of SP1.
> > > > >
> > > > > Can someone please explain to me how to clear old assemblies?
> > > > >
> > > > > Shawn
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Did you republish your reports after installing SP1? Can you post your RDL,
or better, repro the issue against the sample databases?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Albert? Help! : )
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > First of all, thanks Albert for helping me with this issue.
> >
> > I had the trial version of Report Services installed on my development
> > machine. I have account information with email addresses stored in SQL
> > Server 2000 SP3. I created a very basic report that consisted of a
table
> > that displayed the account names and email addresses. Everything worked
> > fine in the design environment, Report Manager, and deployed it to my
> > asp.net application.
> >
> > Due to some hidden parameter issues, I had to install RS SP1. The
report
> > that required the fix worked great, however my Account Email does not
work
> > anymore in the Report Manager or in my application. It does work in the
> > design environment though. Really strange. I have several reports with
> the
> > same issue.
> >
> > I uninstalled Report Services completely and reinstalled without SP1 and
> > everything worked fine again. As soon as I installed SP1 the same issue
> > occurred. Please see the following error:
> >
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > a.. Data is Null. This method or property cannot be called on Null
> > values.
> >
> >
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > Then you don't have a private assembly cache. The problems must be
due
> to
> > > another reason. Could you please details about the specific problem
you
> > are
> > > having?
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > I located my Application Data folder but I do not have an "assembly"
> > > folder.
> > > > I even have all of the hidden folders showing and I don't have it?
> > > >
> > > >
> > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > To clear your private assembly cache, delete the folder
C:\Documents
> > and
> > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > >
> > > > > --
> > > > > Albert Yen
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > >
> > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > I have several reports that worked pre-sp1. Now I receive
> Reporting
> > > > > errors
> > > > > > such as Data is Null, etc. I believe it may have to do with the
> > > cached
> > > > > > copies of the old assemblies based on the searching I have done
> > > > throughout
> > > > > > this newsgroup. I even re-installed Report Services and didn't
> > apply
> > > > the
> > > > > > patch and the reports worked fine again. I require the hidden
> > > parameter
> > > > > > functionality of SP1.
> > > > > >
> > > > > > Can someone please explain to me how to clear old assemblies?
> > > > > >
> > > > > > Shawn
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I had originally designed my reports in the pre-SP1 Report services. I
reinstalled Report Services from scratch, (after a complete uninstall), then
immediately installed SP1. Once it was finished I uploaded the old reports
via the Report Manager. Please note the following RDL...
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<rd:GridSpacing>0.1in</rd:GridSpacing>
<RightMargin>0.5in</RightMargin>
<Author>Shawn Trevellick</Author>
<Body>
<ReportItems>
<Textbox Name="Title">
<Style>
<FontFamily>Verdana</FontFamily>
<FontSize>22pt</FontSize>
<TextAlign>Center</TextAlign>
<Color>DarkSlateBlue</Color>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>2</ZIndex>
<Top>0.75in</Top>
<Height>0.5in</Height>
<CanGrow>true</CanGrow>
<Value>= Globals!ReportName</Value>
</Textbox>
<Image Name="imgLogo">
<ZIndex>1</ZIndex>
<MIMEType>= Fields!LargeImageContentType.Value</MIMEType>
<Height>0.3in</Height>
<Source>Database</Source>
<Style />
<Value>=First(Fields!LargeImageData.Value, "LogoData")</Value>
<Sizing>AutoSize</Sizing>
</Image>
<Table Name="table1">
<Height>0.95in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.3in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>15</ZIndex>
<CanGrow>true</CanGrow>
<Value>Account Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Value>Company Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Value>Contact Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Value>Email Address</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.2in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Email">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoration>Underline</TextDecoration>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Email</rd:DefaultName>
<Action>
<Hyperlink>="mailto:" +
Fields!Email.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!Email.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<Sorting>
<SortBy>
<SortExpression>=Fields!AccountName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</Details>
<DataSetName>AccountEmailData</DataSetName>
<Top>1.5in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.2in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="AccountName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>AccountName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!AccountName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<rd:DefaultName>CompanyName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CompanyName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="FullName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>FullName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!FullName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<Label>=Fields!AccountName.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!AccountName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox10</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox13</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<TableColumns>
<TableColumn>
<Width>2.1in</Width>
</TableColumn>
<TableColumn>
<Width>2.3in</Width>
</TableColumn>
<TableColumn>
<Width>2in</Width>
</TableColumn>
<TableColumn>
<Width>3.6in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2.5in</Height>
</Body>
<TopMargin>0.5in</TopMargin>
<DataSources>
<DataSource Name="MyDatasource">
<rd:DataSourceID>dd7d0594-fe10-4986-af0c-2b371fb647c3</rd:DataSourceID>
<DataSourceReference>MyDatasource</DataSourceReference>
</DataSource>
</DataSources>
<Code />
<Width>10in</Width>
<DataSets>
<DataSet Name="LogoData">
<Fields>
<Field Name="LargeImageData">
<DataField>LargeImageData</DataField>
<rd:TypeName>System.Byte[]</rd:TypeName>
</Field>
<Field Name="LargeImageContentType">
<DataField>LargeImageContentType</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>MyDatasource</DataSourceName>
<CommandText>SELECT LargeImageData, LargeImageContentType
FROM sft_Logo
WHERE (OrganizationKey = 0)</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="AccountEmailData">
<Fields>
<Field Name="AccountName">
<DataField>AccountName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FullName">
<DataField>FullName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Email">
<DataField>Email</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>MyDatasource</DataSourceName>
<CommandText>SELECT bus_Account.AccountName,
bus_Account.CompanyName, bus_Account.LastName + N', ' +
bus_Account.FirstName AS FullName,
bus_Account_Email.Email
FROM bus_Account INNER JOIN
bus_Account_Email ON bus_Account.AccountID =bus_Account_Email.AccountID</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>0.5in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>8.5in</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<Description>This report details the email addresses for the accounts in
the system.</Description>
<PageWidth>11in</PageWidth>
<rd:ReportID>0965746d-9b59-46d8-b847-6f031c160d74</rd:ReportID>
<PageFooter>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Right</TextAlign>
<Color>DarkSlateBlue</Color>
</Style>
<ZIndex>3</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3in</Width>
<Value>="Page " & Globals!PageNumber & " of " &
Globals!TotalPages</Value>
<Left>6.95in</Left>
</Textbox>
<Textbox Name="FooterCompany">
<Style>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Left</TextAlign>
<Color>DarkSlateBlue</Color>
</Style>
<ZIndex>2</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3in</Width>
<Value>="Administrative Report: " & Globals!ReportName</Value>
<Left>0.05in</Left>
</Textbox>
<Textbox Name="FooterDate">
<Style>
<PaddingLeft>0in</PaddingLeft>
<Format>D</Format>
<BackgroundColor>White</BackgroundColor>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Center</TextAlign>
<Color>DarkSlateBlue</Color>
<PaddingBottom>0in</PaddingBottom>
<PaddingTop>0in</PaddingTop>
<PaddingRight>0in</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3.9in</Width>
<Value>="Reporting Date: " & Globals.ExecutionTime</Value>
<Left>3.05in</Left>
</Textbox>
<Line Name="line1">
<Top>0.05396in</Top>
<Height>0in</Height>
<Style>
<BorderColor>
<Default>Firebrick</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Line>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.4in</Height>
</PageFooter>
<BottomMargin>0.5in</BottomMargin>
<Language>en-US</Language>
</Report>
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Did you republish your reports after installing SP1? Can you post your
RDL,
> or better, repro the issue against the sample databases?
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > Albert? Help! : )
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > First of all, thanks Albert for helping me with this issue.
> > >
> > > I had the trial version of Report Services installed on my development
> > > machine. I have account information with email addresses stored in
SQL
> > > Server 2000 SP3. I created a very basic report that consisted of a
> table
> > > that displayed the account names and email addresses. Everything
worked
> > > fine in the design environment, Report Manager, and deployed it to my
> > > asp.net application.
> > >
> > > Due to some hidden parameter issues, I had to install RS SP1. The
> report
> > > that required the fix worked great, however my Account Email does not
> work
> > > anymore in the Report Manager or in my application. It does work in
the
> > > design environment though. Really strange. I have several reports
with
> > the
> > > same issue.
> > >
> > > I uninstalled Report Services completely and reinstalled without SP1
and
> > > everything worked fine again. As soon as I installed SP1 the same
issue
> > > occurred. Please see the following error:
> > >
> > >
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown. (rrRenderingError) Get Online Help
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown.
> > > a.. Data is Null. This method or property cannot be called on Null
> > > values.
> > >
> > >
> > >
> > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > Then you don't have a private assembly cache. The problems must be
> due
> > to
> > > > another reason. Could you please details about the specific problem
> you
> > > are
> > > > having?
> > > >
> > > > --
> > > > Albert Yen
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > I located my Application Data folder but I do not have an
"assembly"
> > > > folder.
> > > > > I even have all of the hidden folders showing and I don't have it?
> > > > >
> > > > >
> > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
message
> > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > To clear your private assembly cache, delete the folder
> C:\Documents
> > > and
> > > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > > >
> > > > > > --
> > > > > > Albert Yen
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > > rights.
> > > > > >
> > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
message
> > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > I have several reports that worked pre-sp1. Now I receive
> > Reporting
> > > > > > errors
> > > > > > > such as Data is Null, etc. I believe it may have to do with
the
> > > > cached
> > > > > > > copies of the old assemblies based on the searching I have
done
> > > > > throughout
> > > > > > > this newsgroup. I even re-installed Report Services and
didn't
> > > apply
> > > > > the
> > > > > > > patch and the reports worked fine again. I require the hidden
> > > > parameter
> > > > > > > functionality of SP1.
> > > > > > >
> > > > > > > Can someone please explain to me how to clear old assemblies?
> > > > > > >
> > > > > > > Shawn
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||The problem is probably caused by the expression for the MIMEType of
imgLogo. This expression should be enclosed in the First() aggregate as it
is outside the scope of any dataregion, e.g.
=First(Fields!LargeImageContentType.Value, "LogoData")
Also make sure that the value returned from the expression is a supported
MIME type and does not have leading or trailing blanks.
The message you received is due to a problem on our part. We found that you
get this exception whenever the MIMEType expression cannot be evaluated or
is a not valid MIME type. We'll look at fixing this in a future release.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:#SADNL3aEHA.3820@.tk2msftngp13.phx.gbl...
> I had originally designed my reports in the pre-SP1 Report services. I
> reinstalled Report Services from scratch, (after a complete uninstall),
then
> immediately installed SP1. Once it was finished I uploaded the old
reports
> via the Report Manager. Please note the following RDL...
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > Did you republish your reports after installing SP1? Can you post your
> RDL,
> > or better, repro the issue against the sample databases?
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > Albert? Help! : )
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > > First of all, thanks Albert for helping me with this issue.
> > > >
> > > > I had the trial version of Report Services installed on my
development
> > > > machine. I have account information with email addresses stored in
> SQL
> > > > Server 2000 SP3. I created a very basic report that consisted of a
> > table
> > > > that displayed the account names and email addresses. Everything
> worked
> > > > fine in the design environment, Report Manager, and deployed it to
my
> > > > asp.net application.
> > > >
> > > > Due to some hidden parameter issues, I had to install RS SP1. The
> > report
> > > > that required the fix worked great, however my Account Email does
not
> > work
> > > > anymore in the Report Manager or in my application. It does work in
> the
> > > > design environment though. Really strange. I have several reports
> with
> > > the
> > > > same issue.
> > > >
> > > > I uninstalled Report Services completely and reinstalled without SP1
> and
> > > > everything worked fine again. As soon as I installed SP1 the same
> issue
> > > > occurred. Please see the following error:
> > > >
> > > >
> > > > Exception of type
> > > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was
> > > > thrown. (rrRenderingError) Get Online Help
> > > > a.. Exception of type
> > > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was
> > > > thrown.
> > > > a.. Data is Null. This method or property cannot be called on
Null
> > > > values.
> > > >
> > > >
> > > >
> > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > > Then you don't have a private assembly cache. The problems must
be
> > due
> > > to
> > > > > another reason. Could you please details about the specific
problem
> > you
> > > > are
> > > > > having?
> > > > >
> > > > > --
> > > > > Albert Yen
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > >
> > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > > I located my Application Data folder but I do not have an
> "assembly"
> > > > > folder.
> > > > > > I even have all of the hidden folders showing and I don't have
it?
> > > > > >
> > > > > >
> > > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
> message
> > > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > > To clear your private assembly cache, delete the folder
> > C:\Documents
> > > > and
> > > > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > > > >
> > > > > > > --
> > > > > > > Albert Yen
> > > > > > > SQL Server Reporting Services
> > > > > > >
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > > rights.
> > > > > > >
> > > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
> message
> > > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > > I have several reports that worked pre-sp1. Now I receive
> > > Reporting
> > > > > > > errors
> > > > > > > > such as Data is Null, etc. I believe it may have to do with
> the
> > > > > cached
> > > > > > > > copies of the old assemblies based on the searching I have
> done
> > > > > > throughout
> > > > > > > > this newsgroup. I even re-installed Report Services and
> didn't
> > > > apply
> > > > > > the
> > > > > > > > patch and the reports worked fine again. I require the
hidden
> > > > > parameter
> > > > > > > > functionality of SP1.
> > > > > > > >
> > > > > > > > Can someone please explain to me how to clear old
assemblies?
> > > > > > > >
> > > > > > > > Shawn
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||YAY!!!! Thank you!! That was driving me nuts! I made the changes and it
worked again.
I really appreciate you helping me Albert
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:eiQW5B5aEHA.3352@.TK2MSFTNGP10.phx.gbl...
> The problem is probably caused by the expression for the MIMEType of
> imgLogo. This expression should be enclosed in the First() aggregate as
it
> is outside the scope of any dataregion, e.g.
> =First(Fields!LargeImageContentType.Value, "LogoData")
> Also make sure that the value returned from the expression is a supported
> MIME type and does not have leading or trailing blanks.
> The message you received is due to a problem on our part. We found that
you
> get this exception whenever the MIMEType expression cannot be evaluated or
> is a not valid MIME type. We'll look at fixing this in a future release.
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:#SADNL3aEHA.3820@.tk2msftngp13.phx.gbl...
> > I had originally designed my reports in the pre-SP1 Report services. I
> > reinstalled Report Services from scratch, (after a complete uninstall),
> then
> > immediately installed SP1. Once it was finished I uploaded the old
> reports
> > via the Report Manager. Please note the following RDL...
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > > Did you republish your reports after installing SP1? Can you post
your
> > RDL,
> > > or better, repro the issue against the sample databases?
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > > Albert? Help! : )
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > > > First of all, thanks Albert for helping me with this issue.
> > > > >
> > > > > I had the trial version of Report Services installed on my
> development
> > > > > machine. I have account information with email addresses stored
in
> > SQL
> > > > > Server 2000 SP3. I created a very basic report that consisted of
a
> > > table
> > > > > that displayed the account names and email addresses. Everything
> > worked
> > > > > fine in the design environment, Report Manager, and deployed it to
> my
> > > > > asp.net application.
> > > > >
> > > > > Due to some hidden parameter issues, I had to install RS SP1. The
> > > report
> > > > > that required the fix worked great, however my Account Email does
> not
> > > work
> > > > > anymore in the Report Manager or in my application. It does work
in
> > the
> > > > > design environment though. Really strange. I have several
reports
> > with
> > > > the
> > > > > same issue.
> > > > >
> > > > > I uninstalled Report Services completely and reinstalled without
SP1
> > and
> > > > > everything worked fine again. As soon as I installed SP1 the same
> > issue
> > > > > occurred. Please see the following error:
> > > > >
> > > > >
> > > > > Exception of type
> > > > >
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was
> > > > > thrown. (rrRenderingError) Get Online Help
> > > > > a.. Exception of type
> > > > >
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was
> > > > > thrown.
> > > > > a.. Data is Null. This method or property cannot be called on
> Null
> > > > > values.
> > > > >
> > > > >
> > > > >
> > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
message
> > > > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > > > Then you don't have a private assembly cache. The problems must
> be
> > > due
> > > > to
> > > > > > another reason. Could you please details about the specific
> problem
> > > you
> > > > > are
> > > > > > having?
> > > > > >
> > > > > > --
> > > > > > Albert Yen
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > > rights.
> > > > > >
> > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
message
> > > > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > > > I located my Application Data folder but I do not have an
> > "assembly"
> > > > > > folder.
> > > > > > > I even have all of the hidden folders showing and I don't have
> it?
> > > > > > >
> > > > > > >
> > > > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
> > message
> > > > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > > > To clear your private assembly cache, delete the folder
> > > C:\Documents
> > > > > and
> > > > > > > > Settings\<username>\Local Settings\Application Data\assembly
.
> > > > > > > >
> > > > > > > > --
> > > > > > > > Albert Yen
> > > > > > > > SQL Server Reporting Services
> > > > > > > >
> > > > > > > > This posting is provided "AS IS" with no warranties, and
> confers
> > > no
> > > > > > > rights.
> > > > > > > >
> > > > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
> > message
> > > > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > > > I have several reports that worked pre-sp1. Now I receive
> > > > Reporting
> > > > > > > > errors
> > > > > > > > > such as Data is Null, etc. I believe it may have to do
with
> > the
> > > > > > cached
> > > > > > > > > copies of the old assemblies based on the searching I have
> > done
> > > > > > > throughout
> > > > > > > > > this newsgroup. I even re-installed Report Services and
> > didn't
> > > > > apply
> > > > > > > the
> > > > > > > > > patch and the reports worked fine again. I require the
> hidden
> > > > > > parameter
> > > > > > > > > functionality of SP1.
> > > > > > > > >
> > > > > > > > > Can someone please explain to me how to clear old
> assemblies?
> > > > > > > > >
> > > > > > > > > Shawn
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
such as Data is Null, etc. I believe it may have to do with the cached
copies of the old assemblies based on the searching I have done throughout
this newsgroup. I even re-installed Report Services and didn't apply the
patch and the reports worked fine again. I require the hidden parameter
functionality of SP1.
Can someone please explain to me how to clear old assemblies?
ShawnTo clear your private assembly cache, delete the folder C:\Documents and
Settings\<username>\Local Settings\Application Data\assembly .
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> I have several reports that worked pre-sp1. Now I receive Reporting
errors
> such as Data is Null, etc. I believe it may have to do with the cached
> copies of the old assemblies based on the searching I have done throughout
> this newsgroup. I even re-installed Report Services and didn't apply the
> patch and the reports worked fine again. I require the hidden parameter
> functionality of SP1.
> Can someone please explain to me how to clear old assemblies?
> Shawn
>|||I located my Application Data folder but I do not have an "assembly" folder.
I even have all of the hidden folders showing and I don't have it?
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> To clear your private assembly cache, delete the folder C:\Documents and
> Settings\<username>\Local Settings\Application Data\assembly .
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > I have several reports that worked pre-sp1. Now I receive Reporting
> errors
> > such as Data is Null, etc. I believe it may have to do with the cached
> > copies of the old assemblies based on the searching I have done
throughout
> > this newsgroup. I even re-installed Report Services and didn't apply
the
> > patch and the reports worked fine again. I require the hidden parameter
> > functionality of SP1.
> >
> > Can someone please explain to me how to clear old assemblies?
> >
> > Shawn
> >
> >
>|||Then you don't have a private assembly cache. The problems must be due to
another reason. Could you please details about the specific problem you are
having?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> I located my Application Data folder but I do not have an "assembly"
folder.
> I even have all of the hidden folders showing and I don't have it?
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > To clear your private assembly cache, delete the folder C:\Documents and
> > Settings\<username>\Local Settings\Application Data\assembly .
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > I have several reports that worked pre-sp1. Now I receive Reporting
> > errors
> > > such as Data is Null, etc. I believe it may have to do with the
cached
> > > copies of the old assemblies based on the searching I have done
> throughout
> > > this newsgroup. I even re-installed Report Services and didn't apply
> the
> > > patch and the reports worked fine again. I require the hidden
parameter
> > > functionality of SP1.
> > >
> > > Can someone please explain to me how to clear old assemblies?
> > >
> > > Shawn
> > >
> > >
> >
> >
>|||First of all, thanks Albert for helping me with this issue.
I had the trial version of Report Services installed on my development
machine. I have account information with email addresses stored in SQL
Server 2000 SP3. I created a very basic report that consisted of a table
that displayed the account names and email addresses. Everything worked
fine in the design environment, Report Manager, and deployed it to my
asp.net application.
Due to some hidden parameter issues, I had to install RS SP1. The report
that required the fix worked great, however my Account Email does not work
anymore in the Report Manager or in my application. It does work in the
design environment though. Really strange. I have several reports with the
same issue.
I uninstalled Report Services completely and reinstalled without SP1 and
everything worked fine again. As soon as I installed SP1 the same issue
occurred. Please see the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Data is Null. This method or property cannot be called on Null
values.
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> Then you don't have a private assembly cache. The problems must be due to
> another reason. Could you please details about the specific problem you
are
> having?
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > I located my Application Data folder but I do not have an "assembly"
> folder.
> > I even have all of the hidden folders showing and I don't have it?
> >
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > To clear your private assembly cache, delete the folder C:\Documents
and
> > > Settings\<username>\Local Settings\Application Data\assembly .
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > I have several reports that worked pre-sp1. Now I receive Reporting
> > > errors
> > > > such as Data is Null, etc. I believe it may have to do with the
> cached
> > > > copies of the old assemblies based on the searching I have done
> > throughout
> > > > this newsgroup. I even re-installed Report Services and didn't
apply
> > the
> > > > patch and the reports worked fine again. I require the hidden
> parameter
> > > > functionality of SP1.
> > > >
> > > > Can someone please explain to me how to clear old assemblies?
> > > >
> > > > Shawn
> > > >
> > > >
> > >
> > >
> >
> >
>|||Albert? Help! : )
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> First of all, thanks Albert for helping me with this issue.
> I had the trial version of Report Services installed on my development
> machine. I have account information with email addresses stored in SQL
> Server 2000 SP3. I created a very basic report that consisted of a table
> that displayed the account names and email addresses. Everything worked
> fine in the design environment, Report Manager, and deployed it to my
> asp.net application.
> Due to some hidden parameter issues, I had to install RS SP1. The report
> that required the fix worked great, however my Account Email does not work
> anymore in the Report Manager or in my application. It does work in the
> design environment though. Really strange. I have several reports with
the
> same issue.
> I uninstalled Report Services completely and reinstalled without SP1 and
> everything worked fine again. As soon as I installed SP1 the same issue
> occurred. Please see the following error:
>
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Data is Null. This method or property cannot be called on Null
> values.
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > Then you don't have a private assembly cache. The problems must be due
to
> > another reason. Could you please details about the specific problem you
> are
> > having?
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > I located my Application Data folder but I do not have an "assembly"
> > folder.
> > > I even have all of the hidden folders showing and I don't have it?
> > >
> > >
> > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > To clear your private assembly cache, delete the folder C:\Documents
> and
> > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > >
> > > > --
> > > > Albert Yen
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > I have several reports that worked pre-sp1. Now I receive
Reporting
> > > > errors
> > > > > such as Data is Null, etc. I believe it may have to do with the
> > cached
> > > > > copies of the old assemblies based on the searching I have done
> > > throughout
> > > > > this newsgroup. I even re-installed Report Services and didn't
> apply
> > > the
> > > > > patch and the reports worked fine again. I require the hidden
> > parameter
> > > > > functionality of SP1.
> > > > >
> > > > > Can someone please explain to me how to clear old assemblies?
> > > > >
> > > > > Shawn
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Did you republish your reports after installing SP1? Can you post your RDL,
or better, repro the issue against the sample databases?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Albert? Help! : )
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > First of all, thanks Albert for helping me with this issue.
> >
> > I had the trial version of Report Services installed on my development
> > machine. I have account information with email addresses stored in SQL
> > Server 2000 SP3. I created a very basic report that consisted of a
table
> > that displayed the account names and email addresses. Everything worked
> > fine in the design environment, Report Manager, and deployed it to my
> > asp.net application.
> >
> > Due to some hidden parameter issues, I had to install RS SP1. The
report
> > that required the fix worked great, however my Account Email does not
work
> > anymore in the Report Manager or in my application. It does work in the
> > design environment though. Really strange. I have several reports with
> the
> > same issue.
> >
> > I uninstalled Report Services completely and reinstalled without SP1 and
> > everything worked fine again. As soon as I installed SP1 the same issue
> > occurred. Please see the following error:
> >
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > a.. Data is Null. This method or property cannot be called on Null
> > values.
> >
> >
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > Then you don't have a private assembly cache. The problems must be
due
> to
> > > another reason. Could you please details about the specific problem
you
> > are
> > > having?
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > I located my Application Data folder but I do not have an "assembly"
> > > folder.
> > > > I even have all of the hidden folders showing and I don't have it?
> > > >
> > > >
> > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > To clear your private assembly cache, delete the folder
C:\Documents
> > and
> > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > >
> > > > > --
> > > > > Albert Yen
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > >
> > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > I have several reports that worked pre-sp1. Now I receive
> Reporting
> > > > > errors
> > > > > > such as Data is Null, etc. I believe it may have to do with the
> > > cached
> > > > > > copies of the old assemblies based on the searching I have done
> > > > throughout
> > > > > > this newsgroup. I even re-installed Report Services and didn't
> > apply
> > > > the
> > > > > > patch and the reports worked fine again. I require the hidden
> > > parameter
> > > > > > functionality of SP1.
> > > > > >
> > > > > > Can someone please explain to me how to clear old assemblies?
> > > > > >
> > > > > > Shawn
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I had originally designed my reports in the pre-SP1 Report services. I
reinstalled Report Services from scratch, (after a complete uninstall), then
immediately installed SP1. Once it was finished I uploaded the old reports
via the Report Manager. Please note the following RDL...
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<rd:GridSpacing>0.1in</rd:GridSpacing>
<RightMargin>0.5in</RightMargin>
<Author>Shawn Trevellick</Author>
<Body>
<ReportItems>
<Textbox Name="Title">
<Style>
<FontFamily>Verdana</FontFamily>
<FontSize>22pt</FontSize>
<TextAlign>Center</TextAlign>
<Color>DarkSlateBlue</Color>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>2</ZIndex>
<Top>0.75in</Top>
<Height>0.5in</Height>
<CanGrow>true</CanGrow>
<Value>= Globals!ReportName</Value>
</Textbox>
<Image Name="imgLogo">
<ZIndex>1</ZIndex>
<MIMEType>= Fields!LargeImageContentType.Value</MIMEType>
<Height>0.3in</Height>
<Source>Database</Source>
<Style />
<Value>=First(Fields!LargeImageData.Value, "LogoData")</Value>
<Sizing>AutoSize</Sizing>
</Image>
<Table Name="table1">
<Height>0.95in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.3in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>15</ZIndex>
<CanGrow>true</CanGrow>
<Value>Account Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Value>Company Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Value>Contact Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Value>Email Address</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.2in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Email">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoration>Underline</TextDecoration>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Email</rd:DefaultName>
<Action>
<Hyperlink>="mailto:" +
Fields!Email.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!Email.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<Sorting>
<SortBy>
<SortExpression>=Fields!AccountName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</Details>
<DataSetName>AccountEmailData</DataSetName>
<Top>1.5in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.2in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="AccountName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>AccountName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!AccountName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<rd:DefaultName>CompanyName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CompanyName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="FullName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>FullName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!FullName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<Label>=Fields!AccountName.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!AccountName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox10</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox13</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<TableColumns>
<TableColumn>
<Width>2.1in</Width>
</TableColumn>
<TableColumn>
<Width>2.3in</Width>
</TableColumn>
<TableColumn>
<Width>2in</Width>
</TableColumn>
<TableColumn>
<Width>3.6in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2.5in</Height>
</Body>
<TopMargin>0.5in</TopMargin>
<DataSources>
<DataSource Name="MyDatasource">
<rd:DataSourceID>dd7d0594-fe10-4986-af0c-2b371fb647c3</rd:DataSourceID>
<DataSourceReference>MyDatasource</DataSourceReference>
</DataSource>
</DataSources>
<Code />
<Width>10in</Width>
<DataSets>
<DataSet Name="LogoData">
<Fields>
<Field Name="LargeImageData">
<DataField>LargeImageData</DataField>
<rd:TypeName>System.Byte[]</rd:TypeName>
</Field>
<Field Name="LargeImageContentType">
<DataField>LargeImageContentType</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>MyDatasource</DataSourceName>
<CommandText>SELECT LargeImageData, LargeImageContentType
FROM sft_Logo
WHERE (OrganizationKey = 0)</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="AccountEmailData">
<Fields>
<Field Name="AccountName">
<DataField>AccountName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FullName">
<DataField>FullName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Email">
<DataField>Email</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>MyDatasource</DataSourceName>
<CommandText>SELECT bus_Account.AccountName,
bus_Account.CompanyName, bus_Account.LastName + N', ' +
bus_Account.FirstName AS FullName,
bus_Account_Email.Email
FROM bus_Account INNER JOIN
bus_Account_Email ON bus_Account.AccountID =bus_Account_Email.AccountID</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>0.5in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>8.5in</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<Description>This report details the email addresses for the accounts in
the system.</Description>
<PageWidth>11in</PageWidth>
<rd:ReportID>0965746d-9b59-46d8-b847-6f031c160d74</rd:ReportID>
<PageFooter>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Right</TextAlign>
<Color>DarkSlateBlue</Color>
</Style>
<ZIndex>3</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3in</Width>
<Value>="Page " & Globals!PageNumber & " of " &
Globals!TotalPages</Value>
<Left>6.95in</Left>
</Textbox>
<Textbox Name="FooterCompany">
<Style>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Left</TextAlign>
<Color>DarkSlateBlue</Color>
</Style>
<ZIndex>2</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3in</Width>
<Value>="Administrative Report: " & Globals!ReportName</Value>
<Left>0.05in</Left>
</Textbox>
<Textbox Name="FooterDate">
<Style>
<PaddingLeft>0in</PaddingLeft>
<Format>D</Format>
<BackgroundColor>White</BackgroundColor>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Center</TextAlign>
<Color>DarkSlateBlue</Color>
<PaddingBottom>0in</PaddingBottom>
<PaddingTop>0in</PaddingTop>
<PaddingRight>0in</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3.9in</Width>
<Value>="Reporting Date: " & Globals.ExecutionTime</Value>
<Left>3.05in</Left>
</Textbox>
<Line Name="line1">
<Top>0.05396in</Top>
<Height>0in</Height>
<Style>
<BorderColor>
<Default>Firebrick</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Line>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.4in</Height>
</PageFooter>
<BottomMargin>0.5in</BottomMargin>
<Language>en-US</Language>
</Report>
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Did you republish your reports after installing SP1? Can you post your
RDL,
> or better, repro the issue against the sample databases?
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > Albert? Help! : )
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > First of all, thanks Albert for helping me with this issue.
> > >
> > > I had the trial version of Report Services installed on my development
> > > machine. I have account information with email addresses stored in
SQL
> > > Server 2000 SP3. I created a very basic report that consisted of a
> table
> > > that displayed the account names and email addresses. Everything
worked
> > > fine in the design environment, Report Manager, and deployed it to my
> > > asp.net application.
> > >
> > > Due to some hidden parameter issues, I had to install RS SP1. The
> report
> > > that required the fix worked great, however my Account Email does not
> work
> > > anymore in the Report Manager or in my application. It does work in
the
> > > design environment though. Really strange. I have several reports
with
> > the
> > > same issue.
> > >
> > > I uninstalled Report Services completely and reinstalled without SP1
and
> > > everything worked fine again. As soon as I installed SP1 the same
issue
> > > occurred. Please see the following error:
> > >
> > >
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown. (rrRenderingError) Get Online Help
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown.
> > > a.. Data is Null. This method or property cannot be called on Null
> > > values.
> > >
> > >
> > >
> > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > Then you don't have a private assembly cache. The problems must be
> due
> > to
> > > > another reason. Could you please details about the specific problem
> you
> > > are
> > > > having?
> > > >
> > > > --
> > > > Albert Yen
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > I located my Application Data folder but I do not have an
"assembly"
> > > > folder.
> > > > > I even have all of the hidden folders showing and I don't have it?
> > > > >
> > > > >
> > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
message
> > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > To clear your private assembly cache, delete the folder
> C:\Documents
> > > and
> > > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > > >
> > > > > > --
> > > > > > Albert Yen
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > > rights.
> > > > > >
> > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
message
> > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > I have several reports that worked pre-sp1. Now I receive
> > Reporting
> > > > > > errors
> > > > > > > such as Data is Null, etc. I believe it may have to do with
the
> > > > cached
> > > > > > > copies of the old assemblies based on the searching I have
done
> > > > > throughout
> > > > > > > this newsgroup. I even re-installed Report Services and
didn't
> > > apply
> > > > > the
> > > > > > > patch and the reports worked fine again. I require the hidden
> > > > parameter
> > > > > > > functionality of SP1.
> > > > > > >
> > > > > > > Can someone please explain to me how to clear old assemblies?
> > > > > > >
> > > > > > > Shawn
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||The problem is probably caused by the expression for the MIMEType of
imgLogo. This expression should be enclosed in the First() aggregate as it
is outside the scope of any dataregion, e.g.
=First(Fields!LargeImageContentType.Value, "LogoData")
Also make sure that the value returned from the expression is a supported
MIME type and does not have leading or trailing blanks.
The message you received is due to a problem on our part. We found that you
get this exception whenever the MIMEType expression cannot be evaluated or
is a not valid MIME type. We'll look at fixing this in a future release.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:#SADNL3aEHA.3820@.tk2msftngp13.phx.gbl...
> I had originally designed my reports in the pre-SP1 Report services. I
> reinstalled Report Services from scratch, (after a complete uninstall),
then
> immediately installed SP1. Once it was finished I uploaded the old
reports
> via the Report Manager. Please note the following RDL...
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > Did you republish your reports after installing SP1? Can you post your
> RDL,
> > or better, repro the issue against the sample databases?
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > Albert? Help! : )
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > > First of all, thanks Albert for helping me with this issue.
> > > >
> > > > I had the trial version of Report Services installed on my
development
> > > > machine. I have account information with email addresses stored in
> SQL
> > > > Server 2000 SP3. I created a very basic report that consisted of a
> > table
> > > > that displayed the account names and email addresses. Everything
> worked
> > > > fine in the design environment, Report Manager, and deployed it to
my
> > > > asp.net application.
> > > >
> > > > Due to some hidden parameter issues, I had to install RS SP1. The
> > report
> > > > that required the fix worked great, however my Account Email does
not
> > work
> > > > anymore in the Report Manager or in my application. It does work in
> the
> > > > design environment though. Really strange. I have several reports
> with
> > > the
> > > > same issue.
> > > >
> > > > I uninstalled Report Services completely and reinstalled without SP1
> and
> > > > everything worked fine again. As soon as I installed SP1 the same
> issue
> > > > occurred. Please see the following error:
> > > >
> > > >
> > > > Exception of type
> > > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was
> > > > thrown. (rrRenderingError) Get Online Help
> > > > a.. Exception of type
> > > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was
> > > > thrown.
> > > > a.. Data is Null. This method or property cannot be called on
Null
> > > > values.
> > > >
> > > >
> > > >
> > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > > Then you don't have a private assembly cache. The problems must
be
> > due
> > > to
> > > > > another reason. Could you please details about the specific
problem
> > you
> > > > are
> > > > > having?
> > > > >
> > > > > --
> > > > > Albert Yen
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > >
> > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > > I located my Application Data folder but I do not have an
> "assembly"
> > > > > folder.
> > > > > > I even have all of the hidden folders showing and I don't have
it?
> > > > > >
> > > > > >
> > > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
> message
> > > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > > To clear your private assembly cache, delete the folder
> > C:\Documents
> > > > and
> > > > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > > > >
> > > > > > > --
> > > > > > > Albert Yen
> > > > > > > SQL Server Reporting Services
> > > > > > >
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > > rights.
> > > > > > >
> > > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
> message
> > > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > > I have several reports that worked pre-sp1. Now I receive
> > > Reporting
> > > > > > > errors
> > > > > > > > such as Data is Null, etc. I believe it may have to do with
> the
> > > > > cached
> > > > > > > > copies of the old assemblies based on the searching I have
> done
> > > > > > throughout
> > > > > > > > this newsgroup. I even re-installed Report Services and
> didn't
> > > > apply
> > > > > > the
> > > > > > > > patch and the reports worked fine again. I require the
hidden
> > > > > parameter
> > > > > > > > functionality of SP1.
> > > > > > > >
> > > > > > > > Can someone please explain to me how to clear old
assemblies?
> > > > > > > >
> > > > > > > > Shawn
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||YAY!!!! Thank you!! That was driving me nuts! I made the changes and it
worked again.
I really appreciate you helping me Albert
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:eiQW5B5aEHA.3352@.TK2MSFTNGP10.phx.gbl...
> The problem is probably caused by the expression for the MIMEType of
> imgLogo. This expression should be enclosed in the First() aggregate as
it
> is outside the scope of any dataregion, e.g.
> =First(Fields!LargeImageContentType.Value, "LogoData")
> Also make sure that the value returned from the expression is a supported
> MIME type and does not have leading or trailing blanks.
> The message you received is due to a problem on our part. We found that
you
> get this exception whenever the MIMEType expression cannot be evaluated or
> is a not valid MIME type. We'll look at fixing this in a future release.
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:#SADNL3aEHA.3820@.tk2msftngp13.phx.gbl...
> > I had originally designed my reports in the pre-SP1 Report services. I
> > reinstalled Report Services from scratch, (after a complete uninstall),
> then
> > immediately installed SP1. Once it was finished I uploaded the old
> reports
> > via the Report Manager. Please note the following RDL...
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > > Did you republish your reports after installing SP1? Can you post
your
> > RDL,
> > > or better, repro the issue against the sample databases?
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > > Albert? Help! : )
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > > > First of all, thanks Albert for helping me with this issue.
> > > > >
> > > > > I had the trial version of Report Services installed on my
> development
> > > > > machine. I have account information with email addresses stored
in
> > SQL
> > > > > Server 2000 SP3. I created a very basic report that consisted of
a
> > > table
> > > > > that displayed the account names and email addresses. Everything
> > worked
> > > > > fine in the design environment, Report Manager, and deployed it to
> my
> > > > > asp.net application.
> > > > >
> > > > > Due to some hidden parameter issues, I had to install RS SP1. The
> > > report
> > > > > that required the fix worked great, however my Account Email does
> not
> > > work
> > > > > anymore in the Report Manager or in my application. It does work
in
> > the
> > > > > design environment though. Really strange. I have several
reports
> > with
> > > > the
> > > > > same issue.
> > > > >
> > > > > I uninstalled Report Services completely and reinstalled without
SP1
> > and
> > > > > everything worked fine again. As soon as I installed SP1 the same
> > issue
> > > > > occurred. Please see the following error:
> > > > >
> > > > >
> > > > > Exception of type
> > > > >
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was
> > > > > thrown. (rrRenderingError) Get Online Help
> > > > > a.. Exception of type
> > > > >
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was
> > > > > thrown.
> > > > > a.. Data is Null. This method or property cannot be called on
> Null
> > > > > values.
> > > > >
> > > > >
> > > > >
> > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
message
> > > > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > > > Then you don't have a private assembly cache. The problems must
> be
> > > due
> > > > to
> > > > > > another reason. Could you please details about the specific
> problem
> > > you
> > > > > are
> > > > > > having?
> > > > > >
> > > > > > --
> > > > > > Albert Yen
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > > rights.
> > > > > >
> > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
message
> > > > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > > > I located my Application Data folder but I do not have an
> > "assembly"
> > > > > > folder.
> > > > > > > I even have all of the hidden folders showing and I don't have
> it?
> > > > > > >
> > > > > > >
> > > > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
> > message
> > > > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > > > To clear your private assembly cache, delete the folder
> > > C:\Documents
> > > > > and
> > > > > > > > Settings\<username>\Local Settings\Application Data\assembly
.
> > > > > > > >
> > > > > > > > --
> > > > > > > > Albert Yen
> > > > > > > > SQL Server Reporting Services
> > > > > > > >
> > > > > > > > This posting is provided "AS IS" with no warranties, and
> confers
> > > no
> > > > > > > rights.
> > > > > > > >
> > > > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
> > message
> > > > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > > > I have several reports that worked pre-sp1. Now I receive
> > > > Reporting
> > > > > > > > errors
> > > > > > > > > such as Data is Null, etc. I believe it may have to do
with
> > the
> > > > > > cached
> > > > > > > > > copies of the old assemblies based on the searching I have
> > done
> > > > > > > throughout
> > > > > > > > > this newsgroup. I even re-installed Report Services and
> > didn't
> > > > > apply
> > > > > > > the
> > > > > > > > > patch and the reports worked fine again. I require the
> hidden
> > > > > > parameter
> > > > > > > > > functionality of SP1.
> > > > > > > > >
> > > > > > > > > Can someone please explain to me how to clear old
> assemblies?
> > > > > > > > >
> > > > > > > > > Shawn
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
Subscribe to:
Posts (Atom)