Sharepoint and SSRS...I won

Finally figured it out and have the SSRS running on one of our WFE's. It should be noted that we have a medium farm for about 70 users. We have 2 WFE's that are load balanced, hitting a SQL cluster. Our Farm is pretty underused...OK it is way overkill for the amount of users we have and the the amount of users that are actually using it. The machines are beasts and we averaging something like 80 distinct users and 375 hits a day.

I figured out that I had to give my users distinct rights to the reporting services folder. Thanks SSRS for the help

Sharepoint and SSRS

Sometimes you just have to wonder why it is not easier. I mean what I want to do should not be difficult...I just want SSRS to be on WFE in my Farm. Should be easy right. It took me a while in QA to get it installed because it would not connect through Sharepoint. I struggled and struggled but it would not bring up the Server Defaults on the Central Admin. Finally this solved it... http://blogs.msdn.com/feldman/archive/2007/11/18/quick-guide-on-how-to-install-reporting-services-on-its-own-server-cluster-in-sharepoint-integration-mode-without-using-kerberos.aspx . Today we are moving SSRS for Sharepoint into production. But where???? Sql cluster not really where I want it since I will need an IIS server on the SQL box. Why not the WFE. So far so good except when applying SP 2 I am going to have to do a reboot. Once this is done lets up it works pretty quick and easy.