Clearing LOG Files: installed

Showing posts with label installed. Show all posts

Thursday, March 29, 2012

cluster SSAS and SQL

Hi,
We have a default clusterd SQL server 2005 with sp2 installed in one cluster
group and then I have installed a default SSAS clustered instance in another
cluster group and it works fine (can failover and user can connect). However,
when I applying the sp2 to SSAS instance (with SSAS checked only) and it
failed; it not noly just failed but also take down my default clustered sql
server! We have to call MS to get our server up. It seems that, somehow,
registry for default sql server got messed up by SSAS sp2. My question are:
1.Is it possible or supported to install a default SQL server and a default
Analysis server on a cluster (each one in its own cluster group) with sp2;
2.why applying sp2 on a default AD instance in one cluster group affect a
default sql instance in another cluster group.
thanks much in advance.
Zack.
The answer is that SQL services share some common components. Plus, the
installer has some generic setup logic. Finally, are you using the same
service account for both services? If so, then permissions can get hosed
during a broken update.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"dp" <dp@.discussions.microsoft.com> wrote in message
news:90BAC728-916F-4497-B293-55920962EDE8@.microsoft.com...
> Hi,
> We have a default clusterd SQL server 2005 with sp2 installed in one
> cluster
> group and then I have installed a default SSAS clustered instance in
> another
> cluster group and it works fine (can failover and user can connect).
> However,
> when I applying the sp2 to SSAS instance (with SSAS checked only) and it
> failed; it not noly just failed but also take down my default clustered
> sql
> server! We have to call MS to get our server up. It seems that, somehow,
> registry for default sql server got messed up by SSAS sp2. My question
> are:
> 1. Is it possible or supported to install a default SQL server and a
> default
> Analysis server on a cluster (each one in its own cluster group) with sp2;
> 2. why applying sp2 on a default AD instance in one cluster group affect a
> default sql instance in another cluster group.
> thanks much in advance.
> Zack.
>
|||Zack, were you ever able to upgrade your SSAS in the cluster?
We are having the same or similar issues. We upgraded our cluster from SP1
to SP2. The SQL Server components upgraded to SP2, but the SSAS failed and
is still at SP1. After the upgrade one of our clustered instances did not
come back online. Error logs read something like, "...Cluster IP/Network
resource already in use..."
Well, I called MS because our production SQL 2005 cluster was hosed. The
issue, reg key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
Server\MSSQL.1\Cluster\ClusterName" had the incorrect instance name for the
MSSQL.1 instance (in our case). We had to run some cluster commands to
remove the MSCS checkpoint, changed the key value to the correct instance
name, then reapply MSCS checkpoint.
This got our SQL Server instance back online. But we still can't update
SSAS to SP2. Maybe the two issues are not related, but I have a gut feeling
they are. The incorrect 'ClusterName' value happened to be the instance name
for our SSAS.
I still have the MS support ticket open trying to determine if the cluster
registry keys are in the correct state on both nodes.
Anyone else having issues with failover cluster anaylsis server upgrade to
SP2?
"dp" wrote:

> Hi,
> We have a default clusterd SQL server 2005 with sp2 installed in one cluster
> group and then I have installed a default SSAS clustered instance in another
> cluster group and it works fine (can failover and user can connect). However,
> when I applying the sp2 to SSAS instance (with SSAS checked only) and it
> failed; it not noly just failed but also take down my default clustered sql
> server! We have to call MS to get our server up. It seems that, somehow,
> registry for default sql server got messed up by SSAS sp2. My question are:
> 1.Is it possible or supported to install a default SQL server and a default
> Analysis server on a cluster (each one in its own cluster group) with sp2;
> 2.why applying sp2 on a default AD instance in one cluster group affect a
> default sql instance in another cluster group.
> thanks much in advance.
> Zack.
>

Cluster SQL 2000 errorlog problem

Tuesday, March 27, 2012

Cluster SQL 2000 errorlog problem

We've recently installed a couple of Windows Server 2003 Ent Ed servers with
SQL 2000 Ent Ed and one of the active/active nodes continually gives the
error below in the Application Event log.
The NT user which was used to install the server and owns the directories
and files below has full rights so this should not be an issue.
I've checked MSDN, etc. but nothing which seems to help.
Thanks.
Ron
--
17050 :
initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot find
the path specified.).
--Ron,
Is drive D local to the server or on the cluster's shared drives? The error
message could be implying that the node in question was installed with the
data files on a local drive.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> We've recently installed a couple of Windows Server 2003 Ent Ed servers
with
> SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> error below in the Application Event log.
> The NT user which was used to install the server and owns the directories
> and files below has full rights so this should not be an issue.
> I've checked MSDN, etc. but nothing which seems to help.
> Thanks.
> Ron
> --
> 17050 :
> initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
find
> the path specified.).
> --|||BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
that contains a lot of detail not available elsewhere:
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd020703/wcdblurb020703.asp
Ron
--
Ron Talmage
SQL Server MVP
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Ron,
> Is drive D local to the server or on the cluster's shared drives? The
error
> message could be implying that the node in question was installed with the
> data files on a local drive.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> > We've recently installed a couple of Windows Server 2003 Ent Ed servers
> with
> > SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> > error below in the Application Event log.
> >
> > The NT user which was used to install the server and owns the
directories
> > and files below has full rights so this should not be an issue.
> >
> > I've checked MSDN, etc. but nothing which seems to help.
> > Thanks.
> > Ron
> >
> > --
> > 17050 :
> > initerrlog: Could not open error log file 'D:\Program Files\Microsoft
SQL
> > Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
> find
> > the path specified.).
> >
> > --
>|||Ron,
I'll review the webcast...thanks!
SQL Server is installed on the C: drive, the data files are installed on D:
which is a SAN drive share.
I've rebooted both nodes and only started node1...with node2 offline, there
errors are not appearing in the event logs...? Seems odd as it's node1 which
is logging the errors...any other ideas?
Thanks.
Ron
"Ron Talmage" wrote:
> BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
> that contains a lot of detail not available elsewhere:
> http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd020703/wcdblurb020703.asp
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
> news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> > Ron,
> >
> > Is drive D local to the server or on the cluster's shared drives? The
> error
> > message could be implying that the node in question was installed with the
> > data files on a local drive.
> >
> > Hope this helps,
> > Ron
> > --
> > Ron Talmage
> > SQL Server MVP
> >
> > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> > > We've recently installed a couple of Windows Server 2003 Ent Ed servers
> > with
> > > SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> > > error below in the Application Event log.
> > >
> > > The NT user which was used to install the server and owns the
> directories
> > > and files below has full rights so this should not be an issue.
> > >
> > > I've checked MSDN, etc. but nothing which seems to help.
> > > Thanks.
> > > Ron
> > >
> > > --
> > > 17050 :
> > > initerrlog: Could not open error log file 'D:\Program Files\Microsoft
> SQL
> > > Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
> > find
> > > the path specified.).
> > >
> > > --
> >
> >
>
>sql sql

Cluster server connection

