all groups > sql server clustering > april 2007 >
You're in the

sql server clustering

group:

Microsoft SQL Server 2005 disappears on one node.


Microsoft SQL Server 2005 disappears on one node. Chen
4/17/2007 11:10:03 AM
sql server clustering:
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
Re: Microsoft SQL Server 2005 disappears on one node. Geoff N. Hiten
4/17/2007 4:38:01 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


[quoted text, click to view]
Re: Microsoft SQL Server 2005 disappears on one node. Chen
4/18/2007 6:50:01 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

[quoted text, click to view]
Re: Microsoft SQL Server 2005 disappears on one node. Geoff N. Hiten
4/18/2007 10:08:16 AM
Yes. A simple reinstall should correct the issue.

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



[quoted text, click to view]
AddThis Social Bookmark Button