Showing posts with label failed. Show all posts
Showing posts with label failed. Show all posts

Tuesday, March 27, 2012

cannot remove repl... cannot delete database

I cannot delete a database becuase it ways its part of replication. I
removed replication via the EM GUI but it failed. All GUI elements are gone
but when I run sp_removedbreplication in query analyzer I get this:
Server: Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'HesstechUser.conflict_MergeReplLIVE_VendorCustome r',
because it does not exist in the system catalog.
the weird thing is that the table mentioned in the error should not (and
does not to my knowledge) exist in this database? it exists in a different
database on the same system?
any help is greatly appreciated.
As far as I experienced it, SQL Server 2000 (at least SP3 and SP3a) does not
handle correctly merge replication of tables owned not by dbo. Various merge
replication related actions are failing because of that. One you just
mentioned - you can not properly drop merge replication, because it leaves
conflict tables. As you noticed from error message it tries to drop table
'HesstechUser.conflict_MergeReplLIVE_VendorCustome r'. I guess on your
published database you should find table
'dbo.conflict_MergeReplLIVE_VendorCustomer'.
If you can find it then I can provide you with a solution to this problem -
but it means fixing of couple of system stored procedures. Fixes are
straight forward - correct handling of object owners.
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"djc" <noone@.nowhere.com> wrote in message
news:OdhjTNDZEHA.2944@.TK2MSFTNGP11.phx.gbl...
> I cannot delete a database becuase it ways its part of replication. I
> removed replication via the EM GUI but it failed. All GUI elements are
gone
> but when I run sp_removedbreplication in query analyzer I get this:
> Server: Msg 3701, Level 11, State 5, Line 1
> Cannot drop the table
'HesstechUser.conflict_MergeReplLIVE_VendorCustome r',
> because it does not exist in the system catalog.
> the weird thing is that the table mentioned in the error should not (and
> does not to my knowledge) exist in this database? it exists in a different
> database on the same system?
> any help is greatly appreciated.
>
|||thanks for the info...
1) I ran a script posted by Hilary Cotter (thank you Hilary!) that I think
cleaned things up for me... BUT it will only happen again due to the issue
you just informed me about. So I am VERY interested in finding out how to
correct this. Please do let me know.
2) Can I change the owner of tables? if so how? The only reason they are not
owned by dbo is due to how our db person moved them to sql server from MS
Access. I would like them to be owned by dbo.
any help is GREATLY appreciated.
thanks!
"Kestutis Adomavicius" <kicker@.nospam-mail.lt> wrote in message
news:%234qLmOLZEHA.3596@.tk2msftngp13.phx.gbl...
> As far as I experienced it, SQL Server 2000 (at least SP3 and SP3a) does
not
> handle correctly merge replication of tables owned not by dbo. Various
merge
> replication related actions are failing because of that. One you just
> mentioned - you can not properly drop merge replication, because it leaves
> conflict tables. As you noticed from error message it tries to drop table
> 'HesstechUser.conflict_MergeReplLIVE_VendorCustome r'. I guess on your
> published database you should find table
> 'dbo.conflict_MergeReplLIVE_VendorCustomer'.
> If you can find it then I can provide you with a solution to this
problem -[vbcol=seagreen]
> but it means fixing of couple of system stored procedures. Fixes are
> straight forward - correct handling of object owners.
> --
> Regards,
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
> "djc" <noone@.nowhere.com> wrote in message
> news:OdhjTNDZEHA.2944@.TK2MSFTNGP11.phx.gbl...
> gone
> 'HesstechUser.conflict_MergeReplLIVE_VendorCustome r',
different
>
|||oh one more very important question:
what else do I need to worry about due to this 'owner not being dbo'
problem? I currently have the same setup on a production server that is
about to go live. The issue I just cleaned up (I think) was on a test
server. You said 'various merge replication related actions are failing
because of that'. Is the integrity of my data in danger? can things get out
of sync? Do I need to think about stopping this from going live?
please let me know more. Thanks.
"Kestutis Adomavicius" <kicker@.nospam-mail.lt> wrote in message
news:%234qLmOLZEHA.3596@.tk2msftngp13.phx.gbl...
> As far as I experienced it, SQL Server 2000 (at least SP3 and SP3a) does
not
> handle correctly merge replication of tables owned not by dbo. Various
merge
> replication related actions are failing because of that. One you just
> mentioned - you can not properly drop merge replication, because it leaves
> conflict tables. As you noticed from error message it tries to drop table
> 'HesstechUser.conflict_MergeReplLIVE_VendorCustome r'. I guess on your
> published database you should find table
> 'dbo.conflict_MergeReplLIVE_VendorCustomer'.
> If you can find it then I can provide you with a solution to this
problem -[vbcol=seagreen]
> but it means fixing of couple of system stored procedures. Fixes are
> straight forward - correct handling of object owners.
> --
> Regards,
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
> "djc" <noone@.nowhere.com> wrote in message
> news:OdhjTNDZEHA.2944@.TK2MSFTNGP11.phx.gbl...
> gone
> 'HesstechUser.conflict_MergeReplLIVE_VendorCustome r',
different
>
|||I attached fixes to stored procedures which are designed for SQL Server 2000
SP3a
They should be executed on master database. Be careful with them, execute
parts of every script step by step.
At the end of every script there is update to sysobjects table, which
restores initial state of stored procedure (which is changed after "alter
procedure" statement is executed). So before altering procedure, check if
this update will restore correctly stored procedure status (status in update
statement should match status which you will see in resultset, received from
select statement which is commented near to update).
Those are procedures which i met on my way of deploying merge replication.
First of all I fixed four procedures, but when I added publication
filtering, I had to fix some more Now I am applying those fixes to all
new servers I am installing (where merge replication is used) and every
manipulations to merge replication are working smoothly.
Regards,
Kestas
"djc" <noone@.nowhere.com> wrote in message
news:%23d2H5xOZEHA.3368@.TK2MSFTNGP12.phx.gbl...
> thanks for the info...
> 1) I ran a script posted by Hilary Cotter (thank you Hilary!) that I think
> cleaned things up for me... BUT it will only happen again due to the issue
> you just informed me about. So I am VERY interested in finding out how to
> correct this. Please do let me know.
> 2) Can I change the owner of tables? if so how? The only reason they are
not[vbcol=seagreen]
> owned by dbo is due to how our db person moved them to sql server from MS
> Access. I would like them to be owned by dbo.
> any help is GREATLY appreciated.
> thanks!
> "Kestutis Adomavicius" <kicker@.nospam-mail.lt> wrote in message
> news:%234qLmOLZEHA.3596@.tk2msftngp13.phx.gbl...
> not
> merge
leaves[vbcol=seagreen]
table[vbcol=seagreen]
> problem -
(and
> different
>
begin 666 Merge replication fixes.zip
M4$L#!!0````(`,V0\2[413QMR"D``"R]```B````1FEX960@.+2!S<%]A9&1M
M97)G96%R=&EC;&4@.4U S+G-Q;-U];7/;1I+P9Z8J_V&JGJHEZ4 R2<FVDC5=
M4F0ZT466?)*\R=5FBP61H(0S"7 !T+*V[L<_W3WO+P`A6;G<'2NQ2&"F9Z:G
MNZ>GNZ>G7$]G>;9(;S9%P@.[YURQ>)6S,NO%RF=^QS7H>5TG9C>3KS_%R0^^'
MW6^_^>G\VV\N)L?G9^].?OIX,6&_GES]S,[_-KFX.'D[X:^__29>5DG!UD4^
M2^;83KF>QO/Y*BENDKBHTMDR^?8;!I_#]>9ZF<[B*LTS9GS*^Q+[%+&&S_-G
MS*Q-8WCV7, 5K;AU6L*5M6V89;XI9LDTO_[/9%8]&":OS41M&W)UOTX"M01D
MQ'P57R^3;A2$+'M+4!3,>5+.BG3M8C;['!>SV[CHC5Z\Z(_9V <?3TZ@.!I@.E%
M@.9[ER\TJFU9%//N49C<>Z.&@.CWU>Q,O2[3. YK79,OF<+)F"H;%<Q=6F],;I
M`M]DY7T&U&7"!^#R<<3B695^-O"Q+I+IK$B(6*:SU;P&[KS(URZ>`6XWRS,<
MBWS?G2?+I*(G5;')@. :3KH$@.V0Y'WB-Q7\YNDU7,! R-('H\S9VI!=C7:187
M][V#/OP,@.O>!RYXR#JXTFME<ETDU7:3(RK-EO"D3!U\#CK%N: R\&A/U7+:<
M%DF9+S]#@.?(=+9E%6^8JKV(B_4@.%0;\NTTS19Y#>&S>NR[;1 43P;<9:KS
M-J<26,V"%4P)40+5Z'3"!:$=&$2\G*YQ-%B^TU']I=YVWQV=7DZZ40<^T$E9
M@.:D*R$. C2PW*"7>5/DTG2<9%+F?%G%VDYA@..QY8F'"65JS*&?$NX3>#%6&'
M016HS=*2K?.R3*]-A(,4=EOI7*<W:59U[&&ZA40I!QG5+>#^-E_.L5,6D XB
M*EW<*_*9EKAV5;C"4%& -*"QX& &XWE.^."5F"H;L>%8/*MNXTJ_P.$M"IA\
M8.FR2N9"9D=LE<-+6@.5+MHKOV77"8#F#`LL8J=R4N7K"]3)A3KN]BM"@.:-4%
M:@.507&BI\7E4($0JC>_N-JEN$\T`!*9D!AQ.Q!O.WYHV.H>+N*RFJ\T2*N;+
M*5_O<;'VV@.-$N,WQTK2V,YBFS7(N'Q' -?2$2WCL"@..I*5^C8$]60 &B+[LL
M7<!TP1PD&5 >4#*6$H73LMP`?I$`DWAV*Q<-3H;S73$.D&&S3]-U4JR@./(HO
M307(RM=IM8K7V'.8OL&7P4 0-%4K(WPTI$=I5@.)#,7J.CT?T5'1%/=VGIUSP
M\Z<2G3G.: JX6Z9890J3O0;<5-@.#U9MW6(KI4BSYDB*YW#!5G(,CK::\3>8`
M$A?9; I/6) 2$.Y)-D<="$B3J+FZ!2H6-%$"WG""@.%X54)R5&-?=K$0JR3.4
M(H8>%9?L+EDN%5$?7"1T(.I ,@.+]_@.%&;RZ...G_.^S9^QM`O*^(##EKGB*
M(YK3<] V5_$7Q?N"^7DQ54)VL\ 2@.FOJBDSGUV8AW4R\A%5M?C]58\;&W):4
M,"KSZ2(N:OJ#0L80RAV_!*BVFEUKNIQM5E/)%.:JL0*>#>(@.G3/OL\G2?VX2
MWNU%:BT_<NWZ8,PC@.)!3J"#/KUGH$T"AQLYFO<Z+*C1R5Q%VH=F%G16SL7"1
M5+-\[JG$P2Z$4!68)= *IWYIOR JT0&0-5.5I;-/)-BWM4];'R1((?BG*!G\
M8HYF/14]"11<!8;M*#DN"DBQ]L8&$N@.>A>;.SO 'BO'']EHQ^8_/KBARS!
M]4DL*B_I)__AHB/Y4DW+))G7\W>10->]3O@.%U1(_6YI]UE)PT&^L,04%8EL-
MVE3A%&[K# J %AQI,1"I(9QK; $H6<M 4<<D`*2G3EBPI2#JYR&XZT^?DOM.
MO<R<PTI3I->@.#UH\V%C8%1;UA4D7J"'$O8&']OEU@.&7J1<%Z:2OR-7,TOYZ&
MP(:A\LU-"[F1EE-S20K0*:AN9?JO[1(`U@.EO9MT"8I-05^*?&U =@.-#F]D@.U
MT[_R<"U5BRFMB"[3FR1$$G(%4A?;#[SWM50087Q=U87J%$L2= T[9H)JC"]H,
M.)^GCF8<1E$,[^*;[>56P$JHJ6TKEX$P`Q(`&;%9=T)J!'!T* T#08+H"-6!K
MN?A+NW*XH%1?JJT%UT4J5I5 23T;7W#A"XF6+RBR0R]@.0%4*>U9@.)-1B.RXM
M7&]6ZREL0 \&G8[W\@.9T_A!09'>2R(%W4.=F`W(87S6)7BR4;4"%W59P7O$^
MX 16*>$#_@.,]:A5_@.OT*[@.AGFZ+ +0L4B:_CDK28;K!M^<T#0P$E)"[Y)*
M5_(EF2E-9CR_SG>!P=]?'N.^@.6H9E7@.-V X='DXN+LXO7K\9X"9)UH:?O$0'
M'FR*C/6&_8#Z?<(G)/T7U\"9H8&CL--X@.>W#0'QV`O_(3U>J_4M4\RQ1B)L:
MYZU-#7X!DY/\MYI8_'>>.N\7,3MV>'@.YN?C;Y.+LZ/VDIA3L'*"@.6#%Z?;N4
MM49SVX,[$J7EA%Z[>I;765>U"0)Q%J@.Q&S(^W>P8YK;ZP=JSD >6WR^MH,Z0:
M4$CWY#!'!T0<O)S 1Z<6,\96A^'8N^_369&7^BE_]^>ID4^.(2= R8H@._*
M]G\AJCCDY(ETYD%D`N21*(I#7\"@.JUJ8CO1O`$DED5"WP70%=SW ,][SD=HB.
MB&^ R$NVZ:.U"-5#?'MT-;DZ>3]AO4E<+'$7^6N:E?TV?7YP"Z=D'&L)WUW.
M&I!"(O<*F!"@.\CWU-NC^&E@./_D.1Y@.6PO@.!N@.M1BVC(#PY*@.&1@._UPE0EOYI
ML9!9<<PV)8@.!8C60S7UN?(3%F...I*2Q7*0H\P;KIO&=;$/MV.W6=8\PN5]--
M^2GB%'I6P!K4&^X/1J\B-AQ&; ?^;VQ=53>6*?==DLWU0_5#XL=1<<?LWS^>
M7TU0E/>L<?79=ZR[VX5_`P5DUT"V$3X"GHS7;UBWR^)L'GX-6$-K*9_6CD 4
M:@.;<[%?=DCDXG2.=Y L6`D'K+BD!O:[><28E;?O5>/'!>,@.G'D?C(@.!&*:B@.
M-QR/^M1C*A=HLB_&JW0(^*WZWNFH.>V-AJ,7+V%*7\HI]6%%RE?3YY6-&>UT
M:-HZ:O*P4<_78;.%7F2\<NATN\X%QWI*S64"*ABQ(V)>JS3X=_+; Y%@.;BW#9
M$DH6JE;"-LR7?%[^Y)U$#LZ_I6+1`TV7C7K6AWC.\DU%5%"NDQE-EW2H";=<
ME=/K9;*H[#XK06!Y\<9L@.;)IO01E>QW/N2/OH&>7"O>E`#)!.4OX^<'RJ.^J
M8E>WB>UK!YDRBS.D\>N$"PBDK-4&R!-]_GFQDD,H-LND5(#(6JZ4:6WE9::
MT51A-=E"3-IR9W]/$VG7A-5UY$I(WA!U>OH?R5+Z&WF;XS&S'T3&IGBLOBDA
M34N6T:G2P !G6>GRL<SK@..:/'SY,+GI*&^V/^0.MGW(^-]75L:6\6@.B&(3T0
MM:/!8&3RO]&_]HA%4;/,[Y*BIR3%& -(NO529W\PE*W62I46%([:KM[T+(A*
MI1,,?1_DF8OA"^N"7@.0B>,X^I\F=XM!L>=^5%2(%2._YA!LE< 4(V$+2 L7.=
M;S(.5?,8*"&@.)@."M`>$$"AK\IC<RU$L%H5O;S=VP$"&]?RRG@.7Z!GH-.2=1H
MIJ" I=EP^E,"8A:V9L<?AM/CR^G19=]4902,LR9<P1 X$M9%ODZ*ZKYGJ"/V
MBM4'5CTI+ZGZCSCX;A]EZY WZ-"E29/#T2M3S7"@.VJ+%)DW]7*U("7JOK=$]
M_:C&[0;UHGY0X?7&$5X&*YQ#O[540(*"_V$_7Q==M76=I#4RK C1(+D]:K9;F
M<OGCY*>3,UMR7!R=7/+**&Y>[1F,;Q6;7'V\.+,%S.3LK;N6-,H#AT>>\1>X
M?L$F77/SH2$CECD@.+N+O4K7DZ67.7/O<-2\BRI%522J0(X$_!Q974&+.2QBD
M`H\1O\J,Q"G-8&O-D$8W'RC4]U_48+E)C%MVJK 21>O8H45:6L]LITI930=(
M^S+ADR3]0[N,=)9YLH@.WRXH;. `A//Q*S;2J3A_3N>1&>]DEQ_)C?A<?NR3_
M#.A?# $+O>66&>Q9Z.V(OZ6H@.=#[/?I7!I'9C LL>'K^*ZD&;O1:*SG/SLZO
MV FP5YOP-3U!'CL;S R+^,MAD,P"K$R<' @.3J#!B(TMHQM&C< .LP8-,D=<$
M'5CCW7UBQ(Q%1)_JJC85"!I29KO)Z>7D21HDW#<U.'SJ!ODD-S4Y>N(F%34U
M-;J'1%$K`K@.'OD8`D*2%=R<5+7^J,FA5&&H$>_%%CHZJ-+NIDQ*&A]_2)$W)
M8$D)CVL'7V+^A7KCOAY\&7%Y(6*DM,[AE]P7)5WMQ"]Y($HN`+_M8-;I<ZR7
M@.YZZS&-0D_O&_LT2S9H6VFN56MK(:.6NBP%\YFEB\,P=%3ZKU4<;!)6G= ^RW
MUSL,8?6HT:.6R0?.@.=B=NYQ<*=(;8^19+#A/*CL."SZP80_1;?H`=/JDG?!F
MJDTG]@.=/VH=:JOD3^N)1=9L^')A]<&Q&.HAIS,Y__+?)\=7TY&TOO*T@.RZ>N
M\'#KR^A5FYT+U:M7+^U]9DK1ASVDO BQ'>%P^\%=%%2A^,B2]<3PGRG+RRQ?
M81QI&38^&T9S`P'ALHQT]B2;%?KBAR+YAB:4 1[.U"X32-J@.UU<(&@.8,'RW
M-'HH]3NJL?#Q/4]J6T.$YU1B$G!/T:$!`,\-T3?Y[>3RZI+U+B>G0&'L60!U
M[R[.WRL;6/*E@.E$D<QETBJSGU_GUY\G%A$D3G+G1M#]'9V^5X4R;H.5;P3NF
M88FVV=^/6D[%PS><1R*F=IV#JAIAF#5#`LPS#+X7LR1B>DVW.[>5TH) 1&:N
MP"H\]S;^G "9)88FLTX*W(OB$98R9]=%G,UNR=Q,9 T;TUN I@.YPJ&HV7+(K
MD6TZAM["AM/1G_4.WV5+DH(1,QC3$%<:2U@.U$.U^<LF-R;#\AEZC4.QZDVE.
MCZ"Y<&5[8@./S9_?/-K&+KK5JW37.8^RX]1G6$$^MI47:9SADR9]VZX<V<T3.
M6UE)\X5;PCZ@.%CAK8)46IC%!`>Y;\^#7V/KIM<H/;(WE-_>]O9D`SD%N&.L-
M@.5O>/3PU]A[5C5NXDZS?@.7%Y_B?_H=>"0Q#V@.\8VU&3X3]UZGO/3>1(Q%B 9
MY5JP/0W>$%QGA_/$+5]_J&'<\-*5HTQ+7,D6?4^_V<*L#J.V8]+C=^^&7D-F
ML-2"2]!$>NQF>5;%:58*_4Z<F9%K&Q,VXC0I(V/7N5FMV69-:RY0]AJJ7:?+
MM+K?H=.-YN:*?]_989=IACX%%-?D(43;/=L;8=!CB?M79USH-E9U-R4N"UA-
M[7*%1QK6IW*S6*2S%!2C77:65\+RZ8!+2P5,*@.=K[C ACZ;V6C)A-24=B)\N
M6XAU4$;V[#J1AE9+TV4^O\N+>2 2]@.OB<NKT*Q0*OY1,'RPIM>(0.$D-L 5T
M@.J_JP,H:0Z]&>%C*8WN35,)=*U[Y7EN$!II9KP;47VI[U3=LJ301]B)G*J-[
M!]^#!C1H].@.%@.^V&CNNDN:,!9(<Z6=/'[P=?WT>/DWD\D%"TI (TSQ,>P@.$T
MO@.16$\=8F"&$I0T>;4FW<<D]?BAWN242GO!U).QZ:Z6@.?/N-[*>*_1/AXN-R
ML^HMD^RFNNT;^QH>SB1W,.,V>SP)\<U+H%P#\=H%:YI$AH.7I J;L>=GL10"D
M1$A?IGF@.^!:]-?:/L+8W&O*S;+;?6"+,.H#%C;(J_@.1JJ4I0I;'>4-4SI\,X
MF#6F@.VV]9_7384=A>1.BI\0\[O6&C?9?T@.;@."1'ES+$Y9;;]Z^5![61'V+$6
MFZ,PT[&?A+46T)+S3:<#/\PVTGI!\1?J;,>8J:\-(7!MN.%/-7;X*H8,'S?5
M-*5HQ.A1VD$3!060*?V:MIA*DL&:K(X;@.VQ-M7N1A%8NX0$X$ 48XPWDY&SW
MFHPI?%MBM"]Q;N]&^!X6S2EBWS!J-I1 DRA^&VPXG#]F@.<!$WOYL%R2@.F%!L
MG,=C?I"^>GP=02%.R]VTU*/GSOE [&&;B$=DFX.7K%5X3!--6+3A$$H'J:3#
M2>0^W["[.*OXUOYSPF3LN5RSD%'H\#UW.XO#\>3^,.*W$-YS'I4C!$W@.]/^#
M_#@.)#Y'H.<?V540INGQU=\RG?D(`^;I?'QPT_'ZO17#04XU/')^N&Z ,_O0'
M:;T)#U06:1CLZ<K"Z]=<#,JNHWV^&@.Z8(S_TVL59/2B[A!=P]22S78FR:
M2_0/%^<?)A=7_]'CS!Z);#<@.WF1=%4/4,5MPR&?'J\S8*$SD)(@.%XO ]+W&
M@.Q8XM8'G3<V/]FA"6>0V/]2-6VBA\U9C^C<2AZS&]&^]-FC(0OY.Q2TATH0<
M/"E/%-+&0ZM)=?J>C7D7.V@.9%%W!9C+V8L33,:PIHJPWHY"VJL?/J4:C?C]B
M!\]&,$:V`WC:V9''HID`V"$H^P?;H4@.8,!L[._JXH0;RXF6+KNQ;8 %P0P]&K
MK3!>CCB [[858IV='76DF3<B%5#Z;&NC31.@.;PN'-RSVN/#+\\$=BX9HB\8)
M:#@.X('*5OU[RT%%.4*^'![QN@. )J^C(<8&=ZO/YWPSXA1_)-IX9IGK$1AJ0[
M3]\`&-W@.#CMY.SF[FAY_O+B OVZPOF :@.[ML]J*=H\G=+GM+_K:W!@.U":$ [
MAM!^T@.\$Y9M+,LKI@.&\=^24#OT3 5RBJ"UWCM;J0T'7=\&'2OF3I>N6W3RX3
MH95U/W9;.K":_>,/TG(UBI1NB\$8E#5'2C'<)& 71<H?:+_\YW+Z.2[2&+TJ
M.F:.E)R$.9'CB%T)`G?=GQ'\' 3>76)9X:[CV:>[N)AK@.)9=CF<=\[5C(]![
M0%UP?6#*XZ7U5N[00C5TFZ<1YZ>'7>='?6:[Q*VT<')T=!$?X 0(&EKK$)8I%
M+,O*BU>UEA7)!1W/IM)QU=%7NP.Y%;E."K2B$.*7*7 $ABZ*@.X9X5K:LXA5&
M,RFM4V*L5M/7ZYCAEJ;I5@..7PS9::!CRP=8ALYHARXGQB/EO,C</M^C2`3"9
MC,,G&C</GN']$DJ56^*A<324?DEJJ[X;U"0R*T9ON']@.'IUPNM%]B$]4:XB/
M&XS:3)@.6_*M@.JA-MZ,/P[3;E!TI-]E\+3M:L38=HZ5'0.%1C,!OMMXDA,D\O
M=)JCE6NS?3'FD9C4S>OK_$D45=^C1Q+75P]1[T)D*W3H/9BVHI;2&JL,E*RL
MG=QPZJ[:>0T7_Y.F--B91\[FUPRL9B+KTX4T3F93M1836I?0Q)Q38Q-=6_Q/
MFM.Z_CQR6K]R>#4SVY@.TIG%RM]0<!-15:;<FHZ:C"$K/LG5.T(YUJCGOQW7!
M_^GG_89?<]Z/OGY)9ILJ"4:XW"252M[B1K(8B=+&QO=\4ZTWE>%V/.0=1G]B
MWSM20@.]47:EKU>+ /K/P0AW#,D;&J=X=+',_EHJ,]*.R:>$$ESQM0$HGB/B<
M8^!7D:S0!W_QX9C.:.U*31DCA#Y>30(HO$V6:S-/UV&QGI7%9XDU\]7YQZL/
M'Z_LB W06ZS,76,SD1>OP!UVC>=VZ('9E"*UC@.J]L]2CO;U7UL[<4HK"H1>6
MDBVCFN1J[VO97LY@.G'H0E%LY(%B9CD60B:5+YM10@.:X-IP:\ED0B^8@./R>YB
MJ)*3"Z:N2I@.LK1)D\7A MY\_"S\W9*1%!T#...16>-P]198@.;LXNKBY/W/9.^
M>!Z'%<CQI-A%1OB".69N,#*E&P8;8"#=1/?G7R;_,3T]/SXZG;X_.O[YY&S2
MC<)P[$_W\OS=U:]'%Y/?55*0WT/I07X_&/Q^H1,W_7[$)UTE"6G5F$<J[6I1
MN"D.UTT@.)+D[# 59WF-Q!X07'.E^`GJ'_;']SJ-!S9[)J110.[SY-N,KY6>;
M4\V5*G1V\/*#^@.VZE7/>V\X:7B0+M']4.2S,#.H!RG[[\%<._FA9YD9M?@.:T
MY%F/[M+JEO&P0F&EDPF^E)TD*"C,U$KV7G2;'[4Y58PU*JYE])2I\(,R.^&O
MW[K;C+![9CX&!W2S4=S1"I$*%5[K10J0_'C\J'$^B))UY%F (&9+&;=E$EF
M+0)B3%_9<YY'0X?>2>@.E3,\:VZ,P"+M-[KX_.S_CZDIK*L"IP<:#Y?S<67E1
M7]A-BM50UDMVU53636/5#-=.']4,MWU9+VU40V$_"Y3%:BA***#*FC^M9_(2
M^'%65==BM*?37$3^/(=9Q9)EDF^:!!IP2BDME$BJ97N)QD\KB,J[6T53('E6
M$[7]3R3-AXG40-R7X7I%9(^#TL^BI-"Z.'SQ",IP/%O;%CG!:<\%%SUFQ5.&
M;TIQ0*X;-/YSV[_,E4EK![E_C>R9S83T-4+@.#Y[!H!]B; _6=U.PKH6 +FM-
M"'N#T5<20NOU2-T.1 N1Z=,`?66'W<5%IAV=\KBUFHJ[=+G$>AAYOF7Q^N,X
MWQ7R'C'4.@.?:SL:>X4K2!^UJYL52:@.SK2'CQ$#M5[G@.([F7Y]MI96#J!7@.[\
M7AJ*,T_RZFH\MEIOD([CY@.8,*L>."(E?Q=7L-BG5M#>'$*J 1<YT,M!3\QV?
M+-<1#SL2SSM?%SC%W3&#AI-^M7%..SOL+7=F\CO.M,N:\X5.R71]SZYST.)Y
M9E^<M7]N$KR+!(W'6Q!AZZGR[BYX89H-;9=F$SC+V+B.\)$^X2<:H3&O=[G/
M@.O>4S-S2V27>2X-<O*NB.>E-O&M/E(-Z\Z(%KK/KU-%:RU8OE5I.8M* : =S
MO#23C\G*6_(,/I8$S:@.I83S-9'7^NSZ?&P?3PGIKZH+-EES:8S4E-AXJCV;P
MK1E)_B01>S6^]>\?XUNOGR&>3<CM;,TT$2'T$..\W.LW@.: CL@._W1'#>&S?X
MB+_5@.9M80OWJBXUN72C?]\,VD83\7S\P_F@.^-]=<CS9QA/)&)"TQ,&?*35[<
MXS$PQRO!S]1PZ8._2PP2OKHX.@.OF_3)4Q%_%L@.V]6!?)9XQ#CS/5-YJ7ZP3E
M/0\N)]7/=%W<W>9EPO3)OHZ(.:?SRL4FDR?(\+C9'0;BB$O"Z)18F5LILF :S
M9,WE+<C7><ZU%<P9KO8?/%6K?4@.1K57^8M]T,G'0-+-[+_=]K4O,\4T.XW]W
M='+Z\6)BQHMV]%SY`@.)77+O+XY$9/3^6Q]Q%SZW,K'Z;QNK,L:TNZ^-';%\@.
M5;^$E2G.Z+@.2O[$,D+Q,XK*BF*LLN=.G_Q?HR53(@.:+413&1" 1Y#M$X:B,2)
M5(OFCDZ\*Q70`%W*6Z(B`'D3%W-X1/L$9_[H)%73#/,\]P^2ZB9BN4&+8V=,
MV!'?7_:=A2R4A7X\-)"N1;AI&,=4<!@.)A'&R%%+J2>5B/-1,P8_FTUE*C%V6
M)V.,R[8,T(;9_,F#]NMRYILHP;.HPM#/VP%BS)(;BJV##J79K) #4$<2,!*/
M%Q$:J^@.]C^T\.3N^< ,[V6MY-M#5<-4S(SVK._0QQLT^"[WZJVT4]B,];0!>
M9=?B\H#UKV$!-.A,W!& 1D[Y/;(O%QB;/QZV3M9$V--9DH*TE$TU0_MR+/D
M8_W]#4,Z)#S_3\P)O)!<2H([ORLC?H(9G^<%QC#*6^20)1S(QKT1'& JH!K3U
MRQ'[D7<,?G0:!]@.82^PTOZVR=]J+=V4B=WF(1A>(B4R%SM 0PA3!>W YF;P-
M]WU[K6V=;AJ_!FI&ECL![:$.N+!$.'J'GTQGE.LV+N[E39FPTL\ VG)KRQ8+E
M\WD9=50-%%/Q\BZ^+]D-BAR=A)2+3AE K&03W[AYE+C;$8'<XMK/*RCY.8>U
M89Y^QB[\*RER1HP-1,NWD7C4'695*9@.XG0.^S:T/<E?V!,L_XNL-!CI#..SI
M7\^#:FU0VC$#U73D;[5.8$FI/+2!@.@.?@.BUB@.+<WXV@.5:V#)'BW&9XQYNF5<T
M/07.&")RL]Y5\.]N4\PX@.^Q]&Z^Q';[TV0L!K YTF2=P,07"K_.2W]%!DR^[
MBU$=O5YH0!3BX1R_$A3ZQL"8]$EUSB_$ES"XU_7@.7EO@.^GC<1/CO`"OE_6J5
M5$4ZXYO^>5HDM$Z7HK4F;M _O@.O-F04A=+F,L'/*`Q([\%U,&VR[TSFW1>BP
M:UB+54UN[S)<:QUQA6EP`>F)<U7&0J1H/V+BC]FS2)\SC.09UBD4D),A&%P>
MV-J&B:CFH? [L.AT8EM3:B=&4>'$F2AE<Y<CT:XR!6)LW0)G3^\&J/2;^"D
M!25$ZI 0?0S!,VY37*%A;*+$*:3@.!8FP1H,(;4KJ=T(=0VMZ0' '75>A0Y'P
MD0H:XU2KQD]'"#LJ!]2U,"JQMS].R2\K9MG)6*P[8=\#I7Z8N&+>-5#6;Z>H
M:YD<>T^<"OQ*27(P>!<]VUWPUY<MI,!\Y?:PL;0V?XS#=,/J!)I3R%):K5]*
MS]0WE5%XR9:-KA!:Y," U2/EY]C%%>.VC,,W7;3;\J Z%7G3E2?,;^//N(+1
M_JO,558;L9H;:5]H5I36YKP0L0B>!XGKWKS/+&30[F _<=?)_L(SR QYD VN
M12!:<'0FKKSB!ZA88,DS9YQ=F7)((UGV59R'PKO<3"'GZI]>T(S%-SKP$%OC
M$D_DJ*O+L_9P0&Y*"$=+A9_OX^*3,W!+!AMS08)78&^LOOV7Q *,Q4YV0RX\2
MB7$,JM9!`-UP.UV1+)!#2,L1^5QF,8QB]W\C7MTH3PQTM+.S-TAZQZME2GM^
M#^Z8\;_MW3\^)'5)'EUL]_R9=#P*2Q>RC;QO6)^CE$XVWKP7!!VP+^AFC=YG
MR5TZ[P5"SIRD]N&8-!MIH2FLCY#.U(W#/*6^OH"8AT(;@.=*1A[J:7@.8F]V'=
MMF+I\'[!99[9L;DZ]QDV+I^BU4M*6Y*^VM;4HW0D\W2Q2&3ZD[YE\/*C50,3
MYT:H/CPOJE'3RH\J3NVVS8ZJP#SW`HS;F2[K4IPX*5;PG*@.D4DZMC\Q A\K"4
MJ"TI.W-HT9VL!WJ4'X5(@.3<;27PM9G4?]]@.B^H+\>(''8WHPV!L$W0J/Q+&'
MUXL$K2LF0RH)\GAV=*= 72FD1-)8-]-^+OP(? VP-LBX&2G;Z,R-999$A@.C3
MEB*[3-WH`W?(C]VZ#R!,#QN]7DWD-?%^J'DCA*3/T CBHB<(40:=-$%]>HC;
MRB#GV8_[7\5VK_Y0MCOA%A6T/(I)CD"6K.^1G+@.9K=HL%IP<^.T^*B OO_-%
M'(>69B&?<(^O^#P9C##6Z$/R$2>KB-4GX96?4*[=2-YWIU4+1_Q%+)BY5W[<
M[+O,C6*JJ6=/=<3LG+DL7"F0)9?YZ7E9\,I*3+XQY4BTPJ B!JK7=+8IZAI=
MI66)RP#N*2+SUY22`D8@.1V;+S1S4;5["_"F+! P#H::N$]CG)--TA=%O8GK%
M,^J^> 1=3Q?W"L/3,KT!!(#,BUC]2>FZX=4=DXR8N"03K^.!,>=9&>EEPSPP
M&V K8?2O\C4#_IN3G,5-4[X!3A<1$V3 !R&=<7,^"F9AMD=A*'1]O2[QE.K\
M5'ZBHBC*D#I/XIK:-C1 BW\.308Z%!QDY;&N34$M/X?;&4=M9*)M6:KEQV,>
MCT^<Y-+!S-&AG-4U%[F&NS&HYQ'<3T=L(+X,_H^3=@.W<!V@.\WLKQ;YB0!N0\
MGMI##[IV__M["%J9WIZ?3:88TA/8F3GV!VX(<L=&)B%A#J*]KE^"_%>&G<#:
M\V'0DG&=[8S]]/'D+<.;ZN:FT4UE\PDM8E9 `U_MZA:Z^B6.L[#%I1X3^C-6
MMYZY2TYX>6RYY/C-;F?E!RY3`KT!_OIO6J&^GH5]9>%!//VD2Y5R4VD;0>/B
M(&Y"\%8)<89=[61"'0]L*>W5P17J:NUI+]\#K?HD>.@.O)R$B'+A'^"+2W4.B
MW5L/?"<(KRO^/6P@.#V^1K$FW$I3WC?D>HH#0BQKR?QATTFCWL[<.A@.DK?&_F
M=EMM3:L-5VCZW9!/_4!2E/Y&7N6>^OY?XB %C5^$:2,:_$,R7XD86$ZP$R(A
MFR#0;HGZQ0[H%\(S0ZL4/,*4O:9-5KR9HXG_)JEP>+V^,$J;&!_[22?,'!/J
M:;ZI9.BAZZ.BG23^(MNW.YP.CZ/MJ!1WM/(G+,MY2,D-A>")R]Y7UV4%.FN)
M@.'EX5(QAP&R^6:WNN;Z;<1B[U!KA`'#5?)+I_26?,6CJ-L43QO=NX+(9&]SA
M`(U]IE^?]1#?90'R%+^(:W#U4&@.=GG(9)]%)VUXZY-07$I6[#WIR^B*FOPVE
M9.'H1SDF@.IJ\!!_>86/?2ZC\^;A6IY4:J'942'-0;,Z'$6+MD>#4)$%N](&G
M0#*K^$M/O._7J'\]``HH^\30D8I?)/.8E*?M7=@.-V:+CLD-RQ&8-M<T*5JWC
MC3!SZ/"//VC:[0`*8]KA#_8_8L?G1Z>3R^-)#].<"E0*X'V@.BKZ]...KT44?L
M"M^-!.11C3VM)EW4M<,G4: (YU",,!3_K8@.!9T+.+J_21 P/&D'BZ>?.+?:
M2R9\9#S++6 U+FQ+,3I5^4DF4XUW8H_U%4Y=#L])O5%CD7O.,X7$BAUP`X^-
M;[)Y4BS)4,8]+:$4(<H!OYK3(2DI^8B$_Q_4&_+YZFZK2G^^\VY/:EFMV[LZ
M^O'T_/@.7]O/YZ5O\(IEZB$GN0\T+'U\/(?1#63>,#16QL(YD(.R42=& ER8/
M(BPJ(L4]PK/ON=KJ70[X#9W$(!2&<'XU^8%B_7D\1AM[:A #QZCH44 B7<DI
M:4-DZ9<X2;,GP@.EOQ+H`ZPD0]&#':A,J<*"<%ZLBO;G!<[H"*70E_*.'S\_'
M2I#>-1]"*?W)W\$!EA;%/ %Z[F4KCQ]BKI:JE07@.7\%:D!"@.QA$F*5+&-9=
M]O\M-""/6C@.B7-SNP:6X/#-U*8_LJ%N,YCGW3<<W>--'DS@.U`BM&)(@.X:-EL
MJ&K3"N=>[@.> M[O]0HC\JJB$;[]1%K(?S.@.Q%2LF#\ID59%30#*JW#S7,[O,
MF0QHP+]TA"7!Z%H*)8]GMP9Y>>'^(NQO6'.J9FR=-Q-*J[,Q)%H$DL8@.NT,S
M!-,*X=3!=^-P'%[GL&W(J!WA:OVRR_'],D5ZCT%SMV%XYT'<1W9Y"OZ?\JNS
M0B<%O&A3<[^K@.T\;E2'GLG@.\O$:WYF&(X+ KUQ*5H5NMNFE&QC!Q=2N]]7*T
MXP?#IKS[IC P.XGY%7BP]Y/7-VE/A2 G(U8DD"S+RUJF!97)=')E-Z35."RZ
MQH912YB6# UO+,Z"&1]"YO; ,+.*OFQ7)[BAJS8.G .R]6QLWXZJTP&:TRFF
M-#BGR*/&M,DY7A?I"D^:?$KN#;R;P@.UO[FZ<$1EE#(H#OY&*_LIDG_P:\ 5(D
M]C3#"2F9NQ"+?V&CP?Y!7VA/).<__"+T'5?2!J*9V+NT*"MVEW1AA(OT!D,:
M\&S*G4S'`<,KT>BP)0Y)#45G2Y6?7W\^.9W@.H0BZP<2][ZLFJYO*@._H).H '
MC\[>3GZ;'I^?.J>5(H$]_%L33L=!!$/UY.<:9.HG_]7C.<;*X4$=B&!C,P\E
M%'P8/S@.\L84I`O:,8"X[=2Z!Y"9L288!%NI(<Q3:HW0BGSB[MTY#B=T !CY_D
MG"+%U"Z>!Y>71BU1)\!D=704JN*'?YXH9-I/NL,''[C#2YKC:^_PJ@.M]5GTR
MIN.)"$:TI$A&+5S*7!A<N+S)%M/FR+R@.<K!(E\O-6CAUT']3MX]Q-B[-@.?>R
M5*?>4&O)WW=YH<]W4R)#[CA@.W'' N.> [9!>*%(H\Y-)Z VDHK6GFY=)U@.OY
M(?K,8[(:8T.CHD^ S=0%)OZVZZ;NA(:D5*.F&JI@.[80:C[3H"E[Q1YRNL3MG
MG+4!<IY*4ZBQ3C:D4[5!V8=K#D'R_6UR@.6.(ZLJ)\S5\T,%2K 6ZNWG[Q^6,O
MW'[(Q>$/NUR]_OITN^#.CO;A!?+_;DO7W&HYWZ*=27NT/LT^]JXZ"XJM'Z'"
M9GV<K]:GN--2CM+]06MUO^ZL&3^Z[J9J,'ND,A/I8F+WH:\C\Y,^\"+C%X#W
M+$&GH]QYDS[G'CRIVPZ/_4;KXI+]/" MSMP%#0C^PV=MS8SH9*(]2@.0*P,;(
MZ:*2<-Q1U%:Z6B_O@.^UPXX,1:7Q#MUW9QCS,`T,-4<SD?,X5X4A9NR*D`6WB
M"3:$MRY+ZP>FF*'D(Q7J.S.<;<I'D9>N0DR5_Z_:4O_W&# ]#)4(.C>/S]^]/
MKG@..HP<Z.C#)(+H5?%.J(/LZ>Z'^*K,YH?M%=/V'X+4!>'G\]WZ(<>T%"H1"
M'-3Q^<>S*UNS"=W4?'YZ^N/1\2^$A\NCXZN3\W!*)[.2@.3I1Q4GNYXYR2!Z*
MG\Y%()E]G]G?>>+U?^S^'2@.*_M5Q!/^PK[3H^OWJ(L2/']X>74TZ#7"^_09O
M;^K\G<_D/\8[P\&KO5?[PX/1'L9X=/Z.$R8OE/\,,,;#E]]^PQOO;&D='L_R
M3&R<#_E7685GBQ"1&-U(OI8&JNZ@.R[%R,3D^/WMW\A/:KG\]N?J9G8-6<W'R
M=H*O_S]02P,$% ````@.`J6.D,%Q7),IV"0``K"4``"$```!&:7AE9" M('-P
M7V%D9&UE<F=E9FEL=&5R(%-0,RYS<6S-&FM3XLCV<ZSR/_0WP(L*ZNC4UF9+
M1N,L>QUP`7>V:FHJ%9)6LT+"IH,N_W[/Z4?2W0D(SOUPF1J$[M/G_>S %GZ8
M)@._QXS*CY%)\3((Y)2YI!+-9^DJ6BRC(*6NTU?9+,%OR_6YC?^_S<']OY%T-
M!S?]S_<CCWSM3WXEPS^\T:A_[8GM_;U@.EM.,++(TI!'280L_B*(YS1 [I0XQ[
MS?T]`J_+Q7(ZB\,@.C].$:"^V8LA36U\[/B Z-.?YX%CB";(\#F>46*\U>!2T
MB4-PQM>VP/%7&B=$'+'PX(XO26C8UN 9($3Z0/(G2O)@."EQ-:9P\<OPT(GG*
M=Z8!4]LF'<%!. N63!)*7H(L? JRYDFGTVFU%1W)JH3\>QG,XH<5$D+T7)B#
M8T-NG<HRB?]>4O^9KM1NG.3@.$9VVTEV:A=2/@.?8L1N_Q0=8%>TIS,HT%H.,X
MP,4-PI$2CM!_8I8C&\4!E,^1"#-019S[;#EE818ON.$E0AV?`",&F%)3JS=&
MC^06H#E)TC!=`N]IHE:/#\3?@.P-R34$]&?<O=B17)9J(;T'$*#Z!MR!:.0XH
MPH*(IK[M1-+V%B"X<QR9#BL4'4<TR>.'&.QEO2P,Z&5O8*B>\),X...8XK$K
M;6Y"U8EI,U>*Z110Z&A^.OV+AKGC%*[9_=!I5: X50FZ&5(`^2\Q?=T>)P<G
M-K@.EE "M%\H`?*$8X,',J?,`3K6$6 -0U<J9*8$NYGHH6T0;TI3O-;&=JEZ^
MC.9A&AE.O%X,S0>K0'S?J=43RX-\R<AF(F$Z6\X3?P9Y0M/"&28W`0G*@.$PP
M#YZASF"Q"9=9!MY/(+\$/&_&C$ BAMP9$4@.KA)<AR!F+HI:H(*?_T+ 0W8VF
MZ1$4KB_CJR<:/O-3VB%Q(GX@.EY=0^X:CGW_I$$"N3L-7`>' PC)+2+/;JLDX
M8PK<QOF*<!I'Q?HPF:UX9AZO6$[GI!...(<6Q')(3$&F.>RTDA@.#72LHA-VT3
MN&Z1,$@.*5%!X29 4-0\*2J 74BO/&2J /%LH`44/D4F?'V9/M@.+(S[\00P5\
M04#A2^BA7@.UWD'7G%.L3U\-/>C$NE3*1E4H6/9%E0=0$RPPE@._O;6V)*@.]QI
M91T<`8%*GJ;T,4[*KYS-(&8TRU#+$#]GIVW2[;;)(?S7,+6L,YJ)U1I-(B4H
M<E$MUI(9KK'J+G1;C7?RV:BB:^S&\$;+U/B.,(W1S$%*L"P3)!&9+UE.L*E,
ML[EJ;;+EC+("$09H6;SL*HR:-*CL;- .*NH<%;6;2BJ*^0S-!+(OBC@.7KLA
M<KU@.DS<YS!2%T1E6&MD$N )/V^XO7/,K><C2.69LGHTT$HR47+\^09XBLJ<W
MU(5<WM_=>:.FC&&:M5RQ<'D)2GJ1WLT!"Q _FKJRIVFV##L`XSM:`'K2DW-E
M@.;;!W?;V<)"\J1C,MHXC:?/6D/\YT.O"*R7/"<PWKYC\8=19D=<`R@.2X882>
M&*.SX9EC_H>GCK5=K4LX09VDXQ1R-D^ZI^>ZF$;FX+"/*="]Z?5O88822UPX
M@.W!=][L%X8OW$.8?Q>17[U_8/%N^>2)=C7N"*QRB$*&HBH)(A:Q=:&2108EM
MXH:;% 3*0LM3Z$9ZN*8%LXH]U:ECF1.?C/C2%<_L^&KJ4HN(:3)CJ3S1OREI
M05&T@.@.E?G[S/_8$9`*->?RP**T;-V<6:O#7R)O>C@.1DGWN!:?=PBH<O.H$SF
M? /C@.E',98%(=,6,#2'/`X++'*64B?Q64WJU$SLFB;,/NZ9I4V!E83$@.N;S[
MP>S*FU&7O[?+)MY5'_P%`J*]V]:HY)+BH^$C4D1F95TEN4RDG <U[YGZ>4\*
M/3O_,>UH[E#4,6!$WD)4+C#J"Y?6_+M$:=28?%Q2U>N;VG.K]R=5)>HU&8-+
MXZ6BS9K0,EN"DPNMQ[.);Z%@.B#9=P3B,A"*"0)D\4K#!!^56N SQ>:Y1"Y>S)
ME8G#',\1PF-YS^S8FJ^!+A4AAEL+N9B!7?6U'F<!I*WQI"ID`P6K"4MYN3(S
ME-3"T#!L<>G0SPN'Z,)"4;A*5S+I-H:?O.N)OX?>^KWR#_*;DU3]E7`>[O
M]\.)-^A]\9HZQM;:4]4#$E:\UU:H1_R*`RG.H](;V\:02H;WD[O[B4HV&JYF
M(X3""066"\HELV6 M08)F.*6P^BX<9M'D'U:<EZIO#" VJ67RZ>*OC HO__;
MUIIFC*\Q:8T_-7X;]@.=^Q;B6EUF6JL&C6<W>;6W&X-8?_=]:O0S!+4Q?$6]W
M^U<%J7$"S4*\\VHVHBQ=;'#$UEKGD7VJYD2'A^2_/7)(/@.DB\)4XNP>I.N-4
M@.T*W.8&\*4;_YA*[K!;JY AET&",C(*=F(-*<_AEQHJ)3>CH'%YV'%6TM4-2
M+.?'...$2:>/Y[>2JH-A:./NDZ(6=W4.EWKBUN53H4 9 <:&74W!D?'Z@.T.""
MVZW/:V54V#NXV'XKE&JW^8[H.,H,I-=E;CKO3^_J3;9!LU>]L4>^_NH-B/=G
M?SP9-\G8NX441_Z?).(`+3)!-KO$NP66.WQ,@.-4R@.#T>VI7T48Z:E6*N!KGM
M\LF:\@.')9!.6VB1OS+PG'_1ANR)\N^C'Y5&MB2OF[KI690?9Z B7;6:Z:%GO7
M$<0:-WI@.9-6EZWVR=359H-Y]&NETM?Y9,O/>JQW9T ^&$QE-,%0+91R\+;2K
MB:QIS11PIZ&[G+/P$6IQ*9]F,>@.DF)5W9'C9B==(+"WFI#<&]#77BE^T2T0Y
M>(O'OEP8MJ A7HSR,2>0.S@.>X45KP!W,NC$MS(PJ%?>0-2HMBH9B4&BUXC2H
MV7RUX-?3]_JE\IOWKB<?WW?OJH^JO2@.JGU;+Y]EX2Z%=U]!<K#,4.<Y135PU
M,W%]FJ-8I8(*?UNKF!K$XI!04'F]YNK/&= BIDOB"I_V73'TZ[=#;P?82>V-
MWH]&F^8>"5#+27\P&=8+W=2IRNY77JGHMR1M8H_/<L4"*'].T":UQ5>^^ ]/
M6-.4637?ZDK'9."RRL&EQ<)EA8>:#H#8+^UQE[",^72KQHAFZUQ1 /5:&94YK
M'[8)Y:^_`BU86?OD36.MRH=X5XY1/D>50#^)[V8N//VH.>$FOS.?=^(_\9L@.
M:#)D8W1 ;D;#+^3;/&"@.\.]'WT!N>"_ST'?LIT:>NDUK5'X^U$"$]W?7O8GG
M;$"SOS?V)L3Y)IXS?W</NYV+TXNS[L>3TS;VS=_PP:G/PB<Z#[!P?W>[Y_M[
M@.K:SF3C[@.9]1=;;]&=6_4$L#!!0````(`&.2!2]9\%($@.P@.``&@.>```C````
M1FEX960@.+2!S<%]-4V%R=&EC;&5C;&5A;G5P(%-0,RYS<6SM65MS&L<2?AZJ
M^ _]= !'$$"*K.08EV5I[9 C"06$G93+M;4L`VP,NWAF5I>7\]O3/;-W[+
M[+?(+BXS/3W=7W=_TSO(K>T&_L);AH+#&_/1=S8<!M!PUNO@.!L+MW%%<-O;B
MZ6MG'>KY7J->>S^JU\;6R>CBW?#]=&S!Q^'5KS#Z8(W'PU/+3-=KQV=7UABV
M(G#YG/:16_M\X@.CEN6N._QT_W-9KK/EF&\Z\.82^]S7DWIS[REMX7.#&)'M_
MHE6O.1(72J[ #]P@.]!4$/@.[,4:M#_L@.@.%"ZWE3-;<V#^M2/<E2.:_9?=5E:,
M_%I[KHH$*^6"&Y\+C0YC\D[2I]ST["_N*C-?,JV5^Y[[A3'/5X6%Z!Z[-R[O
M...>.)@.M3UQZ_L=7=EM];I"3-H;+$C9_R7BQ#;RZ5J!9P']) T^0=JX94<.4&
M<Y20&TRC@.HE?0V=-$9S;6DNEDIEG(J*E[B'*:#XQI01PG*:<JYK&J",,#MI6
M);'A8LEMS$I[XX@.O;K .-[X]\Q04_$GE0G^W) Z10V0UI!OB_W8;5 `S#B["
MQ>?@.+!07$-4(>!(HR<,MZ@.,'9#B3KO!F7%!UL1]?U&N ?R]>P(2[H?#4'9RL
MN/LE&O[1O%M_6"=)8+!^Y[.@.HRM1\.W7ER8>W)E9$?OH,W;["0 1V-X]1JZ
M$(AT-0T8*?K#T5#XT.RUM#V28UFK'? -H'M[T.UV2V7O03B _U>JRNUG*F4`
M&^>VJ3^W8"&"#0&MUT=H2KA9<0R&(95!Q"Y:$T9AB3CK.@.<*S AXX_APB6C#!
MRNP65_L@.DLT0Q !"R87.[R;6&Z4UBXTQ*R4S9A@.;M+VQ#28S0]Q%K3@.DU5)N
M1X[C!O#[='1E71R?6\W4FA;\`(U.`U^SLXG])FK\EKM)@. <Z,8@.I5("F1!CM
M)>0!04AY[2V2%:]>FPPQ&4/?LEG!4G#))<]'<-1>=+9HC&,.UL>$]E&61R]U
MG64)<@.#IEST@.N%E*DCB;?(XG$SJF\.&;#J&9RO(.SAJD3"QG? !$(;GL;!_/1
M)%FZ*":C\C7:@.MR2PKDS@.,) -FE*,E@.K,6<F9I#Y0%"6)#91!$-^^$AICRD4
M1$ENF^2BW%HAR21!,/O/N.M@.&@./Q&$X*CL&:P^P.D+BV<H5*$ 5-<,0Q&-__
M'<-;OO1\$^U+@.407A*1VLT$Y6GD^T:H"(2B";:P2-&!]5]A9:BO)0KT=,951
MB<LU_Z".>>#Y2YA[BP5"X5->T?<V./,Y?8BI,ZUE(MB"@.S3<Z70(HG8[J:C\
M\?24FLK'S]05TJCUQW!R-6GJ>$ZL,^ODBO7TEW?CT3F;_#D9O?T-!R<P,KGY
MVVAX`3@.\G5CC"4S-(!M=P*@.S'9ZB05/]3L,?[7&%AMU:'\*>=X"DCB^.&73
M9#YE**K*M];[X04)?0?7F75Q2J]G$^NI.U7H,@.EF^7%*PZD(MII/"F&E;"1N
M*FJ"X00N1E=P,3T[:^E2X;>>5!*:D54OH,#1F4*+S"RJU.>#H 9C&M*%Y?A:5
M`#.<VFS,M9U:G% K^*[7:"JMX$[&C<O&Z>&"7!:Z!APPW *:C\P6>Z"WPYHE
MTSST(6JQ#;.FV.18#I41*?CA>IWW@.?J.;"=%$.168B[8>H>&M I!T/P/5[ Y9
M2"\-I!68:H\TI)GU#^-I`*T,3]:]5N32[M@.\$!=B_C0LN0@.D1T9E`+)&ZKXQ
MMC%>^D@.36:%F8H(DV*0QJJ0%H&TC22-HSIF]Y' I[)QI$HN&5.ROA+=<<O$H
M$Q+97-?S1"-*MC ])_7!GK\(LKU=MJE[NK,R0%<=!:9AQ4IT?.KQR:,M'FW:
MXZ@.'PNJ(I:CD\+-4CAI$[_"?G2URW$D.XCYR1SYDLS4.0D/"RJ&T57RS#80C
M[J!IDBVJPWZ+G'5@.R\7&\>FXU;/-;(?5@.Y;)<5),S5C4!&42/B^.#Q:YD7Z!
M/>.C(M-6I1S2T2.EQ!*?EWKL$BW"7A,=RJRE!&X,Y0=4W&AI6\P28IZ'E YU/
M)BN/`GAO;4Z6:"WM21-22KS)'$9&0^IYZGOU$T6%[S0_2#9)M.5A?/2IGN,8
M5D5&1:F=W)N0KY]O31-B(&UIMXDTBEV?R7T\>A7FGMQ+1E2PF4D5^.;0N-<F
M1RRLZXV:0E2/[:RZ"V,^I<#3[FVH,.'43SVM:>18\[L8A*1/#33:E(]@.D?
MY<XG,^^>I"D'TQ4^=$I&`8V,BX_&0>-#H[2!>W*^Y/1G-3TG78R65O6QE<^4
M'7EBFD?V#*34=T9*?1.DU#=&ZAE 93/UNZ&5V>2?0I91]<UPR]RCY*\#J7:I
M'[#-=;.ZLX7C1\<O[8/2UW@.^-).[R_W#5MP4M79I'5N79\<GYB$G,X,'2[N!
M+[:&_]$]-&2>2K+[4#QO34!/M,9B.^FLZ7XQ:GI_*-PB(?CF)$^U&G#SN]QO
M/#7F.91CEG\:RCCV+\[/PIDZ;/1$1:U1>F(F)R4^B!B!^$%6_A>&2Y_.22Y$
M@.,VU;ED#UPV%:=WF&87%HSB")WN9EMZL5:Q-#^T'%J?.B.!&YI4LN;_"R 78
MJK;!6YC[*T_J#F+MR/@.J0/LB^((>&A1UXWR3]*/TO%49_K(;X_B:,&>GS@.%S
M^?;J=?1XI"-6YGK&ZN02VBYQO0(Y,V8GD7L:^B65%BG0'>H@.O80V/]NUVV!N
MJQ 6NJF"3QL$EHO/G4_S68"O:95\!GT1%9=)H^07OH966#+!>OV#_:/#EP<_
M'[%+8#W69>U>]^7^RX/>47^?]0YQH,OZW>Y^NWO4[OX$O=XO^T>_]'_N'.SO
MXXP6P(5==K!3+O[79]TGF-([['4/>WTTA^WW'[!$"SS!DBY94J]-+T^/KRRV
M`]UZ;6)=`?M$CX*A_#S(X*.OLS_-',EMZ6)V.S;RY>=![[!>,R%ANV-2K\E_
M\!-P][$_`?\-4$L#!!0````(`+=CI#!H;K=/X0,``.4)```=````1FEX960@.
M+2!S<%]-4V5X8VQA=7-E(%-0,RYS<6RM5E%OVS80?J8`_8<#]F"KLPT[+99@.
MJ M[B=P&3.=A8,02#0$FVSE4A5E)+TW^](2K;L=D:Q[$60>+R[[SY^=Z+*
MHUB*%5]7!8.)?14T8S"&#DU3^015GM"2J4ZO,3_2M#+V4<=UW@.>N$_KGP <WL
M\OUMZ,/=Y>(#!'_Y87AYX5NSZ]"T9 7DA8Q!Y='UG#W'*:T4<QTR*>DR98+'
M7X"+$G/DU9(G4 G^M6(\8:+D*X[.@.%&4ZRA6@.I"QK$0)4KA.PC"206X"@.GBD
M1;RA1?...<#CT6O85UQ@.P,F9I+7^67#3)#Y8-L%W D].]>,>M2XI C^ZP>*)#
MV"<'L M6QC)A%I[KL&<6;Q?'EDQ+(![9JI"9J67'::\-1588H]^'CU/-8\KB
MLFT=PY^WP<*_F5[[74!,1:1C=BN>>.#!K] 9=/#9VF-4XH'."LE2#M0W)9>?
M,:J"IPU#\+6,=CET!7F!I1RL\15,)JPH9/'VW1!DL:U0?^)K58CNR*NQ0Q_^
M8&LNS&=3QO<EZ.0>6'3?(3,R@.&[M;2(10G /&AJ/C!5K1HN2QRG;5H24-E5M
M.?8:-LGD14RZCDY-=F!=QV0E[)FK4G6;8D='(=HBQKI$*I(?(X86E[Y(]!$T
M@.EM%,9S?AO,@.A*O@.?'H%L^E\$<V"\&X:7L *SZ:!@.7FC)GH/=,-$5M.UI+&W
M]W"J:HE';K<T8(W7CR%J\'84C.N9@. $1!X3^] *"FZN_74?F3&C$R!SJ90."
M/9>6'%T&ZDSN&KQWT'*:7(Z'U9U,C'.D2EI6"MZ^@.[[6&EE:D9& ?;+E6GMWP
M,!U'CLI[+1'EC/(4YR_NQ6.9*MBP-&\&IN;<),WH%\8%RJG4ZSUX8A!3`78)
M$E[@.J:3?`,.5FSI4R;(<+!2JM,.RXBD.UQPRB?3',LN09V5RH %,32\<?V A!
M5>RV:8'D>.X@.5Y!OL(/A;##0&_54;B8P_A?TV9NJ<4]4R">%BT.SV)!JS%;7
MVS:L=:U[HS66L%V@.>Q.@.&#]ZT+/6'<%[5JNICI8SJ2LQ&OA%TQ!G"70-Z![@.
M>XE2\<#\R1#!6:^![QGO_7H.A4/^Y_B&CXY1O"EO6]H`N5OCV(AEJF'47QXQ
M#J29?2V21]K"=$=W7HSQO[24S>TZ<2H5LYV9,'V+B/$&8;]=IQ[H0Y.F5O[O
MZ-MR(H=>I/47:"X5J,ZY?^6?+^ 5S,+@.&NXSJA#-P^ >?T?XW$W2![C[X./E
MI+G8[%U"C&!N/UU,%SXY$L)UYOX"R+V=$P_C_FAX^OKTS>CLY'5/'^&]UFRD
MX@.W+:/2(,<:CWUS'YB7_GEB]X/XU_-G[US]02P,$% ````@.`=9'Q+F(V27*Q
M`P``G0D``"<```!&:7AE9" M('-P7TU39F5T8VAI9&5N=&ET>7)A;F=E(%-0
M,RYS<6RE5EMSVC@.4?C8S_(?S!LD"A4UGVX>Z`TV<EMFD9!W3/F0R'E\$*#66
M*\E)TU^_1Q*V9:"9SI1AT.4[.OK.%8DB3%B^HNN2$YB::1YM" ;C0B[*,/4%9
MI)$DHC>HX,<H*S4^Z74['Q?=CN^=+SY?SC\N?0^^SH-/L/CB^?[\PC-PMS.[
M"CP?;OS%N7>AA$017M^NB$PV-"6YI/*91_F:0+<SE5&<$47 <1SQ+-1L@.-M1
M^E *&;(\>W:<F$K4>:LTIR3)(L6<HS:6$L!C-)<6P.('FCH'VRD5DM.XE(S7
M%QW":>P<0XLRSJC8$/XR&JKCAWA.?LA0$*)8Q73=YJ4=X1Q#Y(83L6%9>F"+
M\1E-OL%1,PO.$@.3RQX@.GFXCWS\;C$TND"D$HRJ)@.7!H-@.F0DD98Q[G1ZZ_D8
MV,^S:^\(CL:Z:1PJ6_LG*C3=SG (_\[@.`T%#U-*IKQ2LY D)V5-..-0.:O#O
M9931%26I5F=)X%<0>2#@.0I,W1HJNK"V@.`G(F(2^S#+'8$,+0: !N<-AT7RM%.
MC[/B;*L"B#F$@.@.*8VG0>&,T5IU(0+J#4>P[+@.8U*FNKS.*K=)W0+< =CH&$=%
M4K-L7=XF6C$\8N]_RT7@.J4CT6PI.X"_HC7KX:PG4UV)8')*GVD,Z.I5Z72.H
MU=@.9TG3OT MR;68G3=@.]=5&3)_M9YNYO#.P\=D$-VE85`^7M+>%K$G%)DXP(
MT*X%S<<UM-1EKTZ[G=-32!D4A&^I$!3#DFQ(\HWF:X1>=3OD!TF:;N%"&K.1
M;D><%%EX,[L*.4/&ZDR;4+/H=E3<=BK>O1\#XS"=8L=;^&J%0,ESZ$]V5?"+
M&S<D*ZPFA!)%(OACE2LVM%@.&-\M@.8'4E`$L&ET9"I<S\LN("[]Z#X5;=K39T
M6MD4;[TK[SQH.@.4J]@.-_?MVW*31YU<;2V""U%W53G^EFW6KMO4,_-#?:3::>
M#L 4%G[:3::ULJ7JE'6;J8U;_R'N9 ##(>V0.UUPC6#=IMIE40&BEMEVN&
M0[3NUFXSK<.T'R0<]X/4SJ+AD.944BRUGP1V10`)RU1MJ1Q?89BC-?I;C$QV
MVK:.K0H^4G6UB4-MR@.!V0T-;E^"N0FH%QFY3AU UAJ84S1\_MH)=?IW"I;^X
MAKMM)"3A]Z,[3!G\;9KK/7S]Y.';H'I\_.*-T%-JES<7L\!S7E"F\CH`YT[(
M2);BWAU.QF_.WKR>O/W[3*?$71P)$@.JL\VT4/J(.=_)/MV,8.+]#0?S!NVG\
MN^^F_P%02P,$% ````@.`MG$!+T.6BAYC! ``1PT``"4```!&:7AE9" M('-P
M7TU39V5T=&%B;&5C;VYT96YT<R!34#,N<W%LM5=M3]M($/Z\D?(?1KH/MN^2
MR X0N$H^E0.W107"A=!^0,AR[$VR/<?K>M<$_OWMB^VLK4 /]0ZDO'AF9Y^9
MYYG9#<O#F&9+LBH+#._UQRS:8/#!BM*4;J',DXAC9@.UJ\V.4ELKN6?W>QVF_
M-PO.IM<?+C[>S0+X>C'_!-,OP6QV<1YH<[]W>CD/9G SFYX%Y]*)Y>'5[0IS
M'BU2+()RG'$&_1YZGY<+DD"9D>\E)HEX3)8$%_U>I,P)CM-(XE0+,Q+_#0@.A
MDG'3EN%M&,6</.+]-I+5UHXQ*KC,7*QBSTQ^,HV/1"RMS-EC5,3KJ+ GKF/Z
M%'2[*DD2TU0[[@.G#GK,XE+%>]/A>4HZ3L.4(S8[>X:&SQWN'[D5/6:T*?R=O
MNO@.F:HX:P]Y",UX8*,:.]F-8\,?;=17*.(+AD.4X)E$*HJHD3C$P'O&2P9(6
M$"4)R5:-)5IR7( H1,[6E'>B-C$G@.'XNZB[PG.;@.F2+RH:[.H$.1+XHCEJC:
MVLJBJN4,JK+YZG70B,>OZ$3+@.FY T+O!Q0I7F!ALUUA458O<ATKM49: K1/Q
MVY4469G/]5-9^NJ/%HG(<?'<P(?3VS-AWJY)VA!+&&240U:FJ5RYP"N2J1 ,
M\P[!/HAF?,0%M[.:YX'AXE3+-#MMM<L:RK<Z;_&XW&1UQCI=C4>FJZUY07.Q
MV;,M*ZBK;Q&VBVLYOM?:LI&Y;UW=JLJ&]?0(+?BM8:&UJ-LB_E]WTWEP?7H5
MV+N .K7A\*ID'!*!"_@.:@.S2#39: GPCCS%'8"QP76$Q$M:*Q"0;U?K\V)=#2
MJ4N@.MMYMJ$(]\>=<3=(OE@.:@.R)',:H[Q$X[!MA0>A44EV4U(+\59LB_MMIJ-
MU%L&$6(XA,^G\&>CCMW(HF41XY!N,]E/S<!"YA"*4CFG$YV9Z;,36L?)[S3:
MSEN4M&WJ*MB0<)4M:H/TH1PU,54G(H,.6O7/-THRB;5DN&!0UEU%,Z"C4@.FV
ME._ZN>(0T='+V"O*%'H33!>\R5"G(B8[1@.A'D&Z-)/6OT%<KP"SXGH/$[VY;
M$Q\TBZ7H;$MK_!75B6<Z'PO$X=P6?[*@.HVZ#5FU@.FU-7!6Y-()&I;C(]!*#F
M&:&ZO]2:SNR1J]3&)M)VXL+%<627M9I$3R0?KN\N+TW#:R?$?W! P/[3P9#:
MOC.B1O"'@.>NM9T>UQXLGA[P#B'[@.\ O'FSQ4&X7B=!759/J+3-RN295?'% 7
M0F9.4]T-0I"HO@.(*E=T&E\'97&CDPVQZ!?>;B(D3^F%T+]0B7G<=^@.!?/P7B
MEEA?0_?>%BT5<J\)C3W7_=T[.3J:H!M 'G+1T'./#XX/O9/Q`?(FXH&+QJY[
M,'1/AJX'GOO..W[G>:/#(VE1#F*ABPY?]:O_Q\A]$QAOXKD3;RP`H8/Q#[ H
MAS=@.<=^(Y?\O3+]W=W-^.@._0*X3W>[?!'-"]%NR#;Z :2,7>+R*&0Q:O\28*
MQ?WDP?<F_9Y6"?J13/H]]A._<=Q_]QOG'U!+`P04````" !25Z8P< 3.)?8(
M``"?* ``(P```$9I>&5D("T@.<W!?35-M86ME97AP86YD<')O8R!34#,N<W%L
MQ5I9<]M&$GZ&JO0?NBH/(&U((1SO>A_"K+0QG:AB2PXEK1]<+A:.D8@.(!!@.,
M($K_?KOGPH $Q$.BEQ5')*:GNZ>/KWL&P^>3*,]NDMNJ8' BOV;!C,$0W"!-
M\P54\S@.H&7<]/7P?I)48]]W#@.]\N#@._&HU\OSC^<_78]'L&7LZO?X>*_H_'X
M[/U(#A\>!&G)"I@.7><1BDL/GDT^7L^".L8=YD,4T<'@.`^#F95Z&0KC[\D=-/
M3XW>),0HB=5HDI5ZA%A8$]4\.7AZ*?_^^ K>LR@.-4($@.CI,RR;,@.A?N@.2((P
M91Q>_2CI8D5$RI"L*DO^KE@.2LZQ,;A)6+%&%`6>3+(GN2)^EL ;_R).L:,_-X
M64"&:D33H.CY@.WX7CS5TVCB3-71";A[^A4OK4+AK4,PLR5@.U_S?OE@.0X)R&[
MR0LVN4_8@.IS@.=-,J>>M8:IT7&2M@.+;<-R?![Q2VI;P>#%<*"E5$>,Q5K2X.S
MBI>3:,I:G4N+GY2/<]8V\[9*XBA/=;RN4Y7(!>V3EA02NSPG!J6\IWA$LW@.R
M3UADDRF['!XX1T=PR:*J2,I'$.O&9\D-^/#S+Y#PR8S-0E;TW#B4+G!QEA.R
MVR3#O\[X].P20>%B##W_'V_>OO/ ]STX\HG(03M7108^?F=93,)$$K.41:5.
MPR'(OS=%/J/\GK'BEN&C-(D"2F4.BRG#12CP,DB"^ +7GS^/QCU!S)&H/Y0/
M3DXX*^Y9071]06A()G$XQ(702*^O%4(#E-.$6T"&/\H<0@.818B6+(7R$A_F$
M/;"H8+Q*2\Y*#WANIB^0LF (IQ! R69S$*'OH=P2HGPV$SJ0`S@.Y,8<$I],S
M98IRRF:05\J[AJMB63,DI>HIAG/)'DJ:#OF-G*LGBCD_T'R,`.CQDLU)/DC,
M0W>?7US!^?7'CQX@.@.6#3C \4D:;$"DM%()(U9C<!&@."R*DV-`1&!/\A*0UH0
MG38`Q;G2`\%#FED\DZAFL%G'1 VZ0PB*4GP5E<+&W"&8[U85$?7"A@.!%)B7)
M9S5E(]QX%'):&.-QV=*DS)SA8[.:2_MZQ!9NP0Q%_/!HXAF.]>([V'J$\6
MJ1\-_= 2242EK%,U;0MZ:FS85,LJ`;5:2Y@.N1Y!<9H@.U*F?VX3F*&:^UV $O&
MR!#^O+ZX&IV?AKU1/9ZC1IA#Z,W"ZDEPFB_;_22^FN-I#JU1UI,TBW9*CN[
M2JZ-WI1LEXJAQ#;-!A]7LZQK`<*H=1B+;!<3$+SFK,"<[I%C9<ZX"2_RA9+E
M]H?^ZO)-$=I "RN"7E"+NH8U@.\]*C;Z!Q#^KG( -P4^'[#' 64F /0MBI3Y&
MGUS,8II$4QQXA&EPC^ 4QT#8%D24Y\=:C24=:D?7C_L6;:._&^*Z,RPU9<_N
MS#R+RI[::/DZIQHJ>VJC"^R<JJGZ=B41\^L6`!M\51_J>A>'^;$+KZU^^S6X
MEH,1)](\NQ7%HWYZ>@.E4Y>LV0]6C9@.WQZGZ+IH,K&209IE$IRZ$N43U5A?H@.
M]B(<>K7>_:[%D K8KF@.5A^#7&JHVQ8Y3VBWD6*;#*KW32J *<L<"/R@.NNBZ9
M#8L*5KW$(9R[KMQ!F3FDVDT:D K"E@.V7D3UE+@.F2G]M)7+<IECJ.VGQ#VF#1
MHPKW;7^G1IOF'++%"2L*++?8P T`_QH.XH'NRG9W!";B'Z=P!/^1YL6?K:[!
MS+=Y*S/U!.!2?'N@.<,$31L&.ZBZ92T?TM<7CA)=)AE^$O1JY]]I(UA_<R]9D
M$M?1J,<U^G@.PP/\D2M24$N*)LF6V8+DBR:X-9J)53L1$O>)0>;Y74ZD6!<ED
M@.THC'4+:UH'&#?5/,3\\-E;5X=<`&PH_T7 :"R/90.?B_\%S^W8;@.5.W-[=T
MI6'V; ]_=_?J5!U9,/'"``S6NL193,IHQU#-Q19.'< XCM.*H;&D%J[5UI2V
M;*S%%\O3)I%;3\?I*9;Z>0L7!<@.#L1]UNJ5INE4YMLLV%4@.XVW=%:7(VQ7!'
MEK&-H+LV.*/0>I9#ZXA YWU)TI1VLZ)?0C[R' 27BQOB:5#24(!=%$G(\E(N
M_-^F6J+^[ '3GAM#O7J1_0(TBASF04_NV!I[NS[\`@.-K32)0K<,<TQBP%/-R
MK:K/W1,V=19D\L!Q<L<>R9O^-KJBL5]&W\:NNF6WJ#^K:T.5E_O+=M4'3S>?
M5NS2XE::M2ZDT-V6B;N7:;A@.;TFZ>UINW&&YZ]K9VEB4H\B&%F K5!-T5O...
M>S'"Y V*^9&_8P=&_#?KO.IE9=MT7[6 CK*<->MRMJ8P=Y;,K=RV/Y_MQV%/
M]UX;.K&[Y]K%MR_OV$9C1>PM\-PY\1V,BS&;Y?<M_1/^6PVD]3U5;:U&HW/4
MUE&UMS>M'!#ICGS5XFP.GMM@.I[.+_>2KBY5C33H?HA)*I];UVXM5D'6<MGJU
M=]C<<C/T//Q<M@.WEVMY!U$PSYXTD=NNT$YG<?@.2T-XC<KW,VP,K].FR_WEI"
MR5U2VED#BGM&15CZ[(21NYSI;=EJ[F9<IC<I9@./7VLLOG:.V-#0[]NV#%?M_
M[UWS,W;.QGAZE]9XR^=O9CHZ/P'Q;N,+O6[.(,XAKPJU\UXDY52WB3* /?E#
M6G6#0^H7#GN1Y/;;*T*&&O#J%RD$,TTVVP7"]T@.;9V\1@.>X40;% S,HSMX0P
M+W%]JL%'8+7-8-Z,JY?B'*N1>,E%-YKP7_08(>H9QM;[<R[\)N:J#B=0UYJ
M3AF(\AC@.BNX*5 7'*A*+&PWB=@.,:4,KGAC,)J[(@.BMB<@./T1>)HO/"6#M%GD
M51H#ELLTE;<CN#G+R8OY-,A8+ ^+(D&81RCV6.UGS_,%F4/%$5T46+G#8*Y(
M@.'R/B$QCLD<N#Y]$6M"%C,(3')>O9&"VH%XJ*IK<:;I\Z\7%`"^%,<P;,*&D
M4DU?A9 IHV]/2%5"M$G)YD0MK\#1Y9G1Q]&O5_ */HPO/L'768 4Q;?CKW&8
MX__K%\/?X,OOH_%(WV1Q6V[+N<3R^O/[TZN1\P2CPX/+T14X7WD9E!7_-CSR
M!^]^>O?6_]>;GSQ"XJ^BF> ((;-@.<H\\AOX_#P^D=&>=>/Z,FX.#36\._@.]0
M2P$"% L4"P``" #-D/$NU$4\;<@.I```LO0``(@.`````````!`" `````````
M1FEX960@.+2!S<%]A9&1M97)G96%R=&EC;&4@.4U S+G-Q;%!+`0(4"Q0+```(
M`*ECI#!<5R3*=@.D``*PE```A``````````$`( ````@.J``!&:7AE9" M('-P
M7V%D9&UE<F=E9FEL=&5R(%-0,RYS<6Q02P$"% L4"P``" !CD@.4O6?!2!(,(
M``!H'@.``(P`````````!`" ```"],P``1FEX960@.+2!S<%]-4V%R=&EC;&5C
M;&5A;G5P(%-0,RYS<6Q02P$"% L4"P``" "W8Z0P:&ZW3^$#``#E"0``'0``
M```````!`" ```"!/ ``1FEX960@.+2!S<%]-4V5X8VQA=7-E(%-0,RYS<6Q0
M2P$"% L4"P``" !UD?$N8C9)<K$#``"="0``)P`````````!`" ```"=0 ``
M1FEX960@.+2!S<%]-4V9E=&-H:61E;G1I='ER86YG92!34#,N<W%L4$L!`A0+
M% L```@.`MG$!+T.6BAYC! ``1PT``"4``````````0`@.````DT0``$9I>&5D
M("T@.<W!?35-G971T86)L96-O;G1E;G1S(%-0,RYS<6Q02P$"% L4"P``" !2
M5Z8P< 3.)?8(``"?* ``(P`````````!`" ````Y20``1FEX960@.+2!S<%]-
M4VUA:V5E>'!A;F1P<F]C(%-0,RYS<6Q02P4&``````<`!P`T`@.``<%(`````
`
end
|||Thanks Kestutis,
to clarify though, the issue stems from the fact the tables I'm replicating
are not owned by dbo, right? I am not at an advanced (or even intermediate)
level of sql server administration so executing scripts that I don't
understand make me a little nervous. What I mean is, would dropping
replication, then changing ownership of all the tables to dbo, and then
recreating the merge replication be an alternative fix? If so, I may prefer
that, if not, I will try to get famaliar with the scripts you supplied on a
test server and try to use them.
thanks again.
"Kestutis Adomavicius" <kicker.lt@.noads-tut.by> wrote in message
news:O2YNs$PZEHA.1152@.TK2MSFTNGP09.phx.gbl...
> I attached fixes to stored procedures which are designed for SQL Server
2000
> SP3a
> They should be executed on master database. Be careful with them, execute
> parts of every script step by step.
> At the end of every script there is update to sysobjects table, which
> restores initial state of stored procedure (which is changed after "alter
> procedure" statement is executed). So before altering procedure, check if
> this update will restore correctly stored procedure status (status in
update
> statement should match status which you will see in resultset, received
from[vbcol=seagreen]
> select statement which is commented near to update).
> Those are procedures which i met on my way of deploying merge replication.
> First of all I fixed four procedures, but when I added publication
> filtering, I had to fix some more Now I am applying those fixes to all
> new servers I am installing (where merge replication is used) and every
> manipulations to merge replication are working smoothly.
> --
> Regards,
> Kestas
>
> "djc" <noone@.nowhere.com> wrote in message
> news:%23d2H5xOZEHA.3368@.TK2MSFTNGP12.phx.gbl...
think[vbcol=seagreen]
issue[vbcol=seagreen]
to[vbcol=seagreen]
> not
MS[vbcol=seagreen]
does[vbcol=seagreen]
> leaves
> table
I[vbcol=seagreen]
are
> (and
>
>
|||Yes of course it is a much more appropriate option to change the owner of
the tables, because this way you don't have to modify system stuff which is
not so nice
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"djc" <noone@.nowhere.com> wrote in message
news:ernO0wQZEHA.2500@.TK2MSFTNGP09.phx.gbl...
> Thanks Kestutis,
> to clarify though, the issue stems from the fact the tables I'm
replicating
> are not owned by dbo, right? I am not at an advanced (or even
intermediate)
> level of sql server administration so executing scripts that I don't
> understand make me a little nervous. What I mean is, would dropping
> replication, then changing ownership of all the tables to dbo, and then
> recreating the merge replication be an alternative fix? If so, I may
prefer
> that, if not, I will try to get famaliar with the scripts you supplied on
a[vbcol=seagreen]
> test server and try to use them.
> thanks again.
>
> "Kestutis Adomavicius" <kicker.lt@.noads-tut.by> wrote in message
> news:O2YNs$PZEHA.1152@.TK2MSFTNGP09.phx.gbl...
> 2000
execute[vbcol=seagreen]
"alter[vbcol=seagreen]
if[vbcol=seagreen]
> update
> from
replication.[vbcol=seagreen]
all[vbcol=seagreen]
> think
> issue
> to
are[vbcol=seagreen]
> MS
> does
Various[vbcol=seagreen]
just[vbcol=seagreen]
your[vbcol=seagreen]
replication.[vbcol=seagreen]
> I
> are
this:[vbcol=seagreen]
not
>
|||thanks again. Do I also have to enable 'cross database ownership' ? I saw a
similar issue that mentioned this but I don't know if it applies to me?
"Kestutis Adomavicius" <kicker.lt@.noads-tut.by> wrote in message
news:%23CZMK0QZEHA.996@.TK2MSFTNGP12.phx.gbl...
> Yes of course it is a much more appropriate option to change the owner of
> the tables, because this way you don't have to modify system stuff which
is[vbcol=seagreen]
> not so nice
> --
> Regards,
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
>
> "djc" <noone@.nowhere.com> wrote in message
> news:ernO0wQZEHA.2500@.TK2MSFTNGP09.phx.gbl...
> replicating
> intermediate)
> prefer
on[vbcol=seagreen]
> a
Server[vbcol=seagreen]
> execute
> "alter
> if
received[vbcol=seagreen]
> replication.
> all
every[vbcol=seagreen]
how[vbcol=seagreen]
> are
from[vbcol=seagreen]
SP3a)[vbcol=seagreen]
> Various
> just
it[vbcol=seagreen]
drop[vbcol=seagreen]
> your
are[vbcol=seagreen]
> replication.
elements
> this:
> not
>
|||As far as I understood from your situation description, this should not have
anything to do with 'cross database ownership'
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"djc" <noone@.nowhere.com> wrote in message
news:OMyx$qSZEHA.3716@.TK2MSFTNGP11.phx.gbl...
> thanks again. Do I also have to enable 'cross database ownership' ? I saw
a[vbcol=seagreen]
> similar issue that mentioned this but I don't know if it applies to me?
> "Kestutis Adomavicius" <kicker.lt@.noads-tut.by> wrote in message
> news:%23CZMK0QZEHA.996@.TK2MSFTNGP12.phx.gbl...
of[vbcol=seagreen]
> is
then[vbcol=seagreen]
> on
> Server
which[vbcol=seagreen]
check[vbcol=seagreen]
in[vbcol=seagreen]
> received
to[vbcol=seagreen]
> every
I[vbcol=seagreen]
the[vbcol=seagreen]
> how
they[vbcol=seagreen]
> from
> SP3a)
> it
> drop
this[vbcol=seagreen]
> are
> elements
should[vbcol=seagreen]
a
>
|||thanks again.
"Kestutis Adomavicius" <kicker.lt@.noads-tut.by> wrote in message
news:O9kaUAYZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> As far as I understood from your situation description, this should not
have[vbcol=seagreen]
> anything to do with 'cross database ownership'
> --
> Regards,
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
>
> "djc" <noone@.nowhere.com> wrote in message
> news:OMyx$qSZEHA.3716@.TK2MSFTNGP11.phx.gbl...
saw[vbcol=seagreen]
> a
> of
which[vbcol=seagreen]
> then
supplied[vbcol=seagreen]
> which
> check
> in
> to
that[vbcol=seagreen]
> I
> the
out[vbcol=seagreen]
> they
server[vbcol=seagreen]
you[vbcol=seagreen]
because[vbcol=seagreen]
on[vbcol=seagreen]
> this
Fixes[vbcol=seagreen]
get[vbcol=seagreen]
> should
in
> a
>

Thursday, March 22, 2012

Cannot open user defualt database. Login failed.

Hi,

I know that there have been numerous posts on this topic, however none of the suggestions seems to resolve my problem. I am running a ASP 2.0 web application locally using SQL server 2005 express, but after using SQL Server Management Studio to browse the database of the application i get the following error everytime i log into the website:

Cannot open user default database. Login failed. Login failed for user '<<machine name>>\ASPNET'

All i had done is attach then detatch the database in SSMS and it seems to have changed the access permissions somehow.
I have ensured that the ASPNET user has full permissions (server roles and User mapping) in SSMS and i have granted the ASPNET user full rights to the ASPNETDB.MDF and log file, but i still get the same error.

Its really urgent i sort this problem out as soon as possible, so if anyone has tackled this problem before please help. Ideally i don't want to have to reinstall sql server, but if that is the only option and it will definitely fix the problem then i will.

Thanks,

Jack

Hey,

No, it didn't change permissions. It probably set the ASPNET account to that database, and now that database is detached and gone. With an admin account, go in, and change the default database for the ASPNET account.

|||

Thanks for your quick reply.

Currently when i log into SSMS i use windows authentication, and am an administrator on the system. So do you mean that when i go into SSMS that i need to attach ASPNETDB.mdf and then change the default database for the ASPNET account underSecurity > Logins. Then detach the db again?

I'm pretty new to sql server express, so if you could walk me through the steps i'd really appreciate it.

Thanks again.

|||

Hey,

Actually, that sounds about right. You know more than you think.

Cannot open user default database. User login failed.

Hi,

I'm sorry if this is simple, I'm no DBA but have been tasked with solving this problem...

We have a website that connects via ODBC to SQL Server (2k sp1) and at the moment I am getting back about every other time:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default database. Login failed.

So this is NOT happening every single time. Now I have seen Microsoft KB - 307864 and I can see that none of the databases are marked as suspect, the database I am trying to connect to does exist and is attached and, I have run the command to switch the database to multi-user mode.

The probable cause of this problem is that a while ago we had a hard-drive failure and I was forced to reattach some old datafiles (mdf,ldf) as the database. This seemed ok and I can view data etc in enterprise manager no problem.

I have checked for orphaned users and the user I am logging in with from the webpage is not listed.

So does anyone have a clue as to why this is happening, and more frustratingly for me, why is it only happening some of the time.

Thanks for your help, appreciated.

James.Edit your odbc connection and check the default database drop down box...it's probably set to master...|||Brett - Thanks for posting.

Have checked the ODBC settings and the database is not set to master as default .|||Originally posted by JDMoore
Brett - Thanks for posting.

Have checked the ODBC settings and the database is not set to master as default .

What ODBC says if you are trying to test data source under this account?
If everything is fine with ODBC - check your application...|||ODBC says that the connection is fine.

The application has not been changed and has worked fine so I'm virtually certainly it's nothing to do with the program code. The code in question is simply opening a connection to the database.

As I say the error is sporadic presumably an ODBC connection string can either be right or wrong?|||Remotely, but possible, that the default database is in single user mode, and if you login successfully, it means that you're the first one to show up, while when you get an error, then someone's already there (that's to attempt to explain the sporadic nature of the error.) But to be proactive, open EM and go to that database (make sure to register the server with sysadmin privileges.) Check the Options tab of the properties to ensure that the database is not in single user mode. Also, go to Security folder, then to Logins and open properties for the account that the app uses to login and set the default database to master. This is to prevent the situation when a different database was renamed to the one that is specified now as default. And finally, speaking about renamed databases, can you check if it happened recently?|||You might also want to check the connection type in the ODBC. There are times when it doesn't matter whether your using Pipes or Ip but it will test just fine then throw sporadic error messages when actually using the application.

I would try going into the client config button (2nd screen in the ODBC) and if it's set to Pipes then make it IP (port 1433 is default but may have to be changed depending on network) or vice versa.|||Run sql profiler to see what logins are attempting to connect - I am curious to see if the problem is that the iuser account is failing to connect ...|||Thanks for all the suggestions. I am not in until Monday now but when I get in, I will try everything and then get back to you all.

Thanks for posting.|||As always it turned out to be pretty simple...

As I looked further through the code it turned out that the program was looking at this database and then looking at a database on a different server.

When I went to the other server it turned out that THIS database was in single-user mode and hence the sporadic nature of the problem was explained.

Thanks very much for everyone's contribution, probably wouldn't have stumbled over this for ages without your suggestions.

James.

Cannot open user default database. Login failed?

Hi All,
I have not been using my SQL server 2000 for a while on this particular
machine. I had my account disabled and just got it re-enabled at work.
Login name is the same and password has changed as it does every 30 days. I
am trying to get into my server but keep getting the following error
message:
"SQL Server registration Failed because of the connection failure displayed
below. Do you wish to Register anyway?"
"Cannot open user default database. Login Failed"
I am at a loss and if anyone could suggest something to me other than
un-installing the instance and re-installing it, I would be appreciative.
Thanks,
JohnSeems like your account doesnt´have access to the default database, just try
to EXEC sp_grantdbaccess
with an administrative account for this user.
HTH, Jens Süßmeyer.
"John Rugo" <jwrugo@.patmedia.net> schrieb im Newsbeitrag
news:ObRFOWIfDHA.2320@.TK2MSFTNGP12.phx.gbl...
> Hi All,
> I have not been using my SQL server 2000 for a while on this particular
> machine. I had my account disabled and just got it re-enabled at work.
> Login name is the same and password has changed as it does every 30 days.
I
> am trying to get into my server but keep getting the following error
> message:
> "SQL Server registration Failed because of the connection failure
displayed
> below. Do you wish to Register anyway?"
> "Cannot open user default database. Login Failed"
> I am at a loss and if anyone could suggest something to me other than
> un-installing the instance and re-installing it, I would be appreciative.
> Thanks,
> John
>|||John,
See if this helps...
'Locked Out of SQL Server - Q. I locked myself out of SQL Server without
being able to log on with a sysadmin login. Can I fix this, or do I need to
reinstall SQL Server'
http://www.microsoft.com/sql/techinfo/tips/administration/May3.asp
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"John Rugo" <jwrugo@.patmedia.net> wrote in message
news:ehaGFkIfDHA.1764@.TK2MSFTNGP09.phx.gbl...
> Unfortunately I can't get in as sa or any other login account using osql
or
> enterpise mgr or sql analyzer. I think I will have to uninstall the
> instance and re-install it. the odd thing is that SA doesn't even work.
> Thanks for you help.
> "Jens Süßmeyer" <jsuessmeyer@.[REJECT_SPAM]web.de> wrote in message
> news:OfsbMfIfDHA.1872@.TK2MSFTNGP09.phx.gbl...
> > Seems like your account doesnt´have access to the default database, just
> try
> > to EXEC sp_grantdbaccess
> > with an administrative account for this user.
> >
> > HTH, Jens Süßmeyer.
> >
> > "John Rugo" <jwrugo@.patmedia.net> schrieb im Newsbeitrag
> > news:ObRFOWIfDHA.2320@.TK2MSFTNGP12.phx.gbl...
> > > Hi All,
> > >
> > > I have not been using my SQL server 2000 for a while on this
particular
> > > machine. I had my account disabled and just got it re-enabled at
work.
> > > Login name is the same and password has changed as it does every 30
> days.
> > I
> > > am trying to get into my server but keep getting the following error
> > > message:
> > >
> > > "SQL Server registration Failed because of the connection failure
> > displayed
> > > below. Do you wish to Register anyway?"
> > >
> > > "Cannot open user default database. Login Failed"
> > >
> > > I am at a loss and if anyone could suggest something to me other than
> > > un-installing the instance and re-installing it, I would be
> appreciative.
> > >
> > > Thanks,
> > > John
> > >
> > >
> >
> >
>

Cannot open user default database. Login failed. Login failed for user 'UserName'. (Microsoft

Hi,

SQL Server 2005 installed on my computer. i was trying to make a login page with VS.2005 pro. But i got some errors on Website Administration Tool. Whatsoever, i registered a database (aspnetdb) . Then, i think i made my default database to aspnetdb. Something went wrong and i decided to delete aspnetdb and start whole procces from the begining and i did it. AAANDD WHOOOLA. I got this error:

Cannot Open User Default Database, Login Failed
Microsoft SQL Server, Error 4064

Is there anyway to change my default database to "master" again? Or simply will i uninstall all the sql server 2005?
(?f you say uninstall, answer this:: Will be any problem on VS 2005? I can't uninstall both :) )

You should determine what is the login you are connecting at, then login as administrator and issue an ALTER LOGIN statement to set the default database for that login to master. See Books Online for additional information on using the ALTER LOGIN statement.

Thanks
Laurentiu|||I don't think that Laurentiu understands the problem. I have run into the same situation, I am an administrator on the server, because the default database no longer exists (I had changed it from master) I can no longer connect. I would like to think that in the absence of my default database, it would revert to the master, but this is not the case. I'm unable to connect using the Administrator login to execute the ALTER LOGIN command.|||

You can resolve this by specifying another database you want to connect to; master, for example. Then you can reset the login's default database. With sqlcmd, you can do the following:

sqlcmd -d master -U sa -P mypassword

and then:

alter login sa with default_database = master

Thanks
Laurentiu

|||I've googled this error message and I get a hundred hits. Shouldn't there be a KB? I have exactly the same problem. I changed the default DB, then dropped it. I have no idea what the sa password is. Do I need to uninstall/reinstall SS05?|||

I already posted an answer above. You just need to specify a different database to use at connection time, then change your default database to an existing one.

I'll check to see if we have a KB article on this and pass your feedback to write one if we don't already have it.

Thanks
Laurentiu

|||

I see now that you mentioned that you don't know sa's password.

sa was just provided as an example, for this operation you don't necessarily need to use sa to connect. You just need to connect with the login for which you've received this error. If you use Windows authentication, then you should connect like this:

sqlcmd -E -d master

then issue the ALTER LOGIN statement.

It's the "-d master" that's the key here - it specifies that the connection should be made to the master database, so the login won't try to connect to the database that no longer exists.

Hope this makes the solution clearer. If you still have problems with resetting the default database, let us know.

Thanks
Laurentiu

|||To me this seems like a bug with Sql Server Management Studio, as you can connect to the database by specifing the database under options. You cannot however change the user's default database as right click -> properties tries to make a new connection using the default database. As far as I can see, it should create the new connection with the same database specified in the options section?|||

You should post to SQL Server Tools General, for Management Studio issues. You can also search for existing bugs on this issue or open a new one at: http://lab.msdn.microsoft.com/productfeedback/.

Thanks
Laurentiu

|||

I got the same error with SQL Server Management Studio and could not resolve it with sa authentication because my config wouldn't let me log in as sa.

Selecting master as the connect database in the login dialog got me in. I then tried to edit my login object to change my default database, but this fails with the same error!

I then tried deleting my login. Failed again with error 4064.

Finally, I tried to right-click on the login object, and selected Script Login As > DROP to > New Query Editor Window, and then hit Execute in the view that appeared. It worked!

Hope this helps someone out there...

|||

I just ran into the same issue after I dropped a database that was mistakenly set to be the default database. I found the information posted here pointed me in the right direction, but it didn't really help much because I couldn't figure out which user should be modified when SQL Server 2005 is configured to use Windows authentication (e.g. trusted connections) exclusively. After a lot of digging through SQL Server Books Online, executing various stored procedures to dump login information, and experimentation, I finally stumbled on the right combination.

C:\> sqlcmd -E -d master

1> ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=master

2> GO

I show the prompts above so you can see where to type the commands and the expected results (e.g. SQLCMD does not output any information or error messages).

|||

I detached a database on a network server with the idea of reattaching an updated version from my local db.

Evidently, the database I detached was the default database. I couldn't log in now because of the posts in this thread. I was able to log in using the Master db at the login dialog. However, I've tried everything in this post, and nothing seems to work!

When I try to execute a query against the master db (such as the sql in these posts), it executes fine. In the drop down list of available databases, the only thing it has is master... the rest says "server is not available". I'm able to ping it just fine.

I can't even restore the db I detached, because I get the same error msgs as not being able to log on. I desperately need to attach this database again with master as the default db.

How can I accomplish this? Can someone please help?

|||

The only thing I can do with logging in as master, is simply just to look at objects. I cannot perform any action at all against anything because of the same error message (Cannot open user default database. Login failed for user sa...).

How can I resolve this!!!!

Microsoft, please help..........

|||For what it's worth, the db icazon next to the server is simply a white circle (no activity, etc)....|||

I tried what you're mentioning Chris and it didn't work.

In the query window I have the following:

IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sa')

DROP LOGIN [sa]

The results state the following:

Msg 15405, Level 16, State 1, Line 3

Cannot use the special principal 'sa'.

Cannot open user default database. Login failed. Login failed for user 'UserName'. (Microsoft

Hi,

SQL Server 2005 installed on my computer. i was trying to make a login page with VS.2005 pro. But i got some errors on Website Administration Tool. Whatsoever, i registered a database (aspnetdb) . Then, i think i made my default database to aspnetdb. Something went wrong and i decided to delete aspnetdb and start whole procces from the begining and i did it. AAANDD WHOOOLA. I got this error:

Cannot Open User Default Database, Login Failed
Microsoft SQL Server, Error 4064

Is there anyway to change my default database to "master" again? Or simply will i uninstall all the sql server 2005?
(?f you say uninstall, answer this:: Will be any problem on VS 2005? I can't uninstall both :) )

You should determine what is the login you are connecting at, then login as administrator and issue an ALTER LOGIN statement to set the default database for that login to master. See Books Online for additional information on using the ALTER LOGIN statement.

Thanks
Laurentiu|||I don't think that Laurentiu understands the problem. I have run into the same situation, I am an administrator on the server, because the default database no longer exists (I had changed it from master) I can no longer connect. I would like to think that in the absence of my default database, it would revert to the master, but this is not the case. I'm unable to connect using the Administrator login to execute the ALTER LOGIN command.|||

You can resolve this by specifying another database you want to connect to; master, for example. Then you can reset the login's default database. With sqlcmd, you can do the following:

sqlcmd -d master -U sa -P mypassword

and then:

alter login sa with default_database = master

Thanks
Laurentiu

|||I've googled this error message and I get a hundred hits. Shouldn't there be a KB? I have exactly the same problem. I changed the default DB, then dropped it. I have no idea what the sa password is. Do I need to uninstall/reinstall SS05?|||

I already posted an answer above. You just need to specify a different database to use at connection time, then change your default database to an existing one.

I'll check to see if we have a KB article on this and pass your feedback to write one if we don't already have it.

Thanks
Laurentiu

|||

I see now that you mentioned that you don't know sa's password.

sa was just provided as an example, for this operation you don't necessarily need to use sa to connect. You just need to connect with the login for which you've received this error. If you use Windows authentication, then you should connect like this:

sqlcmd -E -d master

then issue the ALTER LOGIN statement.

It's the "-d master" that's the key here - it specifies that the connection should be made to the master database, so the login won't try to connect to the database that no longer exists.

Hope this makes the solution clearer. If you still have problems with resetting the default database, let us know.

Thanks
Laurentiu

|||To me this seems like a bug with Sql Server Management Studio, as you can connect to the database by specifing the database under options. You cannot however change the user's default database as right click -> properties tries to make a new connection using the default database. As far as I can see, it should create the new connection with the same database specified in the options section?|||

You should post to SQL Server Tools General, for Management Studio issues. You can also search for existing bugs on this issue or open a new one at: http://lab.msdn.microsoft.com/productfeedback/.

Thanks
Laurentiu

|||

I got the same error with SQL Server Management Studio and could not resolve it with sa authentication because my config wouldn't let me log in as sa.

Selecting master as the connect database in the login dialog got me in. I then tried to edit my login object to change my default database, but this fails with the same error!

I then tried deleting my login. Failed again with error 4064.

Finally, I tried to right-click on the login object, and selected Script Login As > DROP to > New Query Editor Window, and then hit Execute in the view that appeared. It worked!

Hope this helps someone out there...

|||

I just ran into the same issue after I dropped a database that was mistakenly set to be the default database. I found the information posted here pointed me in the right direction, but it didn't really help much because I couldn't figure out which user should be modified when SQL Server 2005 is configured to use Windows authentication (e.g. trusted connections) exclusively. After a lot of digging through SQL Server Books Online, executing various stored procedures to dump login information, and experimentation, I finally stumbled on the right combination.

C:\> sqlcmd -E -d master

1> ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=master

2> GO

I show the prompts above so you can see where to type the commands and the expected results (e.g. SQLCMD does not output any information or error messages).

|||

I detached a database on a network server with the idea of reattaching an updated version from my local db.

Evidently, the database I detached was the default database. I couldn't log in now because of the posts in this thread. I was able to log in using the Master db at the login dialog. However, I've tried everything in this post, and nothing seems to work!

When I try to execute a query against the master db (such as the sql in these posts), it executes fine. In the drop down list of available databases, the only thing it has is master... the rest says "server is not available". I'm able to ping it just fine.

I can't even restore the db I detached, because I get the same error msgs as not being able to log on. I desperately need to attach this database again with master as the default db.

How can I accomplish this? Can someone please help?

|||

The only thing I can do with logging in as master, is simply just to look at objects. I cannot perform any action at all against anything because of the same error message (Cannot open user default database. Login failed for user sa...).

How can I resolve this!!!!

Microsoft, please help..........

|||For what it's worth, the db icazon next to the server is simply a white circle (no activity, etc)....|||

I tried what you're mentioning Chris and it didn't work.

In the query window I have the following:

IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sa')

DROP LOGIN [sa]

The results state the following:

Msg 15405, Level 16, State 1, Line 3

Cannot use the special principal 'sa'.

sql

Cannot open user default database. Login failed. (only when IDE is open)

I get the below error only when my IDE open. It connects well when it is found closed.

[SqlException (0x80131904): Cannot open user default database. Login failed.
Login failed for user 'JP\ASPNET'.]

I could solve this by giving the logged in windows user to impersonate under IIS window > WEBSITE > ASP.NET tab > EDIT CONFIG > APPLICATION tab

But I wish someone could give me the proper solution.

I almost tried all from giving ASPNET user as a administrator to configuring the same in Express management tool.

Environment: XP pro, VWD and SQL Express

The problem i think is that u-r user that u r using has default database and that dont exist, to correct that u must go in the property of that user in Sql menagment system and set other default databse for that user..

I hope this will help

Sorry for my bad english

|||

I believe that when you have the database opened as "user instance" it can not be opened by more than one application, like Visual Studio and SQL Server Management Express, etc.

|||

Hi jpbiznes,

Could you please explain a little more?

where did you get that error message? From VWD or from IIS ? I guess it is from IIS since if you are using VWD accessing database, the account should be the one which you use to run VWD -- in this case the account won't be ASPNET.

I get the below error only when my IDE open.

There is a possibility that if you have attached your database file from one process, you cannot attach it again from another process. Since one physical database file cannot be attached by two different instances (note we use customer instance in sql2005 express). But in that case the error message should look lik: cannot attach database again since database file is currently in use.

Also, I performed a search through internet and find this KB article which may be helpful to you:

SYMPTOMS

loadTOCNode(1, 'symptoms');

Each user has a default database. When you connect to computer that is running Microsoft SQL Server, and you do not specify a login database, the default database is used. However, if the default database is unavailable at the time of the connection, you may not be able to connect. Instead, you receive error message 4062 or error message 4064. The text of the error messages is as follows:

Cannot open user default database

CAUSE

loadTOCNode(1, 'cause');

The user default database is unavailable at the time of connection. It is possible that the database:

?Is in suspect mode.?No longer exists.?Is in single user mode and the only available connection is already being used by someone else or by something else.?Has been detached.?Has been set to the RESTRICTED_USER state.?Is offline.?Is set to emergency status.?Does not have the login account mapped to a user or the user has been denied access.?Is part of a database mirror.

Additionally, the login account may be a member of multiple groups and the default database for one of those groups is unavailable at the time of connection.

http://support.microsoft.com/?id=307864

Hope my suggestion helps

Cannot open user default database. Login failed.

Hi,

I got this application system having SQLExpress as database (ABCSystem.mdf). I'm connecting to the database thru connection string specifying database path in App.config.

At the same time, I got two paths for the mdf files. The first one is the path for my database project while the second one is the path to conduct testing. (This means that I got identical ABCSystem.mdf in two paths)

1) C:\Program Files\Company ABC\ABCDatabaseProject\

2) C:\Program Files\Company ABC Limited\ABCSystem\Database\

In my development machine, I can run my application where database path is testing path (number 2).

When I tried to copy the ABCSystem.mdf and ABCSystem_log.LDF and my application program files to another PC to test, I got the subject error message. (note that I copy program files under directory "C:\Program Files\Company ABC Limited\ABCSystem\" and mdf files under "C:\Program Files\Company ABC Limited\ABCSystem\Database\")

I try to edit path from database testing path to database project path in app.config, run the application, and notice that it is running OK.

What seems to cause the problem? Coz I need the database in the testing path which is "C:\Program Files\Company ABC Limited\ABCSystem\Database\" AND NOT "C:\Program Files\Company ABC\ABCDatabaseProject\".

Thanks alot for your kind attention.

Try this first, and then check your string accordingly:

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

Buck Woody

|||I'm having this identical issue with an ODBC connection.
After wasting hours, I realized I only get the error when I try to change database name. (e.g. from a development to a production server). Based upon everything I've tried, I determined you CANNOT change server name in a Crystal report programmatically as in the Crystal sample code. It may be a possible to change servers if using a command based report (explicit SQL query), but our reports all use tables so a trial would be irrelevant.

Cannot open user default database. Login failed.

Cannot open user default database. Login failed.
Login failed for user '[machine name]\ASPNET'.

I'm working in VS 2005 with a starter kit. I close VS and open an MDF file in SQL Server 2005 Management Studio to modify a table. I attach the file, change a data type, then detach the file. When I go back to VS and try to run the program, I get this error. Everything runs normally before I bring the file into Management Studio. It is not a permissions issue. Does SQL Server put some kind of lock on the file? This must be a fairly common problem. A developer will sometimes want to modify an .mdf file. How does he do that and then run his program? Thank you for any suggestions I can try.

What authentication is this instance. Post your connection string... this seems to be the problem with ASPNET user. The "ASPNET" user account is created in Windows XP by Microsoft .NET Framework. In the connection string you use a SQL Server Login and try.

From the link mentioned below :-

Applications that use SQL Authentication to connect to a database are not generally affected by using the ASPNET account. Applications that use integrated authentication and impersonation are also not generally affected. However, if an application is not impersonating and is using Integrated Authentication, you must grant access to the database for the ASPNET account.

You cannot use the ASPNET account when you try to authenticate to Microsoft SQL Server by using Integrated Authentication over named pipes. However, you can use the ASPNET account together with Integrated Authentication over the Transmission Control Protocol (TCP) transport.

If an application must use a Microsoft Access database, the ASPNET account must be able to write to the database file. Administrators must change the file permissions to allow this use.

Refer :

http://support.microsoft.com/kb/895967/

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=214866&SiteID=1

Madhu

|||

Hi

Seen that before.

Someone has modified your login or the default database is unavailable.

You can use the following command to log on using Query Analyser. Run it the in the RUN window.

Code Snippet

isqlw -S servername -E (-U username -P password if using sql login) -d master

This will log you on to master database and then you can check for any problems or reset the default database using sp_defaultdb.

hope that helps

Jag

Cannot open user default database. Login failed.

Hi,

I got this application system having SQLExpress as database (ABCSystem.mdf). I'm connecting to the database thru connection string specifying database path in App.config.

At the same time, I got two paths for the mdf files. The first one is the path for my database project while the second one is the path to conduct testing. (This means that I got identical ABCSystem.mdf in two paths)

1) C:\Program Files\Company ABC\ABCDatabaseProject\

2) C:\Program Files\Company ABC Limited\ABCSystem\Database\

In my development machine, I can run my application where database path is testing path (number 2).

When I tried to copy the ABCSystem.mdf and ABCSystem_log.LDF and my application program files to another PC to test, I got the subject error message. (note that I copy program files under directory "C:\Program Files\Company ABC Limited\ABCSystem\" and mdf files under "C:\Program Files\Company ABC Limited\ABCSystem\Database\")

I try to edit path from database testing path to database project path in app.config, run the application, and notice that it is running OK.

What seems to cause the problem? Coz I need the database in the testing path which is "C:\Program Files\Company ABC Limited\ABCSystem\Database\" AND NOT "C:\Program Files\Company ABC\ABCDatabaseProject\".

Thanks alot for your kind attention.

Try this first, and then check your string accordingly:

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

Buck Woody

|||I'm having this identical issue with an ODBC connection.
After wasting hours, I realized I only get the error when I try to change database name. (e.g. from a development to a production server). Based upon everything I've tried, I determined you CANNOT change server name in a Crystal report programmatically as in the Crystal sample code. It may be a possible to change servers if using a command based report (explicit SQL query), but our reports all use tables so a trial would be irrelevant.

Cannot open user default database. Login failed

Hi,

I have installed SQL Server 2005 Express edition and when i try to run the web site as http://127.0.0.1/SiteName/Login.aspx. I am using default SQL Provider.

Can anyoone please help me? i was struck here from last two days.

System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.

Login failed for user 'XXXXXX\ASPNET'.

Regards,

Pradeep.

hi Pradeep,

please verify the default database for \ASPNET login is available on the target server...

regards

|||See the Security matrix form here:

http://msdn2.microsoft.com/en-us/library/aa302377.aspx

You either can create the ASPNET user on the server, create another one and specify it within the web.config file, or specify in the web.config file, that you want to use impersonation. (Depending on your needs)

HTH, Jens K. Suessmeyer.

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

Hi

Thank U verymuch for the reply. I have created the ASPNET User using Microsoft SQL Server Management Studio Express but the result is same.

How can i see the default database for ASPNET user....

Regards,

Pradeep.

|||

Hi

Thank U for the reply. I have created ASPNET user in the database using Microsoft SQL server Management Studio Express and in web config file i have added

<identity impersonate="true"/>

<authentication mode="Forms" />

but still the reult is same as

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MIS-2\ASPNET'.

Hope this might be bug in SQL Server in SQL Server 2005 Express edition.

Regards,

Pradeep

|||

Hi,

ok we are getting closer. The error is related to the fact that you want to redirect to a database where is not granted any access to. Automatic redirection of Users is done in either of the two ways. You have a connection string where no "Inital Catalog"
keyword is specified, then the user will be redirected to his default database which every user has. If you want to change that, you can use the GUI and set the default database to another one where he is granted access to. (You can also use the sp_defaultdb procedure if you prefer the non-Gui version). if you mentioned the "Initial Catalog" in the catalog you will have to make sure that the connecting user (in your case the
ASPNET user) has access to the database mentioned in as the keyword value.

HTH, Jens K. Suessmeyer.


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

Hi,

I am using the default sql provider model.

one more thing is i am having sql server 2000 in (mixed mode authentcation) and sql server 2005 express edition(in windows authentication), is there any problem related to this.

in sql server 2000 i have given the ASPNET user defult database as master and in sql server 2005 i did the same.

so, does these settings has any impact on the default provider model in ASP.NET 2.0?

Regards,

Pradeep

|||

Hi Pradeep,

The error generally comes when the user tried to connect Database for which he don't have access permission so you may use sp_grantdbaccess to grant db access permission and refer below KBs for more

http://support.microsoft.com/kb/321698/en-us

http://support.microsoft.com/kb/316989/en-us

http://support.microsoft.com/kb/824308/en-us

http://support.microsoft.com/kb/821498/en-us

http://support.microsoft.com/kb/308157/en-us

http://support.microsoft.com/kb/301240/en-us

Hemantgiri S. Goswami

|||

An answer provided by monishjain from ASP.net forum

Steps (Windows XP):

Go to Control Panel -> Administrative Tools -> Computer Management -> Local Users and Groups -> Users -> ASPNET

Right Click on ASPNET and select Properties

Go to Member Of tab.

Click on Add -> Advanced -> Find Now

Select SQLServer2005MSSQLUser$<machinename>$SQLExpress

Click on Ok -> Ok - >Apply

Close all the windows and reboot your machine. It should work now.

Cannot open user default database. Login failed

Hi,

I have installed SQL Server 2005 Express edition and when i try to run the web site as http://127.0.0.1/SiteName/Login.aspx. I am using default SQL Provider.

Can anyoone please help me? i was struck here from last two days.

System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.

Login failed for user 'XXXXXX\ASPNET'.

Regards,

Pradeep.

hi Pradeep,

please verify the default database for \ASPNET login is available on the target server...

regards

|||See the Security matrix form here:

http://msdn2.microsoft.com/en-us/library/aa302377.aspx

You either can create the ASPNET user on the server, create another one and specify it within the web.config file, or specify in the web.config file, that you want to use impersonation. (Depending on your needs)

HTH, Jens K. Suessmeyer.

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

Hi

Thank U verymuch for the reply. I have created the ASPNET User using Microsoft SQL Server Management Studio Express but the result is same.

How can i see the default database for ASPNET user....

Regards,

Pradeep.

|||

Hi

Thank U for the reply. I have created ASPNET user in the database using Microsoft SQL server Management Studio Express and in web config file i have added

<identity impersonate="true"/>

<authentication mode="Forms" />

but still the reult is same as

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MIS-2\ASPNET'.

Hope this might be bug in SQL Server in SQL Server 2005 Express edition.

Regards,

Pradeep

|||

Hi,

ok we are getting closer. The error is related to the fact that you want to redirect to a database where is not granted any access to. Automatic redirection of Users is done in either of the two ways. You have a connection string where no "Inital Catalog"
keyword is specified, then the user will be redirected to his default database which every user has. If you want to change that, you can use the GUI and set the default database to another one where he is granted access to. (You can also use the sp_defaultdb procedure if you prefer the non-Gui version). if you mentioned the "Initial Catalog" in the catalog you will have to make sure that the connecting user (in your case the
ASPNET user) has access to the database mentioned in as the keyword value.

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

|||

Hi,

I am using the default sql provider model.

one more thing is i am having sql server 2000 in (mixed mode authentcation) and sql server 2005 express edition(in windows authentication), is there any problem related to this.

in sql server 2000 i have given the ASPNET user defult database as master and in sql server 2005 i did the same.

so, does these settings has any impact on the default provider model in ASP.NET 2.0?

Regards,

Pradeep

|||

Hi Pradeep,

The error generally comes when the user tried to connect Database for which he don't have access permission so you may use sp_grantdbaccess to grant db access permission and refer below KBs for more

http://support.microsoft.com/kb/321698/en-us

http://support.microsoft.com/kb/316989/en-us

http://support.microsoft.com/kb/824308/en-us

http://support.microsoft.com/kb/821498/en-us

http://support.microsoft.com/kb/308157/en-us

http://support.microsoft.com/kb/301240/en-us

Hemantgiri S. Goswami

|||

An answer provided by monishjain from ASP.net forum

Steps (Windows XP):

Go to Control Panel -> Administrative Tools -> Computer Management -> Local Users and Groups -> Users -> ASPNET

Right Click on ASPNET and select Properties

Go to Member Of tab.

Click on Add -> Advanced -> Find Now

Select SQLServer2005MSSQLUser$<machinename>$SQLExpress

Click on Ok -> Ok - >Apply

Close all the windows and reboot your machine. It should work now.