Good day,
I have recently installed a 2 node cluster server with SQL 2000 SP3 in my
network. and have found out that users connect to the Virtual cluster server
inorder to receive SQL services but they get the replay for the physical
node that holds the SQL.
I was wondering if this configuration can be changed so that the SQL servers
answers back with the IP address of the virtual server and not the physical
cluster.
the problem is that im working with a Firewall and we would like to restrict
the number of IP address that we expose to the world.
Thanks in advance
Oren Zippori
This is one of the wierd but unavoidable artifacts of clustering. You will
have to expose the host computer's IP addresses through the firewall.
Personally, I like to run my database servers on an restricted segment, just
to minimize the impact of stuff like this.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Oren Zippori" <orenzp@.hotmail.com> wrote in message
news:eu17pHbwFHA.3548@.tk2msftngp13.phx.gbl...
> Good day,
> I have recently installed a 2 node cluster server with SQL 2000 SP3 in my
> network. and have found out that users connect to the Virtual cluster
> server inorder to receive SQL services but they get the replay for the
> physical node that holds the SQL.
> I was wondering if this configuration can be changed so that the SQL
> servers answers back with the IP address of the virtual server and not the
> physical cluster.
> the problem is that im working with a Firewall and we would like to
> restrict the number of IP address that we expose to the world.
> Thanks in advance
> Oren Zippori
>
|||Thanks for the information on this Geoff.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uNRVXAgwFHA.664@.tk2msftngp13.phx.gbl...
> This is one of the wierd but unavoidable artifacts of clustering. You
> will have to expose the host computer's IP addresses through the firewall.
> Personally, I like to run my database servers on an restricted segment,
> just to minimize the impact of stuff like this.
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Oren Zippori" <orenzp@.hotmail.com> wrote in message
> news:eu17pHbwFHA.3548@.tk2msftngp13.phx.gbl...
>

Sunday, March 25, 2012

cluster installing

I have installed mscs correctly according the checklist.
But i cannot install sql en server on the cluster.
The attached is the log.
win2k ad sp4/sql en
Thanks
Sanjoy
begin 666 sqlstp.log
M,38Z-3 Z-#0@.0F5G:6X@.4V5T=7 -"C$V.C4P.C0T(#@.N,# N,3DT#0HQ-CHU
M,#HT-"!-;V1E(#T@.3F]R;6%L#0HQ-CHU,#HT-"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,38Z-3 Z-#4@.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'@.P#0HQ-CHU,#HT-2!686QU94944R!R971U<FYE9#H@.,0T*,38Z
M-3 Z-#4@.5F%L=650240@.<F5T=7)N960Z(#$-"C$V.C4P.C0U(%9A;'5E3&EC
M(')E='5R;F5D.B Q#0HQ-CHU,#HT-2!3>7-T96TZ(%=I;F1O=W,@.3E0@.16YT
M97)P<FES92!397)V97(-"C$V.C4P.C0U(%-13"!397)V97(@.4')O9'5C=%1Y
M<&4Z($5N=&5R<')I<V4@.161I=&EO;B!;,'@.S70T*,38Z-3 Z-#4@.27-.5$-L
M=7-T97(@.<F5T=7)N960Z(#$-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.4V5T
M=7!);FET:6%L:7IE( T*,38Z-3 Z-#4@.16YD($%C=&EO;B!3971U<$EN:71I
M86QI>F4-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.(%-E='5P26YS=&%L; T*
M,38Z-3 Z-#4@.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$V.C4P.C0U($-O
M;6UO;D9I;&5S1&ER/4,Z7%!R;V=R86T@.1FEL97-<0V]M;6]N($9I;&5S#0HQ
M-CHU,#HT-2!7:6YD;W=S($1I<F5C=&]R>3U#.EQ724Y.5%P-"C$V.C4P.C0U
M(%!R;V=R86T@.1FEL97,]0SI<4')O9W)A;2!&:6QE<UP-"C$V.C4P.C0U(%1%
M35!$25(]0SI<5TE.3E1<5$5-4%P-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.
M(%-E='5P26YS=&%L; T*,38Z-3 Z-#4@.9&EG<&ED('-I>F4@..B R-38-"C$V
M.C4P.C0U(&1I9W!I9"!S:7IE(#H@.,38T#0HQ-CHU,#HT-2!"96=I;B!!8W1I
M;VXZ("!#:&5C:T9I>&5D4F5Q=6ER96UE;G1S#0HQ-CHU,#HT-2!0;&%T9F]R
M;2!)1#H@.,'AF,# P,# -"C$V.C4P.C0U(%9E<G-I;VXZ(#4N,"XR,3DU#0HQ
M-CHU,#HT-2!&:6QE(%9E<G-I;VX@.+2!#.EQ724Y.5%QS>7-T96TS,EQS:&1O
M8W9W+F1L;#H@.-2XP+C,W,# N-C8V. T*,38Z-3 Z-#4@.16YD($%C=&EO;CH@.
M($-H96-K1FEX961297%U:7)E;65N=',-"C$V.C4P.C0U($)E9VEN($%C=&EO
M;CH@.(%-H;W=$:6%L;V=S#0HQ-CHU,#HT-2!);FET:6%L($1I86QO9R!-87-K
M.B P>#$X,S P,&8W+"!$:7-A8FQE($)A8VL],'@.Q#0HQ-CHU,#HT-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$-"C$V.C4P.C0U($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39%=E;&-O;64-"C$V.C4P.C0V($5N9"!!
M8W1I;VX@.($1I86QO9U-H;W=39%=E;&-O;64-"C$V.C4P.C0V($1I86QO9R P
M>#$@.<F5T=7)N960Z(#$-"C$V.C4P.C0V($5N9"!!8W1I;VX@.4VAO=T1I86QO
M9W-(;'!R#0HQ-CHU,#HT-B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE
M9#H@.;D-U<G)E;G0],'@.R+&EN9&5X/3$-"C$V.C4P.C0V($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,@.T*,38Z-3 Z-#8@.0F5G:6X@.06-T:6]N
M.B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$V.C4P.C4S(%-H;W=$;&=-
M86-H:6YE(')E='5R;F5D.B Q#0HQ-CHU,#HU,R!.86UE(#T@.4TY,+"!4>7!E
M(#T@.,'@.Q,# P,# P. T*,38Z-3 Z-3,@.0F5G:6X@.06-T:6]N.B @.0VAE8VM2
M97%U:7)E;65N=',-"C$V.C4P.C4S(%!R;V-E<W-O<B!!<F-H:71E8W1U<F4Z
M('@.X-B H4&5N=&EU;2D-"C$V.C4P.C4S(%-E<G9I8V4@.4&%C:SH@.(#$P,C0-
M"C$V.C4P.C4S($-O;7!U=&5R3F%M93H@.00T*,38Z-3 Z-3,@.57-E<B!.86UE
M.B!A9&UI;FES=')A=&]R#0HQ-CHU,#HU,R!)<T%L;$%C8V5S<T%L;&]W960@.
M<F5T=7)N960Z(#$-"C$V.C4P.C4S($]3($QA;F=U86=E.B P>#@.P- T*,38Z
M-3 Z-3,@.16YD($%C=&EO;B!#:&5C:U)E<75I<F5M96YT<PT*,38Z-3 Z-3,@.
M5&AI<R!C;VUB:6YA=&EO;B!O9B!086-K86=E(&%N9"!/<&5R871I;F<@.4WES
M=&5M(&%L;&]W<R!A(&9U;&P@.<')O9'5C="!I;G-T86QL+@.T*,38Z-3 Z-3,@.
M16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$V.C4P.C4S
M(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3 Z-3,@.;D9U;&Q-
M87-K(#T@.,'@.Q.#,P,#!F-RP@.;D-U<G)E;G0@./2 P>#(L(&Y$:7)E8W1I;VX@.
M/2 P#0HQ-CHU,#HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F,V,P,S<L
M($1I<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3 Z-3,@.1&EA;&]G(#!X,B!R971U
M<FYE9#H@., T*,38Z-3 Z-3,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$V.C4P.C4S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#0L:6YD97@.],@.T*,38Z-3 Z-3,@.0F5G:6X@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<CH@.,'@.T#0HQ-CHU,#HU,R!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V1);G-T86QL36]D90T*,38Z-3 Z-3,@.26YS=&%L;$UO9&4@..B P
M>#$-"C$V.C4P.C4S($5N9"!!8W1I;VX@.($1I86QO9U-H;W=39$EN<W1A;&Q-
M;V1E#0HQ-CHU,#HU,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V
M.C4P.C4S(&Y&=6QL36%S:R ](#!X8F8S8S S-RP@.;D-U<G)E;G0@./2 P>#0L
M(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,#HU,R!5<&1A=&5D($1I86QO9R!-87-K
M.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4P.C4S($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$V.C4P.C4S($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ-CHU,#HU,R!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ-CHU,#HU,R!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ-CHU,#HU,R!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,38Z-3 Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,38Z
M-3 Z-38@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,#HU-B!N
M1G5L;$UA<VL@./2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ-CHU,#HU-B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B
M9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4P.C4V($1I86QO9R P
M>#$P(')E='5R;F5D.B Q#0HQ-CHU,#HU-B!%;F0@.06-T:6]N(%-H;W=$:6%L
M;V=S2&QP<@.T*,38Z-3 Z-38@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N
M960Z(&Y#=7)R96YT/3!X,C L:6YD97@.]-0T*,38Z-3 Z-38@.0F5G:6X@.06-T
M:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.R, T*,38Z-3 Z-38@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D3&EC96YS90T*,38Z-3 Z-3<@.16YD($%C=&EO
M;B!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ-CHU,#HU-R!$:6%L;V<@.,'@.R,"!R
M971U<FYE9#H@.,0T*,38Z-3 Z-3<@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL
M<'(-"C$V.C4P.C4W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N
M0W5R<F5N=#TP>#0P,# L:6YD97@.],30-"C$V.C4P.C4W($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P, T*,38Z-3 Z-3<@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D5FER='5A;%-E<G9E<@.T*,38Z-3$Z,C<@.4VAO
M=T1L9U9I<G1U86Q397)V97(@.<F5T=7)N960Z(# -"C$V.C4Q.C(W($EP861D
M<F5S<R ](#$Y,BXQ-C@.N,"XV+#(U-2XR-34N,C4U+C L<'5B;&EC#0HQ-CHU
M,3HR-R!S>DYE=TQI<W0@./2 Q.3(N,38X+C N-BPR-34N,C4U+C(U-2XP+'!U
M8FQI8PT*,38Z-3$Z,C<@.<WI-;V1I9FEE9$QI<W0@./2 -"C$V.C4Q.C(W('-Z
M4F5M;W9E9$QI<W0@./2 -"C$V.C4Q.C(W($5N9"!!8W1I;VX@.($1I86QO9U-H
M;W=39%9I<G1U86Q397)V97(-"C$V.C4Q.C(W(&)E9VEN(%-H;W=$:6%L;V=S
M57!D871E36%S:PT*,38Z-3$Z,C<@.;D9U;&Q-87-K(#T@.,'@.Q8F8W8S S-RP@.
M;D-U<G)E;G0@./2 P>#0P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,3HR-R!5
M<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@.
M/2 P>#$-"C$V.C4Q.C(W($1I86QO9R P>#0P,# @.<F5T=7)N960Z(#$-"C$V
M.C4Q.C(W($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ-CHU,3HR-R!3
M:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.X,# P
M+&EN9&5X/3$U#0HQ-CHU,3HR-R!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(
M;'!R.B P>#@.P,# -"C$V.C4Q.C(W($)E9VEN($%C=&EO;B Z("!$:6%L;V=3
M:&]W4V1$:7-K1W)O=7!S#0HQ-CHU,3HU,"!3:&]W1&QG1&ES:T=R;W5P<R!R
M971U<FYE9#H@.,0T*,38Z-3$Z-3 @.1&ES:R!'<F]U<" ]($1I<VL@.1W)O=7 @.
M,0T*,38Z-3$Z-3 @.16YD($%C=&EO;B Z("!$:6%L;V=3:&]W4V1$:7-K1W)O
M=7!S#0HQ-CHU,3HU,"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V
M.C4Q.C4P(&Y&=6QL36%S:R ](#!X,6)F-V,P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3$Z-3 @.57!D871E9"!$:6%L;V<@.
M36%S:SH@.,'@.Q8F8W8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,3HU
M,"!$:6%L;V<@.,'@.X,# P(')E='5R;F5D.B Q#0HQ-CHU,3HU,"!%;F0@.06-T
M:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3$Z-3 @.4VAO=T1I86QO9W-'971$
M:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# L:6YD97@.],38-"C$V
M.C4Q.C4P($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# -
M"C$V.C4Q.C4P($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L=7-T97)$
M968-"C$V.C4Q.C4V(%-H;W=$;&=#;'5S=&5R1&5F(')E='5R;F5D.B Q#0HQ
M-CHU,3HU-B!0<F5F3W=N97)S(#T@.02Q"+"!.=6U)<" ](#(-"C$V.C4Q.C4V
M($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C$V.C4Q.C4V
M($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C$V.C4Q.C4V
M($5N9"!!8W1I;VX@..B!686QI9&%T94YO9&5!8W1I;VYS#0HQ-CHU,3HU-B!%
M;F0@.06-T:6]N(#H@.5F%L:61A=&5.;V1E06-T:6]N<PT*,38Z-3$Z-38@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQU<W1E<D1E9@.T*,38Z-3$Z-38@.8F5G
M:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,3HU-B!N1G5L;$UA<VL@.
M/2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 P,# L(&Y$:7)E8W1I;VX@.
M/2 Q#0HQ-CHU,3HU-B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W
M+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4Q.C4V($1I86QO9R P>#$P,# P
M(')E='5R;F5D.B Q#0HQ-CHU,3HU-B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,38Z-3$Z-38@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X,C P,# L:6YD97@.],3<-"C$V.C4Q.C4V($)E9VEN($%C
M=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# -"C$V.C4Q.C4V($)E9VEN
M($%C=&EO;B Z($-L=7-T97(@.4V5C=7)I='D@.+2!$;&=!8V-T#0HQ-CHU,CHQ
M,B!3:&]W1&QG06-C="!R971U<FYE9#H@.,0T*,38Z-3(Z,3(@.6T1L9T%C8V]U
M;G1=#0HQ-CHU,CHQ,B!$;VUA:6X@./2!324Y/3$E.15,-"C$V.C4R.C$R($1O
M;6%I;D%C8W0@./2!!9&UI;FES=')A=&]R#0HQ-CHU,CHQ,B!$;VUA:6Y0=V0-
M"C$V.C4R.C$R(%)E<W5L=" ](#$-"C$V.C4R.C$R($5N9"!!8W1I;VX@..B!#
M;'5S=&5R(%-E8W5R:71Y("T@.1&QG06-C= T*,38Z-3(Z,3(@.8F5G:6X@.4VAO
M=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,CHQ,B!N1G5L;$UA<VL@./2 P>#%B
M9C=C,#,W+"!N0W5R<F5N=" ](#!X,C P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M-CHU,CHQ,B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A
M8FQE($)A8VL@./2 P>#$-"C$V.C4R.C$R($1I86QO9R P>#(P,# P(')E='5R
M;F5D.B Q#0HQ-CHU,CHQ,B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*
M,38Z-3(Z,3(@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R
M96YT/3!X-# P,# L:6YD97@.],3@.-"C$V.C4R.C$R($)E9VEN($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$V.C4R.C$R($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,38Z-3(Z,3(@.1&ES<&QA>5-Y<W1E
M;5!R95)E<0T*,38Z-3(Z,3(@.4VAO=T1L9T-L:65N=%-E<G9E<E-E;&5C="!R
M971U<FYE9#H@.,0T*,38Z-3(Z,3(@.5'EP92 Z(#!X,@.T*,38Z-3(Z,3(@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R#0HQ-CHU,CHQ,B!B96=I;B!3
M:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V.C4R.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$V.C4R.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*,38Z-3(Z,3(@.1&EA;&]G(#!X-# P,# @.<F5T
M=7)N960Z(#$-"C$V.C4R.C$R($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ-CHU,CHQ,B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.X,# P,"QI;F1E>#TQ.0T*,38Z-3(Z,3(@.0F5G:6X@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X,# P, T*,38Z-3(Z,3(@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D26YS=&%N8V5.86UE#0HQ-CHU,CHQ,B!"96=I
M;B!!8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C$V.C4R.C(R($5N9"!!
M8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C$V.C4R.C(R(%-H;W=$;&=)
M;G-T86YC94YA;64@.<F5T=7)N960@..B Q#0HQ-CHU,CHR,B!);G-T86YC94YA
M;64@..B!-4U-13%-%4E9%4@.T*,38Z-3(Z,C0@.0W)E871E4V5T=7!4;W!O;&]G
M>2A33DPI+"!(86YD;&4@..B P>#$Y-S0V93@.L(')E='5R;F5D(#H@., T*,38Z
M-3(Z,C0@.0W)E871E4V5T=7!4;W!O;&]G>2!R971U<FYE9" Z(# L($AA;F1L
M92 Z(#!X,3DW-#9E. T*,38Z-3(Z,C0@.5&]P;VQO9WD@.5'EP92 Z(#,T+"!2
M971U<FX@.5F%L=64@..B P#0HQ-CHU,CHR-"!35%]'9710:'ES:6-A;$YO9&4@.
M<F5T=7)N960@..B P+"!03DAA;F1L92 Z(#!X,3DW-#<Q, T*,38Z-3(Z,C0@.
M4$Y?16YU;65R871E17@.@.<F5T=7)N960@..B P#0HQ-CHU,CHR-"!03E]'9713
M44Q3=&%T97,@.<F5T=7)N960@..B P+"!3<6Q3=&%T97,@..B P># -"C$V.C4R
M.C(T(%!.7U-T87)T4V-A;B!;,'@.Q.3<T-S$P72!R971U<FYE9" Z(# -"C$V
M.C4R.C(T(%!.7T=E=$YE>'0@.6S!X,3DW-#<Q,%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,38Z-3(Z,C0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$V.C4R.C(T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ-CHU
M,CHR-"!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$V
M.C4R.C(T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3(Z,C0@.
M;D9U;&Q-87-K(#T@.,'@.Q8F9F8S S-RP@.;D-U<G)E;G0@./2 P>#@.P,# P+"!N
M1&ER96-T:6]N(#T@.,0T*,38Z-3(Z,C0@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F9F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,CHR-"!$:6%L
M;V<@.,'@.X,# P,"!R971U<FYE9#H@.,0T*,38Z-3(Z,C0@.16YD($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(-"C$V.C4R.C(T(%-H;W=$:6%L;V=S1V5T1&EA;&]G
M(')E='5R;F5D.B!N0W5R<F5N=#TP>#$P,# P,"QI;F1E>#TR, T*,38Z-3(Z
M,C4@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q,# P,# -"C$V
M.C4R.C(U($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39%-E='5P5'EP90T*
M,38Z-3(Z,C4@.0F5G:6X@.06-T:6]N.B!3971U<"!4>7!E#0HQ-CHU,CHS,"!3
M44P@.<')O9W)A;2!F;VQD97(Z($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97(-"C$V.C4R.C,P(%-13"!D871A(&9O;&1E<CH@.6CI<4')O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,38Z-3(Z,S @.5VEN
M9&]W<R!S>7-T96T@.9F]L9&5R.B!#.EQ724Y.5%QS>7-T96TS,EP-"C$V.C4R
M.C,P(%!R;V<@.<F5Q.B S.#(P-2P@.1&%T82!R97$Z(#,V-30T+"!3>7,@.<F5Q
M.B Q.3,U-SD-"C$V.C4R.C,P(%!R;V<@.879A:6PZ(#$W.#,W.3,R+"!$87 1A
M(&%V86EL.B Q-#(Q.#4Q.38L(%-Y<R!A=F%I;#H@.,3<X,S<Y,S(-"C$V.C4R
M.C,P(%!R;V<@.<F5Q('9S+B!A=F%I;"P@.,C,Q-S@.T+" Q-S@.S-SDS,@.T*,38Z
M-3(Z,S @.1&%T82!R97$@.=G,N(&%V86EL+" S-C4T-"P@.,30R,3@.U,3DV#0HQ
M-CHU,CHS,"!3>7,@.<F5Q('9S+B!A=F%I;"P@.,3DS-3<Y+" Q-S@.S-SDS,@.T*
M,38Z-3(Z,S @.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,38Z-3(Z,S @.6U-E='5P
M5'EP95-13%T-"C$V.C4R.C,P('-Z1&ER(#T@.0SI<4')O9W)A;2!&:6QE<UQ-
M:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,38Z-3(Z,S @.<WI$:7(@./2!#.EQ0<F]G
M<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ-CHU,CHS,"!297-U
M;'0@./2 S,#$-"C$V.C4R.C,P('-Z1&%T841I<B ](%HZ7%!R;V=R86T@.1FEL
M97-<36EC<F]S;V9T(%-13"!397)V97(-"C$V.C4R.C,P('-Z1&%T841I<B ]
M(%HZ7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$V.C4R
M.C,P($5N9"!!8W1I;VXZ(%-E='5P(%1Y<&4-"C$V.C4R.C,P(%-E='5P(%1Y
M<&4Z(%1Y<&EC86P@.*#,P,2D-"C$V.C4R.C,P($5N9"!!8W1I;VX@.($1I86QO
M9U-H;W=39%-E='5P5'EP90T*,38Z-3(Z,S @.8F5G:6X@.4VAO=T1I86QO9W-5
M<&1A=&5-87-K#0HQ-CHU,CHS,"!N1G5L;$UA<VL@./2 P>#%B9F9C,#,W+"!N
M0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER96-T:6]N(#T@.,S Q#0HQ-CHU,CHS
M,"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A8FQE($)A
M8VL@./2 P>#$-"C$V.C4R.C,P($1I86QO9R P>#$P,# P,"!R971U<FYE9#H@.
M,S Q#0HQ-CHU,CHS,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z
M-3(Z,S @.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT
M/3!X-# P,# P+&EN9&5X/3(R#0HQ-CHU,CHS,"!"96=I;B!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R.B P>#0P,# P, T*,38Z-3(Z,S @.0F5G:6X@.06-T:6]N
M.B @.1&QG4V5R=FEC97,-"C$V.C4R.C0T(%-H;W=$;&=397)V:6-E<R!R971U
M<FYE9#H@.,0T*,38Z-3(Z-#0@.6T1L9U-E<G9I8V5S70T*,38Z-3(Z-#0@.3&]C
M86PM1&]M86EN"3T@.-C$V.# -"C$V.C4R.C0T($%U=&]3=&%R= D)/2 P#0HQ
M-CHU,CHT-"!344Q$;VUA:6X)"3T@.4TE.3TQ)3D53#0HQ-CHU,CHT-"!344Q$
M;VUA:6Y!8V-T"3T@.061M:6YI<W1R871O<@.T*,38Z-3(Z-#0@.4U%,1&]M86EN
M4'=D#0HQ-CHU,CHT-"!!9W1$;VUA:6X)"3T@.4TE.3TQ)3D53#0HQ-CHU,CHT
M-"!!9W1$;VUA:6Y!8V-T"3T@.061M:6YI<W1R871O<@.T*,38Z-3(Z-#0@.06=T
M1&]M86EN4'=D#0HQ-CHU,CHT-"!297-U;'0)/2 Q#0HQ-CHU,CHT-"!%;F0@.
M06-T:6]N($1L9U-E<G9I8V5S#0HQ-CHU,CHT-"!B96=I;B!3:&]W1&EA;&]G
M<U5P9&%T94UA<VL-"C$V.C4R.C0T(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L
M(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,CHT
M-"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A8FQE($)A
M8VL@./2 P>#$-"C$V.C4R.C0T($1I86QO9R P>#0P,# P,"!R971U<FYE9#H@.
M,0T*,38Z-3(Z-#0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$V.C4R
M.C0U(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP
M>#@.P,# P,"QI;F1E>#TR,PT*,38Z-3(Z-#4@.0F5G:6X@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<CH@.,'@.X,# P,# -"C$V.C4R.C0U($)E9VEN($%C=&EO;CH@.
M($1L9U-13%-E8W5R:71Y#0HQ-CHU,SHP-B!3:&]W1&QG4U%,4V5C=7)I='D@.
M<F5T=7)N960Z(#$-"C$V.C4S.C V($QO9VEN36]D92 ](#(L<WI0=V0-"C$V
M.C4S.C V($5N9"!!8W1I;VX@.1&QG4U%,4V5C=7)I='D-"C$V.C4S.C V(&)E
M9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3,Z,#8@.;D9U;&Q-87-K
M(#T@.,'@.Q8F1F8S S-RP@.;D-U<G)E;G0@./2 P>#@.P,# P,"P@.;D1I<F5C=&EO
M;B ](#$-"C$V.C4S.C V(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)D9F,P
M,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3,Z,#8@.1&EA;&]G(#!X.# P
M,# P(')E='5R;F5D.B Q#0HQ-CHU,SHP-B!%;F0@.06-T:6]N(%-H;W=$:6%L
M;V=S2&QP<@.T*,38Z-3,Z,#8@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N
M960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR- T*,38Z-3,Z,#8@.0F5G
M:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q,# P,# P#0HQ-CHU,SHP
M-B!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-"C$V.C4S.C X(%-H;W=$
M;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$V.C4S.C X(&-O;&QA=&EO;E]N
M86UE(#T@.0VAI;F5S95]04D-?0TE?05,L;&]C86QE7VYA;64@./2!#:&EN97-E
M7U!20RQL8VED(#T@.,'@.X,#0L4V]R=$ED(#T@.,"QD=T-O;7!&;&%G<R ](#!X
M,S P,#$-"C$V.C4S.C X($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ-CHU
M,SHP."!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V.C4S.C X(&Y&
M=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#=7)R96YT(#T@.,'@.Q,# P,# P+"!N
M1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,#@.@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,SHP."!$:6%L
M;V<@.,'@.Q,# P,# P(')E='5R;F5D.B Q#0HQ-CHU,SHP."!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z,#@.@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,C P,# P,"QI;F1E>#TR-0T*,38Z
M-3,Z,#@.@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.R,# P,# P
M#0HQ-CHU,SHP."!"96=I;B!!8W1I;VXZ("!$;&=.971W;W)K#0HQ-CHU,SHP
M."!3:&]W1&QG3F5T=V]R:R!R971U<FYE9#H@.,0T*,38Z-3,Z,#@.@.6T1L9U-E
M<G9E<DYE='=O<FM=#0HQ-CHU,SHP."!.971W;W)K3&EB<R ](#(U-0T*,38Z
M-3,Z,#@.@.5$-04&]R=" ](#$T,S,-"C$V.C4S.C X(%1#4%!R>'D@./2!$969A
M=6QT#0HQ-CHU,SHP."!.35!0:7!E3F%M92 ](%Q<+EQP:7!E7'-Q;%QQ=65R
M>0T*,38Z-3,Z,#@.@.4F5S=6QT(#T@.,0T*,38Z-3,Z,#@.@.16YD($%C=&EO;B!$
M;&=.971W;W)K#0HQ-CHU,SHP."!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA
M<VL-"C$V.C4S.C X(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#=7)R96YT
M(#T@.,'@.R,# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,#@.@.57!D871E
M9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q
M#0HQ-CHU,SHP."!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ-CHU
M,SHP."!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z,#@.@.4VAO
M=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P
M,"QI;F1E>#TR-PT*,38Z-3,Z,#@.@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<CH@.,'@.X,# P,# P#0HQ-CHU,SHP."!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V13=&%R=$-O<'D-"C$V.C4S.C(P($5N9"!!8W1I;VX@.1&EA;&]G
M4VAO=U-D4W1A<G1#;W!Y#0HQ-CHU,SHR,"!B96=I;B!3:&]W1&EA;&]G<U5P
M9&%T94UA<VL-"C$V.C4S.C(P(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#
M=7)R96YT(#T@.,'@.X,# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,C @.
M57!D871E9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K
M(#T@.,'@.Q#0HQ-CHU,SHR,"!$:6%L;V<@.,'@.X,# P,# P(')E='5R;F5D.B Q
M#0HQ-CHU,SHR,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z
M,C @.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X
M,3 P,# P,# L:6YD97@.],C@.-"C$V.C4S.C(P($)E9VEN($%C=&EO;B!3:&]W
M1&EA;&]G<TAL<'(Z(#!X,3 P,# P,# -"C$V.C4S.C(P($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$QI8V5N<V5-;V1E#0HQ-CHU,SHU-2!3:&]W1&QG
M3&EC96YS92!R971U<FYE9#H@.,0T*,38Z-3,Z-34@.4VAO=T1L9TQI8V5N<V4@.
M<F5T=7)N960Z($QI8V5N<V5-;V1E(#T@.,BP@.3&EC96YS94QI;6ET(#T@.- T*
M,38Z-3,Z-34@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1,:6-E;G-E36]D90T*
M,38Z-3,Z-34@.1&EA;&]G(#!X,3 P,# P,# @.<F5T=7)N960Z(#$-"C$V.C4S
M.C4U($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ-CHU,SHU-2!3:&]W
M1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.P+&EN9&5X
M/3 -"C$V.C4S.C4U($5N9"!!8W1I;VX@.4VAO=T1I86QO9W,-"C$V.C4S.C4U
M(+"RU["SS-#RU?W4VK"RU[ @.36EC<F]S;V9T(+?6LKS*O<K"SO&TIL#MT*VU
M]\;W("A-4T140RD@.+BXN#0HQ-CHU,SHU-2 @.0SI<5TE.3E1<5$5-4%Q3<6Q3
M971U<%Q":6Y<8VQD=&-S=' N97AE("U3=7!P;W)T1&ER(")#.EQ724Y.5%Q4
M14U07%-Q;%-E='5P7$)I;B(@.+4140U!K9R B1#I<>#@.V7$]T:&5R7&1T8W-E
M='5P+F5X92(@.+4QO9T9I;&4@.(D,Z7%=)3DY47'-Q;'-T<"YL;V<B("U#='A!
M8V-T(")324Y/3$E.15-<061M:6YI<W1R871O<B(@.+4-T>$50=V0-"C$V.C4S
M.C4V(%!R;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ-CHU,SHU-B!"96=I;B!!
M8W1I;VX@..B!#;'5S=&5R4V5T=7!(96QP97(-"C$V.C4S.C4V($)E9VEN($%C
M=&EO;B Z($-R96%T94-L=7-T25-31FEL97,-"C$V.C4S.C4V($5N9"!!8W1I
M;VX@..B!#<F5A=&5#;'5S=$E34T9I;&5S#0HQ-CHU,SHU-B!"96=I;B!!8W1I
M;VX@..B!#;'5S=&5R5W)I=&5296U);FD-"C$V.C4S.C4V($5N9"!!8W1I;VX@.
M.B!#;'5S=&5R5W)I=&5296U);FD-"C$V.C4S.C4V($)E9VEN($%C=&EO;B Z
M(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO9&5S#0I;87)G<UT-"DYU;5)E;6]T
M95-E<G9E<G,],PT*4V5R=F5R+C,]0@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E
M4V5R=FEC97,],0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE
M>&4-"C$N<V-R:7!T/5Q<05QA9&UI;B1<7TU34U%,4T525D52+FES<PT*,2YC
M;61L:6YE9F]R;6%T/25S(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68Q
M("5S("UO(")S<6QS=' N97AE(B -"C$N=7-E<CU324Y/3$E.15-<061M:6YI
M<W1R871O<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S96%B,V(Q83DU83<U-6$T
M,F-D#0HQ+FYA;64]4U%,4V5T=7 Q#0HQ+G-Q;'-E='5P/5D-"C$N8V]P>65X
M93UC;G9S=F,Q+F5X90T*6U-E<G9E<BXR70T*3G5M4F5M;W1E4V5R=FEC97,]
M,0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE>&4-"C$N<V-R
M:7!T/5Q<05QA9&UI;B1<7TU34U%,4T525D52+FES<PT*,2YC;61L:6Y E9F]R
M;6%T/25S(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68@.(EQ<05Q$)%QX
M.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.)7,@.+68R(")<7%QA9&UI;B1<<V5T
M=7 N;&]G(B M92 B<W1P<VEL;G0N7V5X(B @.+7@.@.(D,Z7"(-"C$N=7-E<CU3
M24Y/3$E.15-<061M:6YI<W1R871O<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S
M96%B,V(Q83DU83<U-6$T,F-D#0HQ+FYA;64]4U%,4V5T=7 R#0HQ+G-Q;'-E
M='5P/5D-"C$N8V]P>65X93UC;G9S=F,R+F5X90T*6U-E<G9E<BXS70T*3G5M
M4F5M;W1E4V5R=FEC97,],0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U
M<'-Q;"YE>&4-"C$N<V5R=F5R/4(-"C$N<V-R:7!T/5Q<05QA9&UI;B1<0E]-
M4U-13%-%4E9%4BYI<W,-"C$N8VUD;&EN969O<FUA=#TE<R!K/4-L4V5C(&L]
M4FT@.:SU#;" M4TU3("US("UF(")<7$%<1"1<>#@.V7'-E='5P7'-E='5P+FEN
M<R(@.+68Q("5S("UF,B B7%Q"7&%D;6EN)%QS971U<"YL;V<B("UE(")S='!S
M:6QN="Y?97@.B(" M>" B0SI<(@.T*,2YU<V5R/5-)3D],24Y%4UQ!9&UI;FES
M=')A=&]R#0HQ+G!A<W-W;W)D/3$S-V,U,F,V,3-E86(S8C%A.35A-S4U830R
M8V0-"C$N;F%M93U344Q3971U<#,-"C$N<W%L<V5T=7 ]60T*,2YC;W!Y97AE
M/6-N=G-V8S,N97AE#0HQ-CHU,SHU-R"PLM>PL\S0\M7]U-K(NKROO=JUX\G/
MUK30T-#HTJJUQ++9U_>AH]7BO\G$W-#HTJK*_;?6UM,N+BX-"C$V.C4S.C4W
M("!#.EQ724Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE>&4@.0SI<
M5TE.3E1<<F5M<V5T=7 N:6YI#0HQ-CHU.#HR,"!0<F]C97-S($5X:70@.0V]D
M93H@.*# I( T*,38Z-3@.Z,C @.0F5G:6X@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2
M971#;V1E#0HQ-CHU.#HR,"!);G-T86QL871I;VX@.<F5T=7)N('-T871U<R!O
M;B @..B M,0T*,38Z-3@.Z,C @.26YS=&%L;&%T:6]N(')E='5R;B!S=&%T=7,@.
M;VX@.(#H@.+3$-"C$V.C4X.C(P($EN<W1A;&QA=&EO;B!R971U<FX@.<W1A=' 5S
M(&]N($(@..B P#0HQ-CHU.#HR,"!%;F0@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2
M971#;V1E#2,C(R,@.4U%,(%-E<G9E<B#4MK/,L++7L+/,T/(@.H:H@.OZK*O,JQ
MO.0@.,#8O,#$O,#0@.,38Z-3,Z-3<@.(R,C(PT*#0K+^<SAN:FUQ,KDR.O6M<[>
MT*>CH0T*#0K+^=*JQ_.UQ++.ROT@.4V5R=F5R+C$@.U-J]VJ.H87)G<Z.IUM##
MN]/0U=*UO:.A#0H-"LOYS.&YJ;7$RN3(Z]:USM[0IZ.A#0H-"LOYTJK'\[7$
MLL[*_2!397)V97(N,B#4VKW:HZAA<F=SHZG6T,.[T]#5TK6]HZ$-"@.T*0U1H
M<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&5(;'!R(&-R96%T92!T:')E860L
M(&EN9&5X/3 -"D-4:')E860Z.E)U;B!T:')E860@.6S!X831=(&-R96%T960@.
M9F]R(&5X96-U=&EO;BX-"D-4:')E860Z.E!R;V-E<W,@.6S!X831=#0I#5&AR
M96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.<W1A<G0@.=&AR96%D( %LP
M>&$T72QI;F1E>#TP#0J]Q;&^SL2\_M+1L\FYIKBTUL:UO:&P7%Q"7$%$34E.
M)%Q"7TU34U%,4T525D52+FES<Z&QUM"AHPT*#0K5_=3:L++7L -2VL\RW_L[Q
MHZA"HZDN+BX-"@.T*U?W4VM3+T-"AL%Q<05Q$)%QX.#9<<V5T=7!<<V5T=7!S
M<6PN97AE(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68@.(EQ<05Q$)%QX
M.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.7%Q"7$%$34E.)%Q"7TU34U%,4T52
M5D52+FES<R M9C(@.(EQ<0EQA9&UI;B1<<V5T=7 N;&]G(B M92 B<W1P<VEL
M;G0N7V5X(B @.+7@.@.(D,Z7"*AL:.H0J.I+BXN#0H-"D-296UO=&50<F]C97-S
M.CI2=6Y5;G1I;$-O;7!L971E(%LP>&$T72!E>&ET(&-O9&4Z(# -"M2VL\R]
M^+/,S<NS]K3ZPNO.JJ&P,*&QHZA"HZFAHPT*#0I#5&AR96%D4&]O;#HZ4G5N
M56YT:6Q#;VUP;&5T94AL<'(@.5V%I=$9O<DUU;'1I<&QE3V)J9 6-T<R!R971U
M<FYE9#H@., T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&5(;'!R('-I
M9VYA;&5D('1H<F5A9"!;,'AA-%T-"E1H<F5A9"!;,'AA-%T@.97AI="!C;V1E
M.B!;,'@.P70T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&4@.<F5T=7)N
M960@., T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&4@.97AE8W5T:6]N
M(&QE=F5L/3$L(&YE960@.97AE8W5T:6]N.B P#0K5_=3:ML^_JM/KU+:SS+S&
MR^.[^J.H0J.IM<3!K+W3+BXN#0H-"M+1L\FYILF^L_VW_L[QH:,-"@.T*TM&S
MR;FFR;ZS_=2VL\S.Q+S^H:,-"@.T*(R,C(R!344P@.4V5R=F5R(-2VL\RPLM>P
ML\S0\B"AJB#-H]:YRK&\Y" P-B\P,2\P-" Q-CHU.#HR," C(R,C#0H-"@.``
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` `````````T*
M,38Z-3@.Z,C @.16YD($%C=&EO;B Z(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO
M9&5S#0HQ-CHU.#HR,"#4VLBZO*^UQ+S&R^.[^LG/U,O0T-2VL\RPLM>PL\S0
M\LJQHZRS]L_6TKNX]KORMN"X]K3MSO.AHPT*,38Z-3@.Z-#(@.L++7L+/,T/+4
MVLBZO*^]VK7CR<_6M-#0TJK'\[7$LMG7]\JGL-RAHPT*,38Z-3@.Z-#(@.0F5G
M:6X@.06-T:6]N(#H@.0VQU<W1E<D5R<F]R0VQE86YU< T*,38Z-3@.Z-#4@.0W)E
M871E4V5T=7!4;W!O;&]G>2A33DPI+"!(86YD;&4@..B P>#$Y-S0V93@.L(')E
M='5R;F5D(#H@., T*,38Z-3@.Z-#4@.0W)E871E4V5T=7!4;W!O;&]G>2!R971U
M<FYE9" Z(# L($AA;F1L92 Z(#!X,3DW-#9E. T*,38Z-3@.Z-#4@.5&]P;VQO
M9WD@.5'EP92 Z(#,T+"!2971U<FX@.5F%L=64@..B P#0HQ-CHU.#HT-2!35%]'
M9710:'ES:6-A;$YO9&4@.<F5T=7)N960@..B P+"!03DAA;F1L92 Z(#!X,3DW
M-#<Q, T*,38Z-3@.Z-#4@.4$Y?16YU;65R871E17@.@.<F5T=7)N960@..B P#0HQ
M-CHU.#HT-2!03E]'971344Q3=&%T97,@.<F5T=7)N960@..B P+"!3<6Q3=&%T
M97,@..B P># -"C$V.C4X.C0U(%!.7T=E=$EN<W1A;F-E(&9O<B!-4U-13%-%
M4E9%4B!;,'@.Q.3<T-S$P72!R971U<FYE9" Z(#$V,#D-"C$V.C4X.C0U(%)E
M;&5A<V53971U<%1O<&]L;V=Y#0I;87)G<UT-"DYU;5)E;6]T95-E<G9E<G,]
M,0T*4V5R=F5R+C$]0@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E4V5R=FEC97,]
M,0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE>&4-"C$N<V5R
M=F5R/4(-"C$N<V-R:7!T/2 -"C$N8VUD;&EN969O<FUA=#TE<R M=2 B0SI<
M5TE.3E1<25-53C X,#0N15A%(B M9B B7%Q"7$,D7%!R;V=R86T@.1FEL97-<
M36EC<F]S;V9T(%-13"!397)V97)<35-344Q<=6YI;G-T+FES=2(@.+4,@.(EQ<
M0EQ#)%Q0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R7$U34U%,
M7'-Q;'-U;BYD;&PB("UM(")-4U-13%-%4E9%4BY-248B("UI($U34U%,4T52
M5D52#0HQ+G5S97(]4TE.3TQ)3D537$%D;6EN:7-T<F%T;W(-"C$N<&%S<W=O
M<F0],3,W8S4R8S8Q,V5A8C-B,6$Y-6$W-35A-#)C9 T*,2YN86UE/5-13%5N
M:6YS=&%L;#$-"C$N<W%L<V5T=7 ]( T*,2YC;W!Y97AE/6-N=G-V8S$N97AE
M#0HQ-CHU.#HT-2"PLM>PL\S0\M7]U-K(NKROO=JUX\G/UK30T,?EL_VRV=?W
MHZRRHL?2TKNUJ<?EL_W-ZK/)OLV]J\W+L_8N+BX-"C$V.C4X.C0U("!#.EQ7
M24Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE>&4@.0SI<5TE.3E1<
M<F5M<V5T=7 N:6YI#0HQ-SHP-#HT,2!0<F]C97-S($5X:70@.0V]D93H@.*#,P
M,3 I(,?KQ_.UQ++9U_>SR;FFH:/6L;6]UMC0PL;TMJ_/M<VSQ["X_+C$O:NR
MN[OAR?K0IZ&C#0H-"C$W.C T.C0Q($)E9VEN($%C=&EO;B Z($=E=%)E;7-E
M='5P4F5T0V]D90T*,3<Z,#0Z-#$@.56YI;G-T86QL('-T871U<R!O;B!"("A-
M4U-13%-%4E9%4BY-248I(#H@.,S Q, T*,3<Z,#0Z-#$@.56YI;G-T86QL(&UE
M<W-A9V4@.;VX@.0B H35-344Q315)615(N34E&*2 Z(%5N:6YS=&%L;"!C;VUP
M;&5T960N("!3;VUE(&5L96UE;G1S(&-O=6QD(&YO="!B92!R96UO=F5D+B @.
M66]U('-H;W5L9"!M86YU86QL>2!R96UO=F4@.:71E;7,@.<F5L871E9"!T; R!T
M:&4@.87!P;&EC871I;VXN#0HQ-SHP-#HT,2!/;F4@.;W(@.;6]R92!N;V1E<R!O
M9B!T:&4@.8VQU<W1E<B!N965D('1O(&)E(')E8F]O=&5D#0HQ-SHP-#HT,2!%
M;F0@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2971#;V1E#2,C(R,@.4U%,(%-E<G9E
M<B#4MK/,L++7L+/,T/(@.H:H@.OZK*O,JQO.0@.,#8O,#$O,#0@.,38Z-3@.Z-#4@.
M(R,C(PT*#0I#5&AR96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.8W)E
M871E('1H<F5A9"P@.:6YD97@.], T*0U1H<F5A9#HZ4G5N('1H<F5A9"!;,'AA
M-%T@.8W)E871E9"!F;W(@.97AE8W5T:6]N+@.T*0U1H<F5A9#HZ4')O8V5S<R!;
M,'AA-%T-"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E2&QP<B!S=&%R
M="!T:')E860@.6S!X831=+&EN9&5X/3 -"M7]U-JPLM>PU+:SS+?^SO&CJ$*C
MJ2XN+@.T*#0K5_=3:U,O0T*&P7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE
M>&4@.+74@.(D,Z7%=)3DY47$E354XP.# T+D5812(@.+68@.(EQ<0EQ#)%Q0<F]G
M<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R7$U34U%,7'5N:6YS="YI
M<W4B("U#(")<7$)<0R1<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ-4U-13%QS<6QS=6XN9&QL(B M;2 B35-344Q315)615(N34E&(B M
M:2!-4U-13%-%4E9%4J&QHZA"HZDN+BX-"@.T*0U)E;6]T95!R;V-E<W,Z.E)U
M;E5N=&EL0V]M<&QE=&4@.6S!X831=(&5X:70@.8V]D93H@.,S Q, T*U+:SS+WX
ML\S-R[/VM/K"Z\ZJH; S,#$PH;&CJ$*CJ:&C#0H-"D-4:')E8610;V]L.CI2
M=6Y5;G1I;$-O;7!L971E2&QP<B!786ET1F]R375L=&EP;&5/8FIE8W1S(')E
M='5R;F5D.B P#0I#5&AR96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.
M<VEG;F%L960@.=&AR96%D(%LP>&$T70T*5&AR96%D(%LP>&$T7 2!E>&ET(&-O
M9&4Z(%LP>&)C,ET-"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E(')E
M='5R;F5D(#,P,3 -"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E(&5X
M96-U=&EO;B!L979E;#TQ+"!N965D(&5X96-U=&EO;CH@., T*U?W4VK;/OZK3
MZ]2VL\R\QLOCN_JCJ$*CJ;7$P:R]TRXN+@.T*#0K2T;/)N:;)OK/]M_[.\:&C
M#0H-"M+1L\FYILF^L_W4MK/,SL2\_J&C#0H-"B,C(R,@.4U%,(%-E<G9E<B#4
MMK/,L++7L+/,T/(@.H:H@.S:/6N<JQO.0@.,#8O,#$O,#0@.,3<Z,#0Z-#$@.(R,C
M(PT*#0H`````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````#0HQ-SHP-#HT,2!%;F0@.
M06-T:6]N(#H@.0VQU<W1E<D5R<F]R0VQE86YU< T*,3<Z,#0Z-#$@.16YD($%C
;=&EO;B Z($-L=7-T97)3971U<$AE;'!E<@.T*
`
end
Can't read some of the log, strangeness. Have you already installed MSDTC in
the cluster? http://support.microsoft.com/default...b;en-us;290624
Any messages that SQL Install gives you would also me nice.
Cheers,
Rod
"Sanjoy Wong" <sanjoy@.sinolines.com> wrote in message
news:OFnTjn7REHA.1036@.TK2MSFTNGP10.phx.gbl...
> I have installed mscs correctly according the checklist.
> But i cannot install sql en server on the cluster.
> The attached is the log.
>
> win2k ad sp4/sql en
> Thanks
> Sanjoy
>
>
|||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.

Tuesday, March 20, 2012

Cluster and Instances

I have been installed a cluster
SQLSERVER1
and
SQLSERVER2\SQL2
When SQL1 fail, SQL2 take the SQL instance and vice-versa
My Problem is that the SQLSERVER1 don't have a associated instance like SQL2
I want to configure my SQLSERVER1 to access through the instance name =
SQLSERVER1\SQL1
I need to reinstall the SQLSERVER1? or exists something to set the default
instance to a particular instance?
Thanks a lot
AA
You will need to reinstall SQL and create a new instance. If you have
enough disk devices you can create the new instance, detach the databases
from the default instance. Copy the files or reassign the device within
cluster manager to the new resource group and attach them to the new
instance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AA" <aa@.personal.net.py> wrote in message
news:uZ4ByXYeEHA.2812@.tk2msftngp13.phx.gbl...
> I have been installed a cluster
> SQLSERVER1
> and
> SQLSERVER2\SQL2
> When SQL1 fail, SQL2 take the SQL instance and vice-versa
> My Problem is that the SQLSERVER1 don't have a associated instance like
SQL2
> I want to configure my SQLSERVER1 to access through the instance name =
> SQLSERVER1\SQL1
> I need to reinstall the SQLSERVER1? or exists something to set the default
> instance to a particular instance?
> Thanks a lot
> AA
>
|||Thanks, So, I reinstall and create a new instance but. How can I "uninstall"
the previous instance?
Thanks again
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eFNF3eYeEHA.3684@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> You will need to reinstall SQL and create a new instance. If you have
> enough disk devices you can create the new instance, detach the databases
> from the default instance. Copy the files or reassign the device within
> cluster manager to the new resource group and attach them to the new
> instance.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "AA" <aa@.personal.net.py> wrote in message
> news:uZ4ByXYeEHA.2812@.tk2msftngp13.phx.gbl...
> SQL2
default
>
|||Look at 'Maintaining a Failover Cluster' topic in BOL.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AA" <aa@.personal.net.py> wrote in message
news:e9W56nYeEHA.3632@.TK2MSFTNGP11.phx.gbl...
> Thanks, So, I reinstall and create a new instance but. How can I
"uninstall"[vbcol=seagreen]
> the previous instance?
> Thanks again
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eFNF3eYeEHA.3684@.TK2MSFTNGP09.phx.gbl...
databases[vbcol=seagreen]
like[vbcol=seagreen]
=
> default
>
|||Thanks!
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uK2hs6YeEHA.1732@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Look at 'Maintaining a Failover Cluster' topic in BOL.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "AA" <aa@.personal.net.py> wrote in message
> news:e9W56nYeEHA.3632@.TK2MSFTNGP11.phx.gbl...
> "uninstall"
> databases
within[vbcol=seagreen]
> like
name
> =
>
sql sql

Sunday, March 11, 2012

CLR Trigger -> Send Insert/Update/Delete Message to Windows Service

Hi,

I have an c# windows service, which is running on the same machine where my mssql server is installed. This service must be informed for each insert/update/delete event on one specific table.

My idea was to create an CLR Trigger for this table which can communicate with this service via .NET remoting. But the problem is, that the system.runtime.remoting assembly is not integrated within the mssql clr enviroment => i can't use remoting.

Are there any other idea's how can i solve this?

Best regards,
Thomas

Hi,

what about using Query Notification ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||I had the same problem as you and I have used two different tecniques: both of them uses CLR stored procs.

1. An OS event set by SqlServer: useful when to have to notify that an event occurred without any param. Each different event must be attached to a different event name.

[SqlProcedure]
public static void SetOsEvent(SqlString eventName) {
try {
EventWaitHandle.OpenExisting((string)eventName).Set();
}
catch (WaitHandleCannotBeOpenedException) {
}
}

2. An UDP Message. Useful for non-reliable and fast messaging system, such as broadcasting the internal net that an event has occurred.

[SqlProcedure]
public static void UdpSend(SqlString address, SqlInt32 port, SqlString message) {
try {
System.Net.Sockets.UdpClient client = new System.Net.Sockets.UdpClient();
byte[] datagram = message.GetUnicodeBytes();
client.Send(datagram, datagram.Length, (string)address, (int)port);
}
catch{
}
}

[SqlProcedure]
public static void UdpBroadcast(SqlInt32 port, SqlString message) {
try {
System.Net.Sockets.UdpClient client = new System.Net.Sockets.UdpClient();
byte[] datagram = message.GetUnicodeBytes();
System.Net.IPEndPoint ep = new System.Net.IPEndPoint(System.Net.IPAddress.Broadcast, (int)port);
client.Send(datagram, datagram.Length, ep);
}
catch {
}
}

Hope that helps.

Thursday, March 8, 2012

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

Wednesday, March 7, 2012

Close to quit working with VS 2005 and SQL Express (Cannot Create Database)

About 2 months ago, with great interest installed VS 2005 beta on my local Windows XP Pro. The SQL Express is running.

I cannot work FULLY on starter kits like Personal Web Site SK or Community SK. I create a new web site based on the Community SK. I can successfully bring up ASP.NET configuration, create roles, create users etc. When I look in the App_Data folder there is no ASPNET.MDF database. Where is this getting created?

2) Do we have permissions to create a SQL Database from VS 2005 Beta? I assume not, because at MSDN, there are generic SQL scripts for adding tables to Personal Web site SK and Community SK. For example, a start a new web ASP.NET web site. When I go to add new item, choose SQL Database, I get this error (see below). I am looking for documentation of SQL Express, I don't find any.

With very little time available after work, wife and kids, I am spending tons of hours looking to solve these issues (User Instance, Password Quality and this Access Denied) looking at MSDN, Forums etc. I agree that VS 2005 is a great product and there are great tutorials for VS 2005 both at Microsoft and other places (www.learningvisualstudio.net)

But if I cannot create SQL Databases, from VS 2005 interface, what is the use of going ahead and trying to learn these tools?

If somebody has specific answers or links that can resolve the above issues, please post here. If you have similar difficulties and how you overcame them, post them here. Thanks.
================================

Directory lookup for the file D:\Documents and Settings\<local computer name>\my documents\visual studio 2005\WebSites\Lesson07\App_Data\Customers.mdf” failed with the operating system error 5 (Access Denied).

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

User does not have permission to alter database ‘4BE36399-4C49-4103-963D-7F34626E3914’ or the database does not exist.

ALTER DATABASE statement failed.

User does not have permission to alter database ‘4BE36399-4C49-4103-963D-7F34626E3914’ or the database does not exist.

ALTER DATABASE ‘4BE36399-4C49-4103-963D-7F34626E3914’ does not exist. Use sp_helpdb to show available databases.

=================================

There are two ways you can create databases. As you note, the MDF should be in the data folder. However, if you are running SSE with a UserInstance token in the connection string, then you are running SSE under your own account and you are full-on admin and can do anything you want. In this scenario, you can be logged on as admin or a normal user.

If you are connecting to SSE in the main instance, and you are running as a normal user, you might run into the situation you're describing.

If you get a copy of SSEUtil from the web (search for it), you will find it's a great way to figure out what's going on. It's like SQLCmd, but a lot friendlier. And, it works witih both SSE in the main instance and when it runs under your user account as a normal user.

In order, the things to check are:

1.) is SSE running?
2.) are you working in USERInstance mode or normal?
3.) Can you use SSEUtil to connect to and create databases.

Thursday, March 29, 2012

cluster SSAS and SQL

Cluster SQL 2000 errorlog problem

Cluster SQL 2000 errorlog problem

Tuesday, March 27, 2012

Cluster SQL 2000 errorlog problem

Cluster server connection

Sunday, March 25, 2012

cluster installing

Tuesday, March 20, 2012

Cluster and Instances

Sunday, March 11, 2012

CLR Trigger -> Send Insert/Update/Delete Message to Windows Service

Thursday, March 8, 2012

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

Wednesday, March 7, 2012

Close to quit working with VS 2005 and SQL Express (Cannot Create Database)

Clearing LOG Files

Blog Archive

About Me