Cluster issue

I'm having an issue with a two node cluster. We're using failover clustering
in SQL 2000 but everytime the first node fails it doesn't automatically
failover to the second node. Are there any KB articles dealing with this?
I've searched but can't seem to find what I'm looking for. Thanks in advance.
http://www.microsoft.com/technet/arc.../mscstswp.mspx
MG
"Nicholas" wrote:

> I'm having an issue with a two node cluster. We're using failover clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in advance.
|||You need to look at the SQL Server and System Event Application logs to see
what resource is not coming online and why. There are many reasons why a
cluster won't fail over, so finding the exact cause is the first step. If
you have troubleshooting time, you can manually (using the Cluster
Administrator tool) take the SQL group offline, move it to the other node,
and bring each resource online one at a time to see exactly where it fails.
Post your results and we will go from there.
Geoff N. Hiten
Microsoft SQL Server MVP
"Nicholas" <Nicholas@.discussions.microsoft.com> wrote in message
news:509577DA-5060-4B80-A61D-28981BED4233@.microsoft.com...
> I'm having an issue with a two node cluster. We're using failover
> clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in
> advance.
|||Thanks. Didn't think to check TechNet for some reason.
"MGeles" wrote:
[vbcol=seagreen]
> http://www.microsoft.com/technet/arc.../mscstswp.mspx
> --
> MG
>
> "Nicholas" wrote:
sqlsql

Cluster issue

I'm having an issue with a two node cluster. We're using failover clustering
in SQL 2000 but everytime the first node fails it doesn't automatically
failover to the second node. Are there any KB articles dealing with this?
I've searched but can't seem to find what I'm looking for. Thanks in advance.http://www.microsoft.com/technet/archive/winntas/support/mscstswp.mspx
--
MG
"Nicholas" wrote:
> I'm having an issue with a two node cluster. We're using failover clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in advance.|||You need to look at the SQL Server and System Event Application logs to see
what resource is not coming online and why. There are many reasons why a
cluster won't fail over, so finding the exact cause is the first step. If
you have troubleshooting time, you can manually (using the Cluster
Administrator tool) take the SQL group offline, move it to the other node,
and bring each resource online one at a time to see exactly where it fails.
Post your results and we will go from there.
Geoff N. Hiten
Microsoft SQL Server MVP
"Nicholas" <Nicholas@.discussions.microsoft.com> wrote in message
news:509577DA-5060-4B80-A61D-28981BED4233@.microsoft.com...
> I'm having an issue with a two node cluster. We're using failover
> clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in
> advance.|||Thanks. Didn't think to check TechNet for some reason.
"MGeles" wrote:
> http://www.microsoft.com/technet/archive/winntas/support/mscstswp.mspx
> --
> MG
>
> "Nicholas" wrote:
> > I'm having an issue with a two node cluster. We're using failover clustering
> > in SQL 2000 but everytime the first node fails it doesn't automatically
> > failover to the second node. Are there any KB articles dealing with this?
> > I've searched but can't seem to find what I'm looking for. Thanks in advance.

Cluster issue

I'm having an issue with a two node cluster. We're using failover clustering
in SQL 2000 but everytime the first node fails it doesn't automatically
failover to the second node. Are there any KB articles dealing with this?
I've searched but can't seem to find what I'm looking for. Thanks in advance
.http://www.microsoft.com/technet/ar...t/mscstswp.mspx
--
MG
"Nicholas" wrote:
[vbcol=seagreen]
> I'm having an issue with a two node cluster. We're using failover clusteri
ng
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in advance.[/vbc
ol]|||You need to look at the SQL Server and System Event Application logs to see
what resource is not coming online and why. There are many reasons why a
cluster won't fail over, so finding the exact cause is the first step. If
you have troubleshooting time, you can manually (using the Cluster
Administrator tool) take the SQL group offline, move it to the other node,
and bring each resource online one at a time to see exactly where it fails.
Post your results and we will go from there.
Geoff N. Hiten
Microsoft SQL Server MVP
"Nicholas" <Nicholas@.discussions.microsoft.com> wrote in message
news:509577DA-5060-4B80-A61D-28981BED4233@.microsoft.com...
> I'm having an issue with a two node cluster. We're using failover
> clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in
> advance.|||Thanks. Didn't think to check technet for some reason.
"MGeles" wrote:
[vbcol=seagreen]
> http://www.microsoft.com/technet/ar...t/mscstswp.mspx
> --
> MG
>
> "Nicholas" wrote:
>

