I won't describe the SQL 2008 R2 installation here, so make sure it's ready before installation. First choose "Check Prerequisites" on the OpsMgr server. The following Roles and Role Services must be added:
- Application Server
- Web Server (IIS)
- Common HTTP Features (Static Content, Default Document, Directory Browsing, HTTP Errors)
- Application Development (ASP.NET, .NET Extensibility, ISAPI Extensions, ISAPI Filters)
- Health and Diagnostics (HTTP Logging, Request Monitor)
- Security (Windows Authentication, Request Filtering)
- Performance (Static Content Compression)
- Management Tools (IIS Management Console, IIS 6 Metabase Compatibility, IIS 6 WMI Compatibility)
Normally the installation starts with "Install Operations Manager 2007 R2" for installing the databases. This because the specific order which must be followed during installation:
- OperationsManager database component (SQL Server)
- OperationsManager Data Warehouse component (SQL Server)
- OperationsManager Management Server and console components (OpsMgr Server)
- OperationsManager Reporting component (SQL Server)
Then Operations Manager can be installed on the OpsMgr server with the default GUI. Just start with "Install Operations Manager 2007 R2" again and select all components except "Database". Follow all necessary steps during setup for a complete installation. There is the possibility to install it on another location or drive here.
Again a different approach is needed now. Before the Reporting component can be installed a workaround is needed. Otherwise it won't be functional. Have a look at local groups on the SQL Server and rename “SQLServerReportServerUser$<OpsMgr Server>$MSRS10_50.MSSQLSERVER” to “SQLServerReportServerUser$<OpsMgr Server>$MSRS10.MSSQLSERVER”.
Again a different approach is needed now. Before the Reporting component can be installed a workaround is needed. Otherwise it won't be functional. Have a look at local groups on the SQL Server and rename “SQLServerReportServerUser$<OpsMgr Server>$MSRS10_50.MSSQLSERVER” to “SQLServerReportServerUser$<OpsMgr Server>$MSRS10.MSSQLSERVER”.
Now the Reporting component can be installed with the default GUI. Just start with "Install Operations Manager 2007 R2 Reporting" and select the "Reporting Server" component only. No Data Warehouse installation is needed on SQL Server 2008 R2. Follow all necessary steps during setup for the installation. Again there is the possibility to install it on another location or drive.
All components are installed now, but the local group must be changed again. Rename the local group to “SQLServerReportServerUser$<OpsMgr Server>$MSRS10_50.MSSQLSERVER” back again. After that Operations Manager is installed and usable. The Reporting component is even functional then.
To install latest hotfixes CU3 is needed. It can be download here: http://www.microsoft.com/download/en/details.aspx?id=17893
All components are installed now, but the local group must be changed again. Rename the local group to “SQLServerReportServerUser$<OpsMgr Server>$MSRS10_50.MSSQLSERVER” back again. After that Operations Manager is installed and usable. The Reporting component is even functional then.
To install latest hotfixes CU3 is needed. It can be download here: http://www.microsoft.com/download/en/details.aspx?id=17893
All steps needed for a functional installation are explained now. Hope you like it and use these steps for instaling OpsMgr 2007 R2 yourself!