Hello - Here's a little background:
I recently had a server crash; it had to be rebuilt. Part of what that server did was host the SQL Server Reporting Services. It connected to another server that had the report database.
When I reinstalled SQL Express 2005 on the server (including SSRS), I got to the configuration step of connecting to the remote database and I got an error stating that this edition of SSRS would not access a remote database.
So I decided to just install SSRS on the server that has the database. I got further with this, but now I have another error. Everything in the Configure Report Server dialog was successful with one problem. In the Database Setup section, I got this error:
I then try to Browse in IIS ReportServer and I get this:
The database existed prior to all of this and SSRS was working great. Obviously I've installed a different edition of SSRS that's not compatible with the database.
I'm not very familiar with SQL, SSRS, or IIS, so I'm not really sure how to get the correct database / SSRS matchup. Any assistance would be greatly appreciated.
Win Server 2003 SP2
SQL Server 2005 (9.0.3353)
I'm sure more information is required so please ask.