Install and Configure Windows SharePoint Services Monitoring and Data Collection

  • Article
Cc526705.chm_head_left(en-us,TechNet.10).gif Cc526705.chm_head_middle(en-us,TechNet.10).gif Cc526705.chm_head_right(en-us,TechNet.10).gif

Install and Configure Windows SharePoint Services Monitoring and Data Collection

In this section install and configure Microsoft Windows SharePoint Services monitoring and data collection, which will be used for reporting purposes.

Tasks

  1. Install the Windows SharePoint Services 3.0 Management Pack
  2. Grant the SharePoint_AppID User the db_owner Role for the PWDB40 Database
  3. Enable SharePoint Usage Analysis Processing
  4. Install the Windows SharePoint Services Data Collection Application
  5. Verify Your Installation

Prerequisites

Install the Windows SharePoint Services 3.0 Management Pack

Install the Microsoft Windows SharePoint Services 3.0 Management Pack for Microsoft Operations Manager 2005.

Procedure DWSH.21: To install the Windows SharePoint Services 3.0 Management Pack on MOM01

  1. On MOM01, install the Windows SharePoint Services MOM pack, Microsoft Windows SharePoint Services 3.0 MOM 2005 MP.msi, using default settings.
  2. In the left pane of the MOM 2005 Administrator Console, expand Microsoft Operations Manager (MOM01), right-click Management Packs, and then select Import/Export Management Pack.
  3. On the Welcome screen, click Next.
  4. On the Import or Export Management Packs page, leave the default Import Management Packs and/or reports selected, and then click Next.
  5. On the Select a folder and Choose Import Type page, click Browse and navigate to C:\MOM 2005 Management Packs\Microsoft Windows SharePoint Services 3.0 MOM 2005 MP\. Select Import Management Packs only. Click Next.
  6. On the Select Management Packs page, select Microsoft Windows SharePoint Services 3.akm. Leave the remaining settings at defaults and click Next.
  7. Complete the installation of the Windows SharePoint Services MOM pack.

Grant the SharePoint_AppID User the db_owner Role for the PWDB40 Database

The SharePoint_AppID user account needs to be able to write data to the PWDB40 database for reporting purposes. Grant the SharePoint_AppID db_owner role to the PWDB40 database using the SQL Server Management Studio on MOMSQL01.

Procedure DWSH.22: To grant the SharePoint_AppID user the db_owner role for the PWDB40 database on MOMSQL01

  1. On MOMSQL01, in Microsoft SQL Server Management Studio, expand MOMSQL01, expand Security, right-click Logins, and then select New Login.
  2. Type FABRIKAM\SharePoint_AppID.
  3. In the left pane, click User Mappings. In the Users mapped to this login box, in the Map column, select the box for the pwdb40 row. In the Database role membership for: pwdb40 box, select the db_owner check box. Click OK.

Enable SharePoint Usage Analysis Processing

By default, Windows SharePoint Services is not configured to enable usage analysis processing. Enable this using SharePoint Central Administration on COLLAB01.

Procedure DWSH.23: To enable SharePoint Usage Analysis Processing

  1. On COLLAB01, in SharePoint Central Administration, click Operations, and then click Usage analysis processing.
  2. Set the logging settings to Enable Logging. Set the processing settings to Enable usage analysis processing. Leave the default times selected for Run processing between these times daily, and then click OK.

Install the Windows SharePoint Services Data Collection Application

The Windows SharePoint Services data collection tool is an executable program (HSCollectWSSV3Data.exe) that you install on COLLAB01. You need to install the tool, and then create a scheduled task to run the tool.

Note

The data collection tool only needs to be installed to the COLLAB01 server as long as all Windows SharePoint Services sites are load-balanced across all servers. Install this component on any server hosting unique sites.

Procedure DWSH.24: To install the Windows SharePoint Services data collection application

  1. On COLLAB01, from the solution installation media \Monitoring and Reporting\ directory, run HSCollectWssV3Data.msi.
  2. On the Welcome page, select Next.
  3. On the Select Installation Folder page, leave the Folder field set to the default installation folder, and then select Everyone. Select Next to continue.
  4. On the Confirm Installation page, select Next to start the installation.
  5. On the Installation Complete page, select Close.

Procedure DWSH.25: To create a scheduled task to run the data collection application

  1. On COLLAB01, on the Start menu, point to Control Panel, point to Scheduled Tasks, and then click Add Scheduled Task.

  2. In the Scheduled Task Wizard, click Next.

  3. Click Browse, navigate to C:\Program Files\Microsoft Hosting\Reporting\WSSV3 Data Collection, select the file HSCollectWSSV3Data.exe, and then click Open.

  4. Select Daily, and then click Next.

  5. Set Start Time to 1:05 AM, and then click Next.

  6. Enter the Fabrikam\SharePoint_AppID user name and password, and then click Next.

  7. Select Open advanced properties for this task when I click Finish, and then click Finish.

  8. In the Task tab, on the Run line, change the line to append -d PWDB40 -s MOMSQL01. For example:<pre IsFakePre="true" xmlns="https://www.w3.org/1999/xhtml">"C:\Program Files\Microsoft Hosting\Reporting\WSSV3 Data Collection\HSCollectWSSV3Data.exe" -d PWDB40 -s MOMSQL01</pre>

    Note

    Make sure there are spaces in front of and behind the -d and -s parameters.

  9. Click OK.

  10. Re-enter the password for SharePoint_AppID.

  11. Open Windows Explorer and navigate to the C:\Program Files\Microsoft Hosting\Reporting\WSSV3 Data Collection directory.

  12. Right-click the \WSSV3 Data Collection directory and select Sharing and security.

  13. Click the Security tab.

  14. Click the Add button.

  15. In the Select Users, Computers, or Groups dialog box, type Sharepoint_AppID, and then click Check Names.

  16. Click OK to close the dialog box.

  17. In the Groups or user names list box, select the SharePoint_AppID account.

  18. In Permissions for SharePoint_AppID, give the account write permissions on the folder by selecting the box next to Write in the Allow column.

  19. Click OK to close the dialog box.

Add MomActionAccts group to the local Administrators group on each Windows SharePoint Services server.

Procedure DWSH.26: To Add MomActionAccts group to local Administrators group on each Windows Sharepoint Services server

  1. On each Windows SharePoint Services server, open Administrative Tools, and then click Computer Management.
  2. Expand Local Users and Groups, and then click Groups.
  3. Double-click Administrators.
  4. Click Add, and then type MOMActionAccts.
  5. Click Check Names to make sure that the name resolves, and then click OK.

Verify Your Installation

After you have fully installed and configured Windows SharePoint Services, you can verify that your installation was successful by opening the SharePoint Central Administration interface and checking the settings you have configured.

For more information about using the SharePoint Central Administration interface, as well as troubleshooting any installation problems, see the Microsoft Windows SharePoint Services Administrator's Guide.