Stiamo effettuando il passaggio da MOM2005 al nuovo sistema di management di Microsoft. Ho deciso che, vista la complessità del progetto, è indispensabile partire già con le ultime versioni del sistema operativo incontrando più di una difficoltà.

Purtroppo il supporto di Microsoft su Windows Server 2008 su x64 è ancora in rodaggio e lo si capisce dal disallineamento di alcune informazioni rispetto aquanto gli ambienti presentano già nelle schermate.

La prima cosa da fare è consultare queste due guide di Microsoft:

- Operations Manager 2007 SP1 Supported Configurations

- Support for running System Center Operations Manager 2007 Service Pack 1 and System Center Essentials 2007 Service Pack 1 on a Windows Server 2008-based computer

Poiché il numero di client è relativamente basso la configurazione scelta è quella di collassare tutti i ruoli sun un singolo server ( in piccolo mostro di potenza ..) calando i ruoli ausiliari su server preesistenti.

Prima di installare SCOM è indispensabile installare 3 patch sul sistema operativo, installare tutti i server necessari e quindi il sistema di management ed una sua patch sulla SP1. (il consiglio è di installare SCOM dal media con già SP1 risparmiando una considerevole quantità di tempo)

Nonostante tutta l’attenzione risposta in queste procedure Reporting Service di SCOM non si installavano correttamente e la procedura di disistallazione.

Ravanando nei log abbiamo trovato questo errore: “ManagementGroupDisconnectHelper error” e poi la rollback rendeva inutilizzabili il DB e anche IIS !!

Dopo tante peripezzie l’installazione si risolve cone questa procedura (okkio alla nota alla fine):

RESOLUTION:

