troubleshooting Question

Report server installation is not initialized. (rsReportServerNotActivated)

Avatar of trembe
trembe asked on
Microsoft SharePointSSRS
9 Comments1 Solution8878 ViewsLast Modified:
Hi,

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 or http://servername:80/Reports, we always get error:
"The report server installation is not initialized. (rsReportServerNotActivated)"

Our setup: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:

Service Account: 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.

Database:
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.

E-Mail settings: 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?

Thank you,

Erik
ASKER CERTIFIED SOLUTION
trembe

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros