Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am at a loss. I posted this on SO, but think this is probably a better place.

I have searched high and low and don't know what to do. I am running SQL Server Web Edition on Server 2008, which only supports local databases. I am trying to connect to localhost, but when I test my connection, I get this error.

The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services.

The DB was upgraded from SQL Express and when I select @@version, it says it's Web Edition. I've tried rebooting and that seemed to fix it, but only for a little while.

share|improve this question
add comment

1 Answer

This is the goofiest thing I've ever seen. It turns out that it maybe working after all. I was finally able to view a report. Unfortunately I spent all time with the Data Source and assumed the error I was seeing would mean it doesn't work.

Here's the things that threw me off in the Data Source screen

  1. If I made any change at all to the connection string, I would get an error that my password is invalid. There was no ability to re-test the connection and Apply didn't work.
  2. If I do Test Connection I get the error about the version only supporting local databases and can make no changes.
  3. I chose Prompt for Password and put the same credentials that I had in the data source under "Credentials Stored on Report Server". The report worked. Then I went back to the datasource and put those credentials in there and choose "Stored on Server" and was able to "Apply".

Ugggh.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.