SSRS Can not Open Connection to report server

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

The Solution is the re-configure SSRS using command
1) Open Command Prompt with privileges
2) Run
rsconfig -c -s SPSVR -d reportserverName -a Windows -u AD\administrator -p myp@ssw0rd

SharePoint 2010 Integration With SSRS

When we have to integrate SharePoint 2010 with SSRS, it is few steps away from the fun.

1) First we have to download and install SSRS plug-in for SharePoint 2010

2) Go to Central Administration --> General Application settings --> Reporting Services

3) Set "Report Server URL" and Account Credentials

 

4)  Verify Status of configuration

5) Go to Site Collection features  --> Activate "Reporting Server Integration Feature"

6) Go to Edit page and insert "WebPart"

7) Configure a SSRS Report and have data

That's all :)