Kendra Thorpe’s VU Blog

Here is a list of the issues I had while building the SQL 2005 test cluster and the fixes for those issues:

Configure Raid Controller: http://support.microsoft.com/kb/296594
Silence the alarm during configuration: http://www.dellcommunity.com/supportforums/board/message?board.id=pes_hardrive&thread.id=26879&jump=true&c=us&l=en&cs=&s=gen
You receive error messages when you try to set up a clustered instance of SQL Server 2005: http://support.microsoft.com/kb/910851

Failure Audit for Cluster Service Account: Receive the following Event in the Application Log of the test and production SQL 2005 cluster. It turns out the SharePoint install left some old timer jobs. Once those jobs were deleted, the failure audit is gone. Thanks to http://roadburn.audioreload.com/2007/11/29/error-18456-severity-14-state-16/.

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 3/24/2008
Time: 4:34:00 PM
User: domain\user
Computer: CLUSTERNAME
Description:
Login failed for user ‘domain\user’. [CLIENT: 0.0.0.0]

Create Slipstream of MOSS 2007 with SP1, WSS 3.0 with SP1 and Project Server 2007 with SP1:
http://technet.microsoft.com/en-us/library/cc261890.aspx

Vista patch for User credential prompts: http://blogs.msdn.com/sharepoint/archive/2008/01/18/known-issue-office-2007-on-windows-vista-prompts-for-user-credentials-when-opening-documents-in-a-sharepoint-2007-site.aspx

SCOM Doesn’t Monitor Cluster Virtual Nodes: http://opsmgr.wordpress.com/2007/05/10/scom-doesnt-pick-up-the-cluster-servers-virtual-devices/

Manually Add DNS Names for Clusters in SCOM: http://systemcentercommunity.com/forums/t/3814.aspx

Error Message when I attempt to install Operations Manager 2007 SP1: Error 25154.Failed to execute SQL script. Error Code: -2147217900 (Ad hoc update to system catalogs is not supported.)
On the SQL Server that has the Operations Manager database, run the following command:

use master
go
exec sp_configure ‘allow updates’, 0
RECONFIGURE WITH OVERRIDE

-You should see the following message in the Messages window in SQL Management Studio:
Configuration option ‘allow updates’ changed from 1 to 0. Run the RECONFIGURE statement to install.
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.mom.setup_upgrade&tid=d4ab9778-825e-4f84-9c17-549b83cf9739&cat=&lang=&cr=&sloc=&p=1