Solved

MS SQL Reporting Services 2005 upgrade to 2008 issues

Posted on 2010-08-25
2
1,194 Views
Last Modified: 2012-06-27
So we have a server that run MSSQL Server 2005 w/ reporting services. This has been working fine but recently my boss made a report using the 2008 BIDS who's reports aren't compatible with 2005 Reporting Services I guess.  So on another server I decide to install SSRS 2008 and just point it to the report database on the 2005 server. Everything appeared to go fine but I can't connect on either server now! On the 2005 box I am now getting this error when trying to pull up a report in the browser:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '147'. The expected version is 'C.0.8.54'. To continue, update the version of the report server database and verify access rights.

And the 2005 server's event log is screaming:

Report Server (S1) cannot connect to the report server database.

The 2008 server's event log has these 2 errors:

Report Server (REPORTSERVER) cannot connect to the report server database.
and
Report Server Windows Service (REPORTSERVER) has not been granted access to the catalog content.

I'm not quite sure what is going on here and I'm not quite sure where to start either. I am going to be sitting by my computer here ready to provide additional information if needed. Thanks a lot for any help!
0
Comment
Question by:STONEPLASTICS
2 Comments
 
LVL 4

Accepted Solution

by:
jindalankush earned 500 total points
ID: 33522569
SSRS 20008 are not compatible with sql 2005.
u have to  update ur database from sql 2005 to 2008
0
 

Author Closing Comment

by:STONEPLASTICS
ID: 33522842
Yeah thanks. Got it figured out here
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Dynamics crm 2011 8 44
Date conversion in sql server 2012 6 26
Row-Level Security 2 19
SQL Server creating a temp table 7 37
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now