l forget sometimes that installing SQL Server isn’t that straightforward, in part because it is now so much more than the database engine, that was SQL Server 7 when I started. I also think its important that you understand the choices you are making when installing it although many of these can be undone by reconfiguration later on. I was wondering how to make this easier and I decided that my usual approach of recording an installation might not be that helpful so I have made a PowerPoint deck instead and stuck it on my SkyDrive account.
The deck covers four separate tasks to help you put together a complete Denali based BI demo on one server:
Part 1. the install everything to the default instance, so the database engine plus all the BI stuff, specifically:
- Analysis services in its new tabular mode
- Reporting Services in SharePoint integrated mode
Part 2. Install SharePoint and then install SQL Server Analysis Services in SharePoint integrated mode to its named instance of PowerPivot
Part 3. Another installation of Analysis Services this time in multidimensional (OLAP) mode to another instance of SQL Server.
Part 4. Setup reporting services in SharePoint integrated mode. This is done in a very different way to previous version of SQL Server; With Denali Reporting Services is an application service in SharePoint
I have included screenshots for every step of the process and annotated these in the notes at the bottom of each slide and you should end up with this in management studio..
plus having PowerPivot working in SharePoint as well as integrated reporting Services.
If you are trying that out for yourself then you’ll need:
- An evaluation copy of Windows Server 2008 R2 (this has sp1 included) for this if you haven’t got a TechNet subscription.
- SQL Server Denali ctp 3
- An evaluation copy SharePoint 2010 if you haven’t got that TechNet subscription plus SharePoint 2010 service pack 1
Finally you might need some data , and reports to see all of this working and that’s on Codeplex.