So I just spent quite a bit of time on another issue, that seems like there is no solution to and you can’t seem to find info on anywhere.

Basically, you assume when doing database setup that you just grab the default database you want to run reports off of and click ok.  Well that is what I did, then it came back with an error.  The error said that there wasn’t the correct role permissions for the role “RSExecRole.” Anyway, I finally found something similar here and assigned the role and correct permissions and moved on to the next error.  Well there were 2 errors one was a wrong connection string and the second was incorrect user.  Well neither was coming up in a Google search.  Finally, someone heard me complaining enough to myself to come help.  They helped point out the wrong connection string.  Well when someone is in my office others get curios.  Well one of the guys that seems to have done everything walks by and asks what’s going on we tell him the problem and boom he solves it in 2 minutes.

Here is how and why he solved it.

1) Clicked on the Database Setup tab
2) Clicked New…
3) Clicked Ok
4) Click Apply
5) Click Ok

That was it.

Here is the why.

In order for the report services to work it needs its own database with database with certain things in it.  Without this database it doesn’t work at all.  So you must create this database during the configuration.  The message at the top of that page says this, but is so “Technical”ish that it doesn’t make much sense at all.