Integrating Sharepoint 2010 and SQL Reporting Services 2008

There are only 6 main steps to achieve this task assuming you already have an instance of SQL Server Reporting Services and Sharepoint 2010.

I had created this starting from a clean installation of SQL Reporting Services so this guide will discuss the steps on configuring your SQL Reporting Services 2008 for integration with Sharepoint 2010.

Step 1 : Configuring SQL Reporting Services – Web Service URL.

Simply go to Reporting Services Configuration Manager and choose Web Service URL and populate the following needed information. The fields are named properly so I guess theres no need for further explanation.  What this does is that it configures the IIS for you depending on what Virtual Directory names you had declared

Step by Step SharePoint Server 2010 Installation Guide

Introduction

This article provides a step by step Installation and Prerequisites Software requirement for SharePoint server 2010 beta installation.
Finally! My long awaited SharePoint Server 2010 beta is ready for download… (http://technet.microsoft.com/en-us/evalcenter/ee391660.aspx) I installed it successfully on VMWARE Workstation, alternatively you can use VirtualBox.
Given below is a step by step Installation guide.

List of Prerequisites Software

1. Windows server 2008 with SP 2 / Windows 7 / Vista (All OS must be 64bit)
2. Windows 2008 R2 and Windows Server 2008 KB971831
3. WCF Fix article for Windows 2008 R2 and Windows 7 KB976462
4. Microsoft SQL Server 2008 Native Client
5. Microsoft "Geneva" Framework Runtime
6. Microsoft Sync Framework Runtime v1.0 (x64)
7. Microsoft Chart Controls for Microsoft .NET Framework 3.5
8. Microsoft SQL Server 2008 Analysis Services ADOMD.NET
9. PowerShell V2 RTM
10. SQL Server 2008 SP1
11. .NET Framework 3.5 Service Pack 1 (Full Package) KB959209 KB967190