Re: Microsoft SQL Server 2005 disappears on one node.

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: SQL Server Native Client is not supported on the current proce
    ... Messages below makes me think a SQL Server 2005 instance might be still be installed with Client Tools on your system. ... If you are sure there is no any SQL Server 2005 services, then I can suggest you to download Windows Installer Cleanup Utility and run it to clear all unnecessary SQL Server 2005 installation related items using it. ... When you open Programs and Features in CP, click on the Microsoft SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Microsoft SQL Server 2005 disappears on one node.
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... The client tools were installed on every node and I applied SP1 on every ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Change Type button disabled
    ... (Help->About-> Microsoft SQL Server Manament Studio) ... is it the Change Type button or the items in it disabled? ... If your Client Tools' s version is RTM then update it using SP3. ...
    (microsoft.public.sqlserver.setup)
  • Re: service packs to client tools
    ... Apply the SP to the client tools too. ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ...
    (microsoft.public.sqlserver.tools)
  • Re: Applying SP3A to a new node
    ... Yes, the installer is ... > Mike Epprecht, Microsoft SQL Server MVP ... >> cannot find the shared resources. ...
    (microsoft.public.sqlserver.clustering)