Wednesday, January 16, 2008 2:30 AM Brian S. Tucker

SCOM 2007 Reporting and Data Warehouse SQL install Order of SQL SP

When you have a server that will have SQL 2005 local and both the DW and reporting on the same server, follow the install process below.

1. Install SQL 2005 and name the default instance something unique. Add the DB services and workstation components. This will be for the DW DB

2. Install SQL 2005 again and install a new DB and Reporting services with a named instance different than the first.

3. Install SQL 2005 SP1 to both instances

4. Install SQL 2005 SP2 to the instance for the DW and uncheck it for the reporting services.

The DW can be on SP2, but Reporting Services has to be on the local server and SP1 only as of now.

Share this post:                                       
Filed under: ,

Comments

# A few bumps on the "Building SCOM SP1 Reporting Server" Road

Monday, March 17, 2008 6:06 PM by Ying Li at myITforum.com

We have a SCOM 2007 environment and initially it was a one server (RMS, OpsDB)environment. We upgraded

# re: SCOM 2007 Reporting and Data Warehouse SQL install Order of SQL SP

Friday, September 04, 2009 3:14 PM by sherpadude

I know this is a newb question but I'm trying to find out if it's possible to do a SCOM 2007 install on virgin 2008 sp2 server and install SQL repository to instance on other box.  This would seem best practice.  (as it it would be sccm etc).

Note you cannot select (enter) other sQL server during SCOM install, thoughts?