kaborka


I've been unsuccessful getting Reporting Services 2005 to work after reinstalling SQL 2005. The RS service cannot connect to its database, as reported in the Event Log.  If I visit http://localhost/Reports, I get the error "Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B) (rsRPCError)"

I've used the RS Config Mgr to create a fresh database for it named SSRS (and SSRSTembDB), and it is set to use Service Credentials in the db connection. The RS service is running using the same admin account as MSSQL, .\SQLExec. I have confirmed that .\SQLExec is in the RSExecRole role in the SSRS database.

When I created the SSRS database, the Config Mgr had a green check for every step except the last. For "Setting Connection Info for the Reporting Server" there was a yellow '!', with the explanation, "Although saving the database connection succeeded, the report server cannot access internal information about this deployment to determine if the current configuration is valid for this edition. ..."

I examined rsreportserver.config to look for any issues. The <dsn> element has an encrypted string, the <ConnectionType> element says "Default", and the logon elements are empty.   I could not find the db names, SSRS and SSRSTempDB, anywhere in the file.  Where are these kept   I don't know what else to look for.

Also, in RS Config Mgr, the 'Encryption Keys' page has a blue '!', and only the 'Restore' and 'Delete' buttons are enabled. The 'Initialization' page has a red 'X'. The local RS is not listed (the grid is empty), and clicking the 'Initialize' button does nothing.

How can I diagnose and fix this installation



Re: "...report server cannot access internal information..."

JamesHuff


Check and see if you had changed your password on your Administrator account for your server after installing Reporting Services. This will cause the problem if you have.





Re: "...report server cannot access internal information..."

kaborka

I posted the solution in another thread. See:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1258874&SiteID=1





Re: "...report server cannot access internal information..."

Ariel Novelli

Hello!

I got the exactly same problem. Can you tell me where exactly is the solution

Thanks!

Ariel





Re: "...report server cannot access internal information..."

kaborka

From my other thread:

"Further searching revealed this may have to do with a crypto key left over from the prior installation, found under "C:\Documents and Settings\SQLExec\Application Data\Microsoft\Crypto\RSA" in a file matching "1aedd7b5699f3d6a88e354100b596aae*" Advice was to delete this file..."

When looking for the key file, replace "SQLExec" by the login name used by the SSRS service -- that was the login I used when installing. Once you find the keyfile, this sequence worked for me:

"I uninstalled SSRS, deleted the old SSRS databases, deleted the key file, reinstalled SSRS, reapplied SP2. After doing this, each step in the Reporting Services Config Mgr then worked correctly."