SCOM ACS User Logon Report

This is a report I created for the Audit Collection Services of System Center Operations Manager that lists all successful user logons details in all servers.

SharePoint Project Sites appear in the navigation menu

After I edited the navigation menu in Microsoft Project Server 2010, I found new links to all the project sites.

To solve the problem I had to delete them manually from the Quick Launch page.
Since the SharePoint Publishing feature is enabled, Quick Launch link will be replaced by Navigation, access it from the url /_layouts/quiklnch.aspx

Configure HTTPS on IIS 7 and SharePoint 2010

This post is about configuring https on SharePoint 2010 web application running on multiple load balanced IIS 7 web servers.
Assuming you already have a digital certificate, follow the coming steps. If you do not have a certificate, you can either purchase or create a self signed certificate but in that case you will receive a warning in the browser when opening the website.

suspect db in SQL 2008 R2

The Central Administration website of SharePoint 2010 suddenly stopped working giving a 404 HTTP error.

The following error was showing in the ULS logs

This website has been configured to disallow editing with SharePoint Designer (Project Server 2010)

When trying to edit a web part in the Business Intelligence site with SharePoint Designer, I got this error

This web site has been configured to disallow editing with SharePoint Designer.

To allow editing open this file on the SharePoint server C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\SiteTemplates\PWA\XML\ONET.XML and remove this part DisableWebDesignFeatures="wdfopensite" from the line <Project Title="Project Web App" Revision="2" ListDir="$Resources:core,lists_Folder;" SiteLogoUrl="/_layouts/inc/pwa/images/SiteIcon.png" xmlns:ows="Microsoft SharePoint" DisableWebDesignFeatures="wdfopensite" UIVersion="4">

Restart IIS and repeat for all other, if any, SharePoint Servers.

Adding SCOM 2012 Product Key

After I installed SCOM 2012 it was showing as Evaluation version. In order to add the product key you need to run a powershell cmdlet as described in the kb article http://support.microsoft.com/kb/2699998

To check the current license, open an Operations Manager Shell and run

Get-SCOMManagementGroup | ft skuforlicense, version, timeofexpiration –a

To register your product run

Set-SCOMLicense -ProductId "Product-Key-Here"

The license got updated after I restarted the server

SCOM 2012 single server deployment

This is a simple deployment of SCOM 2012 installing all roles on a single Windows 2008 R2 server. Microsoft reommends this type of deployment for evaluation and testing purposes.

First install dotnet framekwork 3.5, 4.0 and the Microsoft Report Viewer 2010 Redistributable Package. Then Install and configure IIS web role and SQL server

I have created an active directory group ScomAdmins with local admin rights to the SCOM servers and SQL sysadmin role. I also created the following service accounts.

User	Description
ScomAction	Management server action account – used to gather information and run responses on managed servers
SCOMSDK	System Center Configuration Service and System Center Data Access Service Account – used to update the Operations Manager Database. This account needs local admin rights to the SCOM server
SCOMRead	Used by the Reporting Services to run queries against the reporting data warehouse
SCOMWrite	Reads from the operational database and updates the reporting data warehouse

I log in with a member of the ScomAdmins group: ScomAdmin and launch SCOM 2012 setup

The setup will check next for prerequisistes, installing any missing ones and proceed

Type in the name of the Management Group and proceed. Previously in SCOM 2007 you could have only 1 root management server, SCOM 2012 allows the management server role to be assigned to multiple servers making it easier to acheive high availability.

Type in the name of the SQL server and wait for setup to verify, in my case it is the same server.

Setup will probe next for available Reporting Services installations. If there is a problem hover over the red X for details. Resolve any issues and proceed, in my case the SQL Server Agent service was not running so I started and set it to automatic from the SQL Server Configuration Manager.

Next, choose the web site and authentication mode for the web console

Fill in the service accounts created earlier in the active directory and proceed

SCOM 2012 is now installed. You should then import the management packs you need and discover the devices to manage.