SQL Server ‘Denali’ CTP3 Install Experience
Posted by denglishbi on July 14, 2011
This week during the Microsoft Worldwide Partner (WPC) 2011 Conference, Microsoft released the CTP3 public release of the upcoming SQL Server codenamed ‘Denali’ product. This release is for the most part feature complete and now includes some of the additional BI components that were not part of the CTP1 release that came out late last year like Data Quality Services (DQS), Analysis Services Tabular mode, Reporting Services as a SharePoint Shared Service, Project ‘Crescent’ the new Silverlight based reporting tool, SSRS Data Alerts, new PowerPivot and DAX enhancements, and much more.
Here is a walkthrough of the installation setup which contains a couple of new changes based on the CTP1, SQL Server ‘Denali’ SQL11 CTP1 Install Experience, setup (particularly for the Analysis Services and Reporting Services sections):
One thing to remember here now is that with Analysis Services we have two options, the Multidimensional and the Tabular (including the PowerPivot SharePoint option). So if you are building a standalone sandbox test environment you can have up to three instances of Analysis Services running (one for each type of deployment mode). This is probably not recommended (especially from the memory management side of things), but this is what you would see.
In the next few posts I will be diving into some of the new features and items in particular with project ‘Crescent’, PowerPivot v2 (lots of cool new stuff), SSRS SharePoint integration changes, and the new BISM Tabular (the new enterprise/corporate level PowerPivot version).
Here are some resource links to check out in the meantime:
- SQL Server code-named “Denali” Resource Center
- What’s New (SQL Server “Denali”)
- SQL Server Developer Tools, Codename “Juneau”…
- Project Crescent Overview
- Microsoft® SQL Server® code name ‘Denali’ CTP 3 Feature Pack
- Tutorials for SQL Server ‘Denali’
- Samples for SQL Server Denali CTP3 on CodePlex
The build number for the CTP3 release is 11.0.1440.19.
PDF version of blog posting