Database Reference
In-Depth Information
• Installing and configuring the Ambari SCOM Management Pack in
SCOM
We are making an assumption that you already have a SCOM Server set
up within your environment to take advantage of the Management Pack.
If you don't, you can download a preview virtual machine from Microsoft:
To get started, download the Ambari SCOM Management Pack here:
Configuring SQL Server
First, you will need to configure a SQL Server for the Ambari SCOM
database. If you don't have a SQL Server, you will first need to do the
installation and come back to this series of steps. The steps involved for
configuring SQL Server are:
1. Configure SQL Server to use “mixed mode” authentication. Open SQL
Server Management Studio and connect to SQL Server. Right-click on
the server and choose Properties. Change Server Authentication to SQL
Server and Windows Authentication mode. Click OK.
2. Confirm SQL Server is enabled to use TCP/IP and is active. Open SQL
Server Configuration Manager and choose SQL Server Network
Configuration. Drill down to Protocols for MSSQLServer and find TCP/
IP over to the right. If it is disabled, double-click on TCP/IP and enable
it. Then follow the additional instructions about restarting your SQL
Service.
3. Create a username and password for the Ambari SCOM MP to capture
metrics and store them on SQL Server.
4. Extract the contents of the
metrics-sink.zip
package and open the
Hadoop-Metrics-SQLServer-CREATE.ddl
script in SQL Server
Management Studio. Alternatively you can open it in Notepad and copy
and paste the script into a New Query window in SQL Server
Management Studio.
5. Execute the DDL script from Step 4 to create the Ambari SCOM
database called HadoopMetrics.
