We are havign an issue with report builder installation in Sharepoint 2010 running SQL 2008 R2 standard with Report Services feature installed.
When we go to the http://servername:80/ReportServer
, we always get error:
"The report server installation is not initialized. (rsReportServerNotActivate
Reporting Services feature was also installed on the main sql server and database was configured with sharepoint integrated option.
We configured the Reporting Services using the Reporting Services Configuration manager:
We gave it a valid service account that has administrator rights on domain and full access on the sql server.
Web Service URL:
Web Service URL was activated without SSL security.
From the Web Front end, we point it to the SQL server and it's database. It passes the "test Connection". And also the login credentials are valid on the domain and has full rights on the SQL database.
Report Manager URL:
Is standard and activated.
: Not used.
Execution Account, Encryption keys and Scale-Out deployment: Not used/nothingchanged.
The service SQL Server Reporting Service is started.
I read other posts and there solutions were:
* Start -> All programs -> Sql server 2008 -> Reporting Services->Configuration -> Reporting Server Manager and Choose Initialaize button
- We don't see the "initialize" button anywhere.
Anyone can give me specific steps to follow to initialize the installation?