Sql-server – Can’t upgrade from SQL 2008 R2 Evaluation to Workgroup

1) Yes. You will need an Active Directory infrastructure available. SCOM is heavily tied into those services. It is described further in the Infrastructure section of the Environmental Prerequisites.

2) Yes, but you may need a newer version of SCOM 2007. The original release version of SCOM does not support SQL 2008 because it didn't exist when it came out. However, SCOM 2007 R2 does support SQL 2008 with SP1. Here is the Operations Manager 2007 R2 Supported Configurations page. I think SCOM 2007 SP1 also supports SQL 2008, but you should just start with R2 if you're starting from scratch anyways.

3) Install Active Directory and get media for SCOM 2007 R2 instead of the original release.

The first thing you need to do is establish why isn't the service starting. The SSAS service will log its problems into the system event log, and there is where you need to look. Start EventVwr.exe and check the application log for events reported by SSAS.

The errors are also reported in the error log files, see Analysis Services Configuration - Data Directories for their location.