Implementing SQL Server 2005 Reporting Services with SharePoint 2007 - Dashboards (Part I)

One of the very handy ways to get your dashboards running on SharePoint is to use the friendly SQL Server reporting services engine provided with SQL Server 2005. It is important that you have the following prerequisities before you attempt the game!

You need to have:

• MS SQL Server 2005 with SP2 (mandatory) [installed]
• MS Office SharePoint Server 2007 [installed]
• MS SQL Server Reporting Services Web Parts for SharePoint downloadable here

Step I: Installing SQL Server 2005 Reporting Services

1. Insert the Microsoft SQL Server 2005 product CD into the CD Drive.
2. Click Start, point to Settings, and then click Control Panel.
3. In Control Panel, double-click Add or Remove Programs.
4. In Add or Remove Programs, click Microsoft SQL Server 2005, and then click Change.
5. On the Component Selection page, expand SQL Server 2005 instances, select MSSQLSERVER, and then click Next.
6. On the Feature Maintenance page, select Reporting Services, and then click Next.
7. The Microsoft SQL Server Installation Wizard starts.
8. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.
9. On the System Configuration Check page, click Next.
10. On the Change or Remove Instance page, click Change Installed Components.
11. On the Feature Selection page, make sure that Reporting Services will be installed on the local hard disk drive, and then click Next.
12. On the Ready to Update page, click Install.
13. On the Setup Progress page, click Next.
14. On the Completing Microsoft SQL Server 2005 Setup page, click Finish.

Part II coming soon...!