Microsoft SQL Server 2005 disappears on one node.

Hi,
Our production database set on cluster SQL Server 2005 (SP1). I installed
client tools for all 4 nodes. Every node should show Microsoft SQL Server
2005 and Microsoft Visual Studio 2005 after click All Programs, but in one
node the Microsoft SQL Server 2005 disappeared.
While I go to Add or Remove Programs, I saw following items:
Microsoft SQL Server 2005 (64 bit)
Microsoft SQL Server Backward compatibility
Microsoft SQL Server Books online (English)
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files (English)
Microsoft SQL Server VSS Writer
It seems like nobody removed the client tools, but why it doesn’t show? How
to restore it to Start -> All Programs -> Microsoft SQL Server 2005?
Regards,
Chen
The client tools were never installed on that node. The installer for the
tools is not cluster-aware. Each node's client tools must be installed
separately from the local machine.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:26B7492E-F768-425D-8DD3-6A91512C584D@.microsoft.com...
> Hi,
> Our production database set on cluster SQL Server 2005 (SP1). I installed
> client tools for all 4 nodes. Every node should show Microsoft SQL Server
> 2005 and Microsoft Visual Studio 2005 after click All Programs, but in one
> node the Microsoft SQL Server 2005 disappeared.
> While I go to Add or Remove Programs, I saw following items:
> Microsoft SQL Server 2005 (64 bit)
> Microsoft SQL Server Backward compatibility
> Microsoft SQL Server Books online (English)
> Microsoft SQL Server Native Client
> Microsoft SQL Server Setup Support Files (English)
> Microsoft SQL Server VSS Writer
> It seems like nobody removed the client tools, but why it doesn’t show?
> How
> to restore it to Start -> All Programs -> Microsoft SQL Server 2005?
> Regards,
> Chen
>
|||Hi Geoff,
Thanks for reply.
The client tools were installed on every node and I applied SP1 on every
node before database migrates from SQL Server 2000 to this cluster server. It
could be someone removed? What I need to do get this back, just re-install
the client tools on this node?
Regards,
Chen
"Geoff N. Hiten" wrote:

> The client tools were never installed on that node. The installer for the
> tools is not cluster-aware. Each node's client tools must be installed
> separately from the local machine.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:26B7492E-F768-425D-8DD3-6A91512C584D@.microsoft.com...
>
|||Yes. A simple reinstall should correct the issue.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:65616AD1-8DB6-44C3-B334-82797375FCE1@.microsoft.com...[vbcol=seagreen]
> Hi Geoff,
> Thanks for reply.
> The client tools were installed on every node and I applied SP1 on every
> node before database migrates from SQL Server 2000 to this cluster server.
> It
> could be someone removed? What I need to do get this back, just re-install
> the client tools on this node?
> Regards,
> Chen
> "Geoff N. Hiten" wrote: