vcs-win-SCOM2007-SQL2005-5a

 Basic information
Release type: Hot Fix
Release date: 2009-10-07
OS update support: None
Technote: TECH75254 - Veritas Storage Foundation High Availability for Windows 5.1 (SFWHA) and Veritas Cluster Server 5.1 for Windows (VCS) updated System Center Operations Manager 2007 (SCOM) Management Packs (MP)
Documentation: None
Popularity: 877 viewed    downloaded
Download size: 109.9 KB
Checksum: 1391217575

 Applies to one or more of the following products:
Cluster Server 5.1 On Windows 32-bit
Cluster Server 5.1 On Windows IA64
Cluster Server 5.1 On Windows x64
Storage Foundation HA 5.1 On Windows 32-bit
Storage Foundation HA 5.1 On Windows IA64
Storage Foundation HA 5.1 On Windows x64

 Fixes the following incidents:
1843778

Readme file
Date: 2009-10-07
OS: Windows
OS Version: 2003, 2008
Package: Symantec.SQLServer.2005.mp

Etrack Incidents: 1843778
.
Errors/Problems Fixed:
+++++++++++++++++
This package contains the VCS application management pack for Microsoft SQL Server 2005.
Use this management pack to monitor SQL Server 2005 configured under VCS in a Systems Center Operations Manager 2007 monitoring environment.
.
Details:
++++++
VCS management pack file name:
	- Symantec.SQLServer.2005.mp
Version: 5.1.10000.5
Supported Applications:
	- Microsoft SQL Server 2005
Supported MOM versions:
	- Microsoft System Center Operations Manager 2007 SP1
	- Microsoft System Center Operations Manager 2007 R2
Supported Microsoft SQL 2005 Management Pack version: 6.0.6648.0
.
Fixes Applied for Products:
++++++++++++++++++++
	- Storage Foundation and HA 5.1 for Windows or later
	- Veritas Cluster Server 5.1 for Windows or later
.
Prerequisites:
++++++++++
Before you proceed ensure that the following prerequisites are completed:
.
- Verify that Operations Manager 2007 infrastructure is set up and configured correctly.
See the Microsoft System Center Operations Manager 2007 documentation for more information.
.
- Download and import the VCS Library Management Pack file, Symantec.VCS.Library.mp.
Refer to the topic "About deploying the VCS Library Management Pack" in the Veritas Cluster Server Library Management Pack Guide for Systems Center Operations Manager 2007" for instructions.
The guide (VCS_LibraryMgmtPack_SCOM2007.pdf) is included with the Library Management pack. Ensure that you complete all the procedures mentioned in the topic.
.
- Ensure that the SQL Server Browser service is running on all the nodes.
.
- Install SQL-DMO on all the nodes where SQL service group is configured. Using SQL-DMO you can monitor the SQL Server 2005 instances.
See the Microsoft System Center Operations Manager 2007 documentation for more information.
.
- Ensure that the Lanman resource is online on the cluster node. Also, ensure that the Lanman agent attributes, ADUpdateRequired and DNSUpdateRequired are set to True. If they are not, set them to True, take the Lanman resource offline and then bring it online.
.
Install/Uninstall Instructions:
+++++++++++++++++++++
[1] Download and extract the patch zip file to a temporary location on your system.
.
[2] Import the VCS SQL Server 2005 management pack file, Symantec.SQLServer.2005.mp.
Note that the VCS SQL Server 2005 management pack requires the original SQL Server 2005 management packs provided by Microsoft. 
See the Microsoft System Center Operations Manager 2007 documentation for instructions on importing management packs.
.
[3] Install the Operations Manager 2007 agent on the cluster nodes.
Refer to the topic "Installing the Operations Manager 2007 agent on the cluster nodes" in the "Veritas Cluster Server Library Management Pack Guide for Systems Center Operations Manager 2007" for instructions.
The guide (VCS_LibraryMgmtPack_SCOM2007.pdf) is included with the VCS Library Management pack.
.
[4] Configure agent-managed computers as proxy.
Refer to the topic "Configuring agent-managed computers as proxy" in the "Veritas Cluster Server Library Management Pack Guide for Systems Center Operations Manager 2007" for instructions.
The guide (VCS_LibraryMgmtPack_SCOM2007.pdf) is included with the VCS Library Management pack.
.
About the VCS SQL Server 2005 management pack
++++++++++++++++++++++++++++++++++++++
The VCS SQL Server 2005 management pack contains rules to discover SQL 2005 virtual servers configured under VCS. The VCS SQL Server 2005 management pack also customizes the discoveries that are included in the original SQL Server 2005 management packs provided by Microsoft.
.
List of Microsoft management pack discoveries
The following discoveries of the Microsoft SQL Server 2005 management packs are overridden to disable for Windows Server:
.
- Discover SQL 2005 Database Engines (Windows Server)
	(Microsoft.SQLServer.2005.DBEngineDiscoveryRule.Server)
- Discover SQL 2005 Reporting Services (Windows Server)
	(Microsoft.SQLServer.2005.ReportingServicesDiscoveryRule.Server)
- Discover SQL 2005 Analysis Services (Windows Server)
	(Microsoft.SQLServer.2005.AnalysisServicesDiscoveryRule.Server)
- Discover SQL 2005 Integration Services (Windows Server)
	(Microsoft.SQLServer.2005.IntegrationServicesDiscoveryRule.Server)
.
List of VCS management pack discoveries
The following discoveries are customized in the VCS SQL Server 2005 management:
.
- Discover SQL 2005 Database Engines (Windows Server) by Symantec
	(Symantec.SQLServer.2005.DBEngineDiscoveryRule.Server)
- Discover SQL 2005 Reporting Services (Windows Server) by Symantec
	(Symantec.SQLServer.2005.ReportingServicesDiscoveryRule.Server)
- Discover SQL 2005 Analysis Services (Windows Server) by Symantec
	(Symantec.SQLServer.2005.AnalysisServicesDiscoveryRule.Server)
- Discover SQL 2005 Integration Services (Windows Server) by Symantec
	(Symantec.SQLServer.2005.IntegrationServicesDiscoveryRule.Server)