How to Install Reporting Services on Win 2008
Before you install SQL Server 2005 Reporting Services, you must enable Microsoft
ASP.NET and Microsoft Internet Information Services (IIS). To enable ASP.NET and
IIS, follow these steps:
1. In Control Panel, click Programs, and then double-click Programs and Features.
2. In the User Account Control dialog box, click Continue.
3. Click Turn Windows features on or off.
4. In the Windows Features dialog box, expand Internet Information Services, expand
Web Management Tools, expand IIS 6 Management Compatibility, and then click to
select the following check boxes: • IIS 6 WMI Compatibility
• IIS Metabase and IIS 6 configuration compatibility
5. Expand World Wide Web Services, expand Application Development Features, and
then click to select the following check boxes: • ASP.NET
• ISAPI Extensions
• ISAPI Filters
6. Expand Common HTTP Features, and then click to select the following check boxes:
• Default Document
• Directory Browsing
• HTTP Errors
• HTTP Redirection
• Static Content
7. Expand Security, and then click to select the Windows Authentication check box.
Install SQL Server 2005 Reporting Services
To install SQL Server 2005 Reporting Services, follow these steps: 1. Log on to
Windows 2008, and enable ASP.NET and IIS. For more information, see the
“Prerequisites” section.
*=======================================================*
2. Verify that the World Wide Web Publishing service is started. If the World Wide
Web Publishing service is not started, configure the service to start
automatically. To do this, follow these steps: a. In Control Panel, click System
and Maintenance.
b. Click Administrative Tools.
c. Double-click Services.
d. In the User Account Control dialog box, click Continue.
e. Right-click World Wide Web Publishing Service, and then click Properties.
f. In the World Wide Web Publishing Service Properties dialog box, click Automatic
in the Startup Type list.
g. Click Apply, click Start, and then click OK.
*=======================================================*
3. Start to install SQL Server 2005 or SQL Server 2005 Express Edition with
Advanced Services SP2.
Notes• When you install the original release version of SQL Server 2005, you
receive a warning message that explains that this program has known compatibility
issues. Click Run program to continue the installation.
• In the Feature Selection dialog box, make sure that Reporting Services is
selected.
• In the Report Server Installation Options dialog box, select either of the
following options: • Install the default configuration
• Install but do not configure the server
*=======================================================*
4. Install SQL Server 2005 SP2.
Notes• For more information about how to obtain SQL Server 2005 Service Pack 2,
click the following article number to view the article in the Microsoft Knowledge
Base:
913089 (http://support.microsoft.com/kb/913089/) How to obtain the latest service
pack for SQL Server 2005
• If you install SQL Server 2005 Express Edition with Advanced Services SP2, skip
step 4 because SQL Server 2005 SP2 is already installed.
• You must make sure that the SQL Server service is started before you install SQL
Server 2005 SP2. The SQL Server service must be running to perform an
authentication check in the Authentication Mode dialog box of the Setup program.
• After you leave the Authentication Mode dialog box, you can stop the SQL Server
service to avoid a system restart. To stop the SQL Server service, click
Administrative Tools in Control Panel, double-click Services, right-click the SQL
Server service, and then click Stop.
• If the SQL Server 2005 User Provisioning Tool for 2008 starts, start the SQL
Server service before you grant administrative rights to a user. You can use the
SQL Server 2005 User Provisioning Tool for 2008 to add Windows user accounts to the
SYSADMIN fixed server role easily.
*=======================================================*
5. Start the SQL Server service if the service is not started. If you install SQL
Server Express Edition with Advanced Services SP2, reset IIS.
To reset IIS, follow these steps: 1. Open a command prompt by using the Run as
administrator option.
2. Type IISRESET, and then press Enter.
*=======================================================*
6. If you selected the Install but do not configure the server option in the Report
Server Installation Options dialog box, configure the report server. To do this,
follow these steps: a. Start the Reporting Services Configuration tool. To start
the tool, click Start, point to All Programs, point to SQL Server 2005, point to
Configuration Tools, and then click Reporting Services Configuration.
b. In the User Account Control dialog box, click Continue.
c. In the Report Server Installation Instance Selection dialog box, type the name
of the computer in the Machine Name box.
d. Click the instance of SQL Server 2005 Reporting Services in the Instance Name
list, and then click Connect.
e. Configure the server for operation.
Note Reporting Services runs as a legacy application on IIS 7.0. If you configure
the application pool for the Report Server virtual directory on a new Reporting
Services installation, one of the following methods: • Select Classic .NET AppPool
for the report server.
• Create a new application pool. Then, set the Managed Pipeline Mode option to
Classic.
If you installed Reporting Services by using the default configuration, the report
server runs in its own application pool under the NetworkService account. If you
use the default configuration, the report server is fully operational on Windows
2008. However, you should avoid running the report server in the default
application pool on IIS 7.0. The default application pool has the Managed Pipeline
Mode option set to Integrated. You will receive an “HTTP 500″ error message if you
run the report server in the default application pool.
*=======================================================*
7. Configure the report server for local administration. To access the report
server and Report Manager locally, follow these steps: a. Start Windows Internet
Explorer.
b. On the Tools menu, click Internet Options.
c. Click Security.
d. Click Trusted Sites.
e. Click Sites.
f. Under Add this Web site to the zone, type http://ServerName. If you are not
using HTTPS for the default site, click to clear the Require server certification
(https:) for all sites in this zone check box.
g. Click Add.
h. Repeat step 7f and step 7g to add the http://localhost URL, and then click
Close.
Note This step enables you to start Internet Explorer and open either the localhost
or the network computer name of the server for both the Report Server application
and the Report Manager application.
*=======================================================*
8. Create role assignments that explicitly grant you access together with full
permissions. To do this, follow these steps: a. Start Internet Explorer together
with the Run as administrator option. To do this, click Start, click All Programs,
right-click Internet Explorer, and then click Run as administrator.
b. Open Report Manager. By default, the Report Manager URL is
http://ServerName/reports.
If you use SQL Server Express with Advanced Services SP2, the Report Manager URL is
http://ServerName/reports$sqlexpress. If you use a named instance of Reporting
Services, the Report Manager URL is http://ServerName/reports$InstanceName
c. In the Home dialog box, click Properties.
d. Click New Role Assignment.
e. Type a Windows user account name by using the following format:
Domain\User
f. Click to select the Content Manager check box.
g. Click OK.
h. In the Home dialog box, click Site Settings.
i. Click Configure site-wide security.
j. Click New Role Assignment.
k. Type a Windows user account by using the following format:
Domain\User
l. Click System Administrator.
m. Click OK.
n. Close Report Manager.
*=======================================================*
9. Use Internet Explorer without the Run as administrator option to reopen Report Manager.

How to Install Reporting Services on Win 2008
Before you install SQL Server 2005 Reporting Services, you must enable Microsoft
ASP.NET and Microsoft Internet Information Services (IIS). To enable ASP.NET and
IIS, follow these steps:

1. In Control Panel, click Programs, and then double-click Programs and Features.
2. In the User Account Control dialog box, click Continue.
3. Click Turn Windows features on or off.
4. In the Windows Features dialog box, expand Internet Information Services, expand
Web Management Tools, expand IIS 6 Management Compatibility, and then click to
select the following check boxes: • IIS 6 WMI Compatibility
• IIS Metabase and IIS 6 configuration compatibility
5. Expand World Wide Web Services, expand Application Development Features, and
then click to select the following check boxes: • ASP.NET
• ISAPI Extensions
• ISAPI Filters
6. Expand Common HTTP Features, and then click to select the following check boxes:
• Default Document
• Directory Browsing
• HTTP Errors
• HTTP Redirection
• Static Content
7. Expand Security, and then click to select the Windows Authentication check box.
Install SQL Server 2005 Reporting Services
To install SQL Server 2005 Reporting Services, follow these steps: 1. Log on to
Windows 2008, and enable ASP.NET and IIS. For more information, see the
“Prerequisites” section.
*=======================================================*
2. Verify that the World Wide Web Publishing service is started. If the World Wide
Web Publishing service is not started, configure the service to start
automatically. To do this, follow these steps: a. In Control Panel, click System
and Maintenance.
b. Click Administrative Tools.
c. Double-click Services.
d. In the User Account Control dialog box, click Continue.
e. Right-click World Wide Web Publishing Service, and then click Properties.
f. In the World Wide Web Publishing Service Properties dialog box, click Automatic
in the Startup Type list.
g. Click Apply, click Start, and then click OK.
*=======================================================*
3. Start to install SQL Server 2005 or SQL Server 2005 Express Edition with
Advanced Services SP2.
Notes• When you install the original release version of SQL Server 2005, you
receive a warning message that explains that this program has known compatibility
issues. Click Run program to continue the installation.
• In the Feature Selection dialog box, make sure that Reporting Services is
selected.
• In the Report Server Installation Options dialog box, select either of the
following options: • Install the default configuration
• Install but do not configure the server
*=======================================================*
4. Install SQL Server 2005 SP2.
Notes• For more information about how to obtain SQL Server 2005 Service Pack 2,
click the following article number to view the article in the Microsoft Knowledge
Base:
913089 (http://support.microsoft.com/kb/913089/) How to obtain the latest service
pack for SQL Server 2005
• If you install SQL Server 2005 Express Edition with Advanced Services SP2, skip
step 4 because SQL Server 2005 SP2 is already installed.
• You must make sure that the SQL Server service is started before you install SQL
Server 2005 SP2. The SQL Server service must be running to perform an
authentication check in the Authentication Mode dialog box of the Setup program.
• After you leave the Authentication Mode dialog box, you can stop the SQL Server
service to avoid a system restart. To stop the SQL Server service, click
Administrative Tools in Control Panel, double-click Services, right-click the SQL
Server service, and then click Stop.
• If the SQL Server 2005 User Provisioning Tool for 2008 starts, start the SQL
Server service before you grant administrative rights to a user. You can use the
SQL Server 2005 User Provisioning Tool for 2008 to add Windows user accounts to the
SYSADMIN fixed server role easily.
*=======================================================*
5. Start the SQL Server service if the service is not started. If you install SQL
Server Express Edition with Advanced Services SP2, reset IIS.
To reset IIS, follow these steps: 1. Open a command prompt by using the Run as
administrator option.
2. Type IISRESET, and then press Enter.
*=======================================================*
6. If you selected the Install but do not configure the server option in the Report
Server Installation Options dialog box, configure the report server. To do this,
follow these steps: a. Start the Reporting Services Configuration tool. To start
the tool, click Start, point to All Programs, point to SQL Server 2005, point to
Configuration Tools, and then click Reporting Services Configuration.
b. In the User Account Control dialog box, click Continue.
c. In the Report Server Installation Instance Selection dialog box, type the name
of the computer in the Machine Name box.
d. Click the instance of SQL Server 2005 Reporting Services in the Instance Name
list, and then click Connect.
e. Configure the server for operation.
Note Reporting Services runs as a legacy application on IIS 7.0. If you configure
the application pool for the Report Server virtual directory on a new Reporting
Services installation, one of the following methods: • Select Classic .NET AppPool
for the report server.
• Create a new application pool. Then, set the Managed Pipeline Mode option to
Classic.
If you installed Reporting Services by using the default configuration, the report
server runs in its own application pool under the NetworkService account. If you
use the default configuration, the report server is fully operational on Windows
2008. However, you should avoid running the report server in the default
application pool on IIS 7.0. The default application pool has the Managed Pipeline
Mode option set to Integrated. You will receive an “HTTP 500″ error message if you
run the report server in the default application pool.
*=======================================================*
7. Configure the report server for local administration. To access the report
server and Report Manager locally, follow these steps: a. Start Windows Internet
Explorer.
b. On the Tools menu, click Internet Options.
c. Click Security.
d. Click Trusted Sites.
e. Click Sites.
f. Under Add this Web site to the zone, type http://ServerName. If you are not
using HTTPS for the default site, click to clear the Require server certification
(https:) for all sites in this zone check box.
g. Click Add.
h. Repeat step 7f and step 7g to add the http://localhost URL, and then click
Close.
Note This step enables you to start Internet Explorer and open either the localhost
or the network computer name of the server for both the Report Server application
and the Report Manager application.
*=======================================================*
8. Create role assignments that explicitly grant you access together with full
permissions. To do this, follow these steps: a. Start Internet Explorer together
with the Run as administrator option. To do this, click Start, click All Programs,
right-click Internet Explorer, and then click Run as administrator.
b. Open Report Manager. By default, the Report Manager URL is
http://ServerName/reports.
If you use SQL Server Express with Advanced Services SP2, the Report Manager URL is
http://ServerName/reports$sqlexpress. If you use a named instance of Reporting
Services, the Report Manager URL is http://ServerName/reports$InstanceName
c. In the Home dialog box, click Properties.
d. Click New Role Assignment.
e. Type a Windows user account name by using the following format:
Domain\User
f. Click to select the Content Manager check box.
g. Click OK.
h. In the Home dialog box, click Site Settings.
i. Click Configure site-wide security.
j. Click New Role Assignment.
k. Type a Windows user account by using the following format:
Domain\User
l. Click System Administrator.
m. Click OK.
n. Close Report Manager.
*=======================================================*
9. Use Internet Explorer without the Run as administrator option to reopen Report Manager.

NOTA: come in tutti i software server di Microsoft l’aspetto sicurezza è divenuto sempre più stringente. al termine della procedura l’installazione era terminata ma non funzionava un cavolo… C’era una policy di dominio che assegnata esplicitamente il right “logon as a batch jobs” a determinati gruppi di cui gli account utilizzati per far girare Reporting Service DEVONO fare parte….

Sono sempre più convinto che la security di Windows è troppo complessa…