Re: Microsoft SQL Server 2005 disappears on one node.

Yes. A simple reinstall should correct the issue.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"Chen" <Chen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:65616AD1-8DB6-44C3-B334-82797375FCE1@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26B7492E-F768-425D-8DD3-6A91512C584D@xxxxxxxxxxxxxxxx
> 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
>



.

Relevant Pages

  • Re: AWE - SQL Server 2000 - Memory usage
    ... AWE only works when you have more that 4 GB... ... "Geoff N. Hiten" wrote: ... >>> Senior Database Administrator ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Active/Active/Active without SAN
    ... internet, another lease line to data center 2. ... "Geoff N. Hiten" wrote: ... >>> Senior Database Administrator ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: AWE - SQL Server 2000 - Memory usage
    ... >> Geoff N. Hiten ... >> Senior Database Administrator ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Create databases in a cluster
    ... Availability Database Solutions using Microsoft SQl Server 2005, ... Senior Database Administrator ... So I left to train myself and seek advice from experienced cluster ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: AWE & PAE Assistance
    ... I agree totally with Geoff on this. ... >>> Windows 2000 Advanced Server gives you up to 8GB memory. ... >>> Senior Database Administrator ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
Loading