System Center Operations Manager

Broadcasting live from Redmond, Washington

How to Install SQL 2005 Reporting on Windows Server 2008

A new paper has been posted on the OpsManJam site on the pre-requisites for SQL 2005 Reporting on Windows Server 2008.
Published Friday, October 03, 2008 11:34 PM by chrfox

Comments

 

How to Install SQL 2005 Reporting on Windows Server 2008 | Windows 2008 Security said:

October 3, 2008 10:57 PM
 

Lapett said:

I have installed Win2008 (x64) with SQL 2005 Ent SP2 (x64) and use this for SCOM Databases.

The RMS server and Management Servers running Win2003 Server.

I will use one Managament server for SCOM Reporting and have installed IIS and SQL Reporting Services SP2.

I have run Reporting Services Configurator Manager and all steps are green. Report Site (http://servername/Reports) is OK.

But when I tried to install SCOM Reporting the installastion stop after it try to connect the RMS server. I got the folliwing message:

"Could not verify if the current user is in Sysadmin role. The user running setup is not in sysadmin role in the OM database or we are unable to connect to OM database, please verify if you can connect to OM database from this computer"

The user account that I use are local administrator on both the SQL server and the OM Reporting server. The account are "owner" to alle OM databases and are Sysadmin to.

Does anyone have some suggestion what I should do?

October 22, 2008 4:13 PM
 

bruno said:

hi

Unfortunately, I got several problems of the same kind with 64bits on windows 2008. Even though i gave accounts domain admin, local admin, sysadmin rights on Scom and Sql servers, i get 'account verification failed'. I think this is due to some problem with 64 bits as i don't have any problem on 32 bits platform (i think this is not due to the account but to the check made by the application, as whatever you put there will fail anyway). I checked several times that everything has been configured properly but it won't install. As it works on 32 bits i think a call might be addressed to 32bits subsystem instead of 64bits and fails for this reason. Unfortunately the verbose logs and process monitor do not bring any info about the failure.

November 2, 2008 2:21 PM
 

The MOM/Operations Manager Callback Resource Site said:

The first thing you’ll probably want to do in preparation for your callback is gather up any relevant

March 24, 2009 4:36 PM
New Comments to this post are disabled

This Blog

Syndication


© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker