SQL Server
(1)
Every
(1)
Restore
(1)
Database
(1)

SQL Server 2005 disappears on one node.

Asked By Che
17-Apr-07 02:10 PM
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.

Asked By Geoff N. Hiten
17-Apr-07 04:38 PM
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

Hi Geoff,Thanks for reply.

Asked By Che
18-Apr-07 09:50 AM
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

Yes. A simple reinstall should correct the issue.-- Geoff N.

Asked By Geoff N. Hiten
18-Apr-07 10:08 AM
Yes.  A simple reinstall should correct the issue.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
Post Question To EggHeadCafe