locked
CONFIGURE REPORT SERVER - Initialization button disabled / Key not valid for use in specified state? RRS feed

  • Question

  • Hi There,

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

    1. * All the items are with green check points except Encryption Keys (Blue exclamation point) and initialization wich is disabled.
    2. * Event log shows a lots of errors: Report Server Windows Service (SQL2K5) cannot connect to the report server database.
    3. * 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

    Wednesday, May 31, 2006 6:49 PM

Answers

  • 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.)

    Wednesday, May 31, 2006 10:04 PM

All replies

  • 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.)

    Wednesday, May 31, 2006 10:04 PM
  • 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

     

     

    Thursday, June 1, 2006 2:52 PM
  • 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.

    Thursday, June 1, 2006 6:57 PM
  • 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?

     

    Thursday, June 1, 2006 7:32 PM
  • Greetings,

      IF your Database Instance is a Named Instance e.g. Development-01\SQL2005 THEN
          BEGIN
                Be sure the "Server Name:" field of the "Reporting Services Configuration Manager"
                                                                                   ->  "Database Setup"
                                                                                         -> "Database Connection"
                is of the form {MachineName}\{InstanceName} as in the example above.
          END
      ELSE
          BEGIN
                Be sure the "Server Name:" field of the "Reporting Services Configuration Manager"
                                                                                   ->  "Database Setup"
                                                                                         -> "Database Connection"
                is ".\" i.e. not the MachineName
         END

    Hope that helps.
    David
    Tuesday, March 31, 2009 10:44 PM