reporting service website not working

Question

question

muk asked Jun 28, '12

reporting service website not working

hello, I am having a problem with my reporting services. everything was configured correctly and installed before I started at this company. now when I try to access the report server or deploy reports to it i get this error: The report server installation is not initialized. (rsReportServerNotActivated) HELP!!!! What did I break?!

sql-server-2008 sql-server-2008-r2 reporting_services configuration

7

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg commented · Jun 28, 2012 at 07:27 PM

@muk Probably nothing. The problem is probably caused by the fact that the reporting service is not running. Go to the box hosting SSRS, **Start** -> **Run** -> **services.msc /s** Check the status of the **SQL Server Reporting Services**. Amusingly, one of the reasons that it does not start one day is simply caused by the fact that the AD account used to run it has become disabled or simply changed its password.

1 ·

Oleg commented · Jun 28, 2012 at 07:50 PM

@muk Yes, on the server which is hosting the database used by SSRS

1 ·

Pavel Pawlowski commented · Jun 28, 2012 at 08:13 PM

You should check server on which you should be running the reporting services. SSRS Database can be even hosted by another server.

1 ·

SirSQL commented · Jun 28, 2012 at 08:42 PM

Is it able to access the database? Did you open up the reporting services configuration manager and ensure that connection can be made? Have you attempted to connect to reporting services from the server running the reporting services service to eliminate possible issues around local host files or DNS changes? Have you taken a look at the reporting services log files and checked for errors or issues there?

1 ·

muk commented · Jun 28, 2012 at 07:30 PM

Oleg, thank you for your response. I did this and I do not even see SQL Server Reporting Services on the list. I checked this on my local machine. Do I need to do this on the server?

0 ·

muk commented · Jun 28, 2012 at 08:37 PM

yes it was running, I restarted it and I am still getting the error :(

0 ·

muk commented · Jun 28, 2012 at 08:45 PM

Yes the database is accessible. I tested the connection in RSCM. I have not tried yet to connect through the server. I did get this error message on the server: Report Server (PORTAL_TEST_2010) cannot connect to the report server database. Report Server (PORTAL_TEST_2010) has not been granted access to the catalog content.

0 ·

Answer 1 · 2012-06-28T20:43:51Z

Pavel Pawlowski answered Jun 28, '12

From the error code, it seems, that your report server is not properly configured and initialized. Use the Reporting Services Configuration Manager to connect to that instance and verify, that the service is connected to correct SSRS database and that Report Manager and Report Service URLs are properly configured. You can follow this MSDN article: [Initialize a Report Server][1] [1]: http://msdn.microsoft.com/en-us/library/ms157133.aspx

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

muk commented · Jun 28, 2012 at 08:54 PM

I fixed it! I ran the process in this article http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/efcf30a1-7091-42ae-9a28-df017f950f2e It was a problem with the encryption key. I had to delete all encryption keys through the configuration manager and then reconfigure the database settings. Thanks Pavel!!!!!!

0 ·

question