Click to Sort Column Headings

Is there a table property that allows for this? or Do I have to build that
into my query and requery everytime I want to sort? Can someone provide an
example?Rich,
Thanks for the response. I don't see the attached project. Can you post
the link to where you found the project or provide a detailed description on
how to do it (please be as descript as possible...I am noob)?
Thanks!
"Rich Millman" wrote:
> No, there is no table property for this.
> It is not difficult.
> First thing to understand is that you don't sort in your query, you let RS
> do the sorting.
> Then in your column headings you provide actions to open your report,
> passing in parameters that control the sorting.
> Attached is a project that you can use as a sample. I didn't write it, but
> it helped me.
>
> "Neo" <Neo@.discussions.microsoft.com> wrote in message
> news:3FC1A47E-4D46-4604-981D-01DE508D134B@.microsoft.com...
> > Is there a table property that allows for this? or Do I have to build
> > that
> > into my query and requery everytime I want to sort? Can someone provide
> > an
> > example?
>
>|||If you are using Outlook express a paper clip shows the attachment. The
posting did have an attachment with it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neo" <Neo@.discussions.microsoft.com> wrote in message
news:B964369A-A97D-4C66-AE47-F6F670051B74@.microsoft.com...
> Rich,
> Thanks for the response. I don't see the attached project. Can you post
> the link to where you found the project or provide a detailed description
on
> how to do it (please be as descript as possible...I am noob)?
> Thanks!
> "Rich Millman" wrote:
> > No, there is no table property for this.
> > It is not difficult.
> > First thing to understand is that you don't sort in your query, you let
RS
> > do the sorting.
> > Then in your column headings you provide actions to open your report,
> > passing in parameters that control the sorting.
> >
> > Attached is a project that you can use as a sample. I didn't write it,
but
> > it helped me.
> >
> >
> > "Neo" <Neo@.discussions.microsoft.com> wrote in message
> > news:3FC1A47E-4D46-4604-981D-01DE508D134B@.microsoft.com...
> > > Is there a table property that allows for this? or Do I have to build
> > > that
> > > into my query and requery everytime I want to sort? Can someone
provide
> > > an
> > > example?
> >
> >
> >|||Sorry, I was using the Webbased MS Technet. I opened up the newsgroup with
newsgroup viewer and now have the file.
Thanks!
"Bruce L-C [MVP]" wrote:
> If you are using Outlook express a paper clip shows the attachment. The
> posting did have an attachment with it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Neo" <Neo@.discussions.microsoft.com> wrote in message
> news:B964369A-A97D-4C66-AE47-F6F670051B74@.microsoft.com...
> > Rich,
> >
> > Thanks for the response. I don't see the attached project. Can you post
> > the link to where you found the project or provide a detailed description
> on
> > how to do it (please be as descript as possible...I am noob)?
> >
> > Thanks!
> >
> > "Rich Millman" wrote:
> >
> > > No, there is no table property for this.
> > > It is not difficult.
> > > First thing to understand is that you don't sort in your query, you let
> RS
> > > do the sorting.
> > > Then in your column headings you provide actions to open your report,
> > > passing in parameters that control the sorting.
> > >
> > > Attached is a project that you can use as a sample. I didn't write it,
> but
> > > it helped me.
> > >
> > >
> > > "Neo" <Neo@.discussions.microsoft.com> wrote in message
> > > news:3FC1A47E-4D46-4604-981D-01DE508D134B@.microsoft.com...
> > > > Is there a table property that allows for this? or Do I have to build
> > > > that
> > > > into my query and requery everytime I want to sort? Can someone
> provide
> > > > an
> > > > example?
> > >
> > >
> > >
>
>