Today I felt the need to step outside of SharePoint a little and wander over to the SQL consoles and learn something new. Bottom line: works the same, just more reliable. SSRS 2008 R2 seems to me to be roughly equal on config options to what we had for SQL 2005. Similar wizard to get it created, similar Central Admin link to give the URL, even the menu names match.
However, the whole thing “feels” more reliable. Once complete I can clearly see the SSRS features on the Site Settings menu. Next, I need to learn BIDS (Business Intelligence Development Studio) to create a report (RDL) and try uploading it for rendering.
- Open “Reporting Services Configuration Manager” and follow wizard steps to create SSRS on SQL backend.
- When asked use “SharePoint integrated” mode.
- It will make a SQL database and IIS website. I used my main SP web application (http://sp2010) so that final URL is http://sp2010/ReportServer/
- Open “SharePoint Central Administration”
- Navigate to “General Application Settings > Reporting Services Integration”
- Type that same URL, choose “Windows Authentication”, and provide a user account.
- I’m using DEMOadmin for everything which is not a best practice, but works in DEV systems to avoid any “access denied” messages.
- Create desktop shortcut to “C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportServerReportBuilderReportBuilder_3_0_0_0.application”
- Click the desktop icon for first install
- Enjoy the Report Builder 3.0 application to create .RDL and upload to SharePoint