Configure Report Server Initialization Problem (SQL 2005) Seeking for expert

I setup Report Server Virtual Directory, Report Manager Virtual Directory,
Windows Service identity, Web service identity, database setup, they all
working fine. When I click on [Inititialization] I get this error
----
Reporting Services Configuration Manager
--
There was an error while switching panels. The most likely cause is an error
retrieving WMI properties. The exception details are:
An error occurred when attempting to connect to the report server remote
procedure call (RPC) end point. Verify that the Report Server Windows
service is running, and then retry the operation.
Details:
The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
-----
Experts, please help me out, I'm stuck. Thank you very much!Server Status and Initialization has (x) on it, should initiazation solve
first or make server running first?
"news.microsoft.com" <Astroboy@.hotmail.com> wrote in message
news:%23oixTfCgGHA.4304@.TK2MSFTNGP05.phx.gbl...
>I setup Report Server Virtual Directory, Report Manager Virtual Directory,
>Windows Service identity, Web service identity, database setup, they all
>working fine. When I click on [Inititialization] I get this error
> ----
> Reporting Services Configuration Manager
> --
> There was an error while switching panels. The most likely cause is an
> error retrieving WMI properties. The exception details are:
> An error occurred when attempting to connect to the report server remote
> procedure call (RPC) end point. Verify that the Report Server Windows
> service is running, and then retry the operation.
> Details:
> The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
> -----
> Experts, please help me out, I'm stuck. Thank you very much!
>

CONFIGURE REPORT SERVER - Initialization button disabled / Key not valid for use in specified st

Hi There,

I am trying to setup a RS with Configure Report Server tool. (Windows 2003 Server / SQL 2005)

* All the items are with green check points except Encryption Keys (Blue exclamation point) and initialization wich is disabled. * Event log shows a lots of errors: Report Server Windows Service (SQL2K5) cannot connect to the report server database. * Browsing the Web Reports Server is returning the errror: Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

Can someone give me a ideea where to dig next?

Regards,

Toronto,

Canada

Which edition of RS are you using? The initialization button could be disabled because your edition doesn't support scale-out deployment. Does the disabled button show a check mark or a cross?

When you browse http://<server>/reportserver, are there any errors in the log file? Also review what's on the database setup panel. Perhaps try to reapply the settings on the panel. (The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.)

|||

EDITION:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Initialization button show a cross.

(The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.) - I totaly agree with you here - this is a paradox.

The database button is green with the check sign and the log is full of:

Report Server Windows Service (SQL2K5) cannot connect to the report server database.

Encryption Keys is blue with exclamation sign. Buttons backup and change disabled, delete and restore available.

Is there any way to post some screenshots of these?

Regards,

Toronto

|||

Scale-out is only supported for Developer, Enterprise and Evaluation edition, so you'd expect the Initialization to be disabled. (However, it should not be a cross.)

The database button is green means that the connection information is set in rsreportserver.config file. It is possible that the connection information is incorrect. Although, if you used the config tool to configure this panel, you should end up with a good connection information. Perhaps you can review http://msdn2.microsoft.com/en-us/ms159133.aspx. After reapplying the settings, check if your RS catalog databases is granted the correct permissions. Perhaps you can also check from the SQL profiler if your database is getting hit, and if the logons are denied.

|||

RS service is running under the same Windows account wich is designated for SQL server service. This account is part of Administrators group on OS and on SQL instance.

Does RS service require a distinct account?

I have loged in the server with the Windows account above mentioned.

I have accesse the RS database and the RSTemp database with no problem.

What else is missing?

Configure Report Server

I'm having problem with initialization tab on Configure Report Server

All tabs are checked and green , but when I click initialize I got this error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)

I don't know how to fix it...any ideas?

thanks

Nelson

Go to SQL Server Configuration Manager and check if SQL Server Reporting Service is "Running"

Shyam

|||

Yes, it is running, still same error then.

thanks

|||

Maybe these link will help you to identify the problem:

http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices_printversion.asp

Shyam

|||

THANK YOU...help allot.....I read that need to delete the key and I did and works fine.

thank you

|||Can you please mark my post as answer?