Quick Guide on how to install Reporting Services on its own server/cluster in SharePoint Integration Mode without using Kerberos

Install SQL Server 2005 – Reporting Services Only Install SQL Server Service Pack 2 Install Sharepoint (as WFE)- SKU (Enterprise Edition, Standard,etc..) has to match the other SKUs in the farm Run the Sharepoint Server Configuration (do not add central admin unless you want to) – Not sure if this step is needed but can’t hurt…

4

Transparent Images in Reporting Services

If you’ve been trying to put a transparent image into reporting services and have not been able to make the background transparent i share your pain. Luckily i found a solution. 1. Place a rectangle where you would place the image 2. Place the image inside the rectangle 3. That’s actually it. Simple and not…

5

Automating Report Deployment with Reporting Services in SharePoint Integration Mode

Automating Report Deployment in Reporting Services can be challenging.  SharePoint offers many modes of deployment of files.  Unfortunately the out of the box deployment for SharePoint does not allow for automatic hook up of data sources.  So you can deploy the rdl’s using SPFile upload functions on the SPWeb of your choice but those rdls will exist without…

11