Date: 2012-07-03
OS: Windows
OS Version: 2003, 2008
Package: Symantec.SQLServer.2012.mp
Etrack Incidents: 2810096
.
Errors/Problems Fixed:
+++++++++++++++++
This package contains the VCS application management pack for Microsoft SQL Server 2012.
Use this management pack to monitor SQL Server 2012 configured under VCS in a Systems Center Operations Manager 2007 monitoring environment.
.
Details:
++++++
VCS management pack file name: 
	- Symantec.SQLServer.2012.mp
Version: 6.0.00000.0
Supported Applications: 
	- Microsoft SQL Server 2012
Supported MOM versions:
	- Microsoft System Center Operations Manager 2007 SP1
	- Microsoft System Center Operations Manager 2007 R2
Supported Microsoft SQL 2012 Management Pack version: 6.3.173.0
.
Fixes Applied for Products: 
++++++++++++++++++++
	- Storage Foundation and HA 6.0 for Windows or later
	- Veritas Cluster Server 6.0 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 2012 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 2012 management pack file, Symantec.SQLServer.2012.mp.
Note that the VCS SQL Server 2012 management pack requires the original SQL Server 2012 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 2012 management pack
++++++++++++++++++++++++++++++++++++++
The VCS SQL Server 2012 management pack contains rules to discover SQL 2012 virtual servers configured under VCS. The VCS SQL Server 2012 management pack also customizes the discoveries that are included in the original SQL Server 2012 management packs provided by Microsoft.
.
List of Microsoft management pack discoveries:
The following discoveries of the Microsoft SQL Server 2012 management packs are overridden to disable for Windows Server:
.
- Discover SQL 2012 Database Engines (Windows Server)
	(Microsoft.SQLServer.2012.DBEngineDiscoveryRule.Server)
- Discover SQL 2012 Reporting Services (Windows Server)
	(Microsoft.SQLServer.2012.ReportingServicesDiscoveryRule.Server)
- Discover SQL 2012 Analysis Services (Windows Server)
	(Microsoft.SQLServer.2012.AnalysisServicesDiscoveryRule.Server)
.
List of VCS management pack discoveries: 
The following discoveries are customized in the VCS SQL Server 2012 management:
.
- Discover SQL 2012 Database Engines (Windows Server) by Symantec
	(Symantec.SQLServer.2012.DBEngineDiscoveryRule.Server)
- Discover SQL 2012 Reporting Services (Windows Server) by Symantec
	(Symantec.SQLServer.2012.ReportingServicesDiscoveryRule.Server)
- Discover SQL 2012 Analysis Services (Windows Server) by Symantec
	(Symantec.SQLServer.2012.AnalysisServicesDiscoveryRule.Server)