search
Japanese Chinese Nederlands Espanol Italiano Deutsch Francais Twitter Rss Feeds
SQL Server GroupsView
SQL Server Ce
SQL Server Clients
SQL Server Clustering
SQL Server Connect
SQL Server Dts
SQL Server Fulltext
SQL Server Integrationsvcs
SQL Server Msde
SQL Server Newusers
SQL Server Olap
SQL Server Programming
SQL Server Replication
SQL Server Reportingsvcs
SQL Server Security
SQL Server Server
SQL Server Setup
SQL Server Tools
SQL Server Xml

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Application Development
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft SQL Server Clustering Posts  Ask A New Question 

SQL Server 2005 disappears on one node. - Che

Tuesday, April 17, 2007 2: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
reply
 

The client tools were never installed on that node. - Geoff N. Hiten

Tuesday, April 17, 2007 4: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
reply

Hi Geoff,Thanks for reply. - Che

Wednesday, April 18, 2007 9: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
reply

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

Wednesday, April 18, 2007 10:08 AM

Yes.  A simple reinstall should correct the issue.

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

Previous Microsoft SQL Server Clustering conversation.