SQL Server v.Next (Denali) : CTP3 Installation Walk-Through
July 12th, 201114
SQL Server v.Next (Denali) : CTP3 Installation Walk-Through
July 12th, 201114

In case you missed my previous post, you can now download CTP3. The delivery mechanism this time is a little different. Instead of downloading an ISO, you download a very small EXE, two .box files, and an HTML file that currently contains a set of links that aren't fully functional. You run the EXE by double-clicking it, and it extracts the box files into a folder in the same location called SQLFULL_x64_ENU:


Don't do what I did. In order to easily expose the CTP to all of my virtual machines (including Server Core), I took the four files and made an ISO file. When I tried the above process using the ISO file exposed to the VM as a DVD drive, it ran through the unloading process, then went away silently. I tried this a couple of times before I realized what was going on – Windows will not let you write output to a "DVD" – and that the unloading was being attempted in place (and I haven't examined the exe to determine if there are any arguments you could pass to tell it where to send the output – I tried /x, which is the argument used for cumulative updates, and that didn't work). I'm kind of surprised that there isn't a prompt for output location, and I'm absolutely amazed that the unloading process whistles along happily – with no error message or any indication whatsoever that it couldn't create the output folder or extract the files there.

Anyway, now I am off to make an ISO of the *result* of that operation. The lesson here is, copy the four files to a location where you have at least 6GB of free space, since you won't be able to run the command from one location and have it extract the contents to another.

[Also, please be sure to check out my notes on operating system support and prerequisites; also, consider installing Denali in a virtual machine, especially if you are worried about compatibility with your existing applications (Visual Studio, BIDS, etc.) or other instances of SQL Server.]

Once you have done that and you have your SQLFULL_x64_ENU folder ready, double-click SETUP.EXE. You will eventually be right back in to the SQL Server Installation Center you know and love. Click on the Installation tab (for any of the following screen shots, click on them to embiggen in a new window):


Then click on "New SQL Server stand-alone installation or add features to an existing installation" – you'll go through Setup Support Rules, which will hopefully all pass with flying colors:

(Remember to not close the Installation Center dialog until after setup is complete. This window needs to remain open as it keeps the temporary folder used by setup, though it can be minimized. See Connect #388671 for more details.)

Click OK. Next you will have the choice to enter a product key or choose a free edition. It is pre-selected to Evaluation edition:

Click Next. Check the box that says you accept the license terms. I would never suggest to not read them from start to finish, but I'll let you guess how long I spend on this screen. (I usually do uncheck the box about sending feature usage data to Microsoft.)

Click Next. The Install Setup Files dialog checks for updated setup files; is it possible this is the first clue that we are going to have automatic slipstreaming in Denali? I hope so:

Then shortly after my first "SQUEEEEE" moment, I get my first "BOOOOO" moment:

Click OK. Sheepishly. In fact, I implore you to click OK sheepishly. 🙂

Now we see the Setup Support Rules dialog. Click Next unless you want to see the details (or any of the rules failed):

Next we choose the Installation Type. Since this is my first taste of CTP3, I will choose the [Perform a new installation of SQL Server "Denali" CTP3] option:

Click Next. n the Setup Role tab I'm going to keep things simple and choose the [SQL Server Feature Installation] option:

Click Next. On the Feature Selection tab, again for simplicity, I'm going to choose Database Engine Services, Books Online Components, and both Management Tools options (see more about Books Online toward the end of this post). I'm tempted to add DQS and Distributed Replay here, but my first instance is going to be pretty bare bones (note that if you have BIDS, Visual Studio, or Juneau from a previous CTP installed, you'll want to select as many of those options that seem relevant – most importantly Business Intelligence Development Studio):

Click Next. We'll let the Installation Rules succeed (unless you are unlucky):

Click Next. Now we select our instance name. I'm way beyond the ability to choose a default instance here, and I'm not all that creative:

Click Next. Simple summary screen showing disk space requirements. I clearly need to learn to build bigger VMs:

Click Next. You can change the service accounts and startup type on the Server Configuration tab. For local testing instances I rarely find it necessary to do this, especially during setup, since they can be configured later if need be. I also don't touch the Collation tab, leaving the default in place (though for pure development environments I will probably be getting more in the habit of switching to case sensitive):

Click Next. On the Database Engine Configuration screen, you can change to mixed authentication, add an sa password, and add yourself and other Windows accounts as SQL Server Administrators:

And on the Data Directories tab, you could change the location for new databases, tempdb and backups. On a normal system I would be changing these appropriately, but since I am on a VM with a single C:\ drive, I'm a little limited to what I can do to spread this I/O around. Thankfully I am not planning to do any heavy activity on my workstation:

I'm not going to use FILESTREAM for this instance, once again for simplicity, so I'm going to leave this tab alone. Click Next. 

The Error Reporting dialog allows you to choose whether to send error reports to Microsoft. I'm going to leave this checked (though I unchecked it earlier in the beta cycle because I assumed there would be a lot more "that's already on the books to get fixed" type of exceptions):

Click Next. We get another rules screen, this time the Installation Configuration Rules screen. These might fail if you're still using FAT32, for example, so I can't imagine too many people will get blocked here:

Click Next. Finally we are at a summary screen which lists all of the options we've chosen and what SQL Server setup thinks it's going to try to do:

Click Install. Progress is indicated (you'll see various status message whiz by, faster than you can read them, for about 10 minutes – or less if you are on an SSD):

And finally, completion:

Click OK, click Close, and sheepishly (yes, sheepishly) reboot. Now you can launch Management Studio and start sniffing around:

Note that if you start sniffing around before you've rebooted, you may get some strange errors when trying to connect:

I know you're impatient, but just reboot. I also noticed that I had to manually start the service for the new CTP3 instance, even though it had been set to start automatically. Not sure if I just didn't wait long enough, but starting it manually worked fine.

Finally, I am finding the following error occurs when I try to launch a new query by right-clicking a database or server in Object Explorer and selecting New Query (if I try to modify an existing stored procedure, the dialog is identical, but it's a yellow exclamation point instead of a red x):

The error dialog is only slightly different (an additional top-level error message, and now it isn't an error, it's an informational dialog) if I try File > New >Database Engine Query:

And the error is once again an error, but still a slightly different dialog (I can no longer copy the text) if I use Ctrl + N or try to open an existing .sql file using File/Open:

For searchy goodness, here is the text of the error message:

TITLE: Microsoft SQL Server Management Studio
Failed to create new SQL Server script.
Method not found: 'System.Collections.Generic.List`1<System.Object> Microsoft.SqlServer.Management.UI.VSIntegration.GenericUtilityView.get_OpenedEditors()'. (mscorlib)

I tried to fix this by re-applying Visual Studio Service Pack 1, as I had recommended in my previous post (once again, do as I say, not as I do). The SP1 update package complained about a missing silverlight_sdk.msi:

Microsoft Silverlight 4 SDK

The feature you are trying to use is on a network resource that is unavailable.

Someone should file a bug on this; the exclusion of this MSI file is especially annoying in this case because I don't care about the Silverlight SDK. Anyway, the fix: download the Silverlight 4 Tools, run the exe from a command line with the /x argument, specify a folder when prompted, and then you can point the SP1 installer at that folder. What a mess. And it gets even worse; I next got a similar complaint about WCF RIA Services V1.0 SP1 – like I'd know where to get that even if I knew what it was. One time, okay; I wasn't going to repeat this for who-knows-how-many files. So the real fix is: download the whole VS2010 SP1 ISO, mount it or extract it using your favorite utility, and point SP1 setup at that folder whenever prompted. Ugh. Again, what an absolute mess – and yes, yet another reboot. And for whatever reason, the re-application of SP1 took longer than the whole Denali install, including the time to take screen shots of every single dialog!

And I still have the same issue when launch a new query. *sigh*

(This only happened on the machine where I left CTP1 installed – because I wanted to easily compare DMVs and other things. I guess that plan is a bust.)

For some information about installing Books Online locally, in case I led you to believe that selecting the box above really installed Books Online, see this blog post from Geoff Hiten (@SQLCraftsman):


Stay tuned for more posts about other tools (e.g. Juneau), changes to Books Online, and CTP3 engine features as I discover them.


By: Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.

14 Responses

  1. Misty says:

    actually Juneau doesn't even list in the box; once web pi starts.  just a note indicating software is not compatible…I am oing to pull all my hair out

  2. Misty says:

    Any way to install Juneau without the Web PI …???  I have spent three days pouring over a "compatibility issue"….it says my operating system is not compatible on an XPsp3 machine AND win7 machine….
    Any help or guidance on this would be helpful

  3. Piyush Bajaj says:

    Its really a nice one.
    I have also posted a similar article on this:

  4. RonClarke says:

    Thanks!  After twice watching the install "die silently", I found this.  I had established read-only network share for multiple installs and ran into the folder expansion issue without knowing it.

  5. Simon Lidberg says:

    The files get extracted to C:\Users\<username>\AppData\Local\Temp\<guid>\ or wherever your %temp% variable points to

  6. AaronBertrand says:

    Phillip, have you looked at the setup logs? By default they should be in a folder C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\ … take a look at Summary.txt in the root folder, it may have enough detail to determine what is going wrong, or you may have to dig into the \yyyymmdd_hhmmss\ folder to get more detail from the more verbose log files.

  7. Phillip Ulberg says:

    I cannot get the setup to continue past the "Install setup files" screen.  The progress bar goes by a few times and the window closes, no error.  I am running Server 2008 R2 Ent.

  8. Slavo Furman says:

    thanks for article. 😉
    Juneau is available as a separate download via Web Platform Installer 3.0. Download is here:  http://www.microsoft.com/web/gallery/install.aspx?appid=JUNEAU10
    You can reach this via: http://msdn.com/data/tools.aspx
    btw, Juneau apparently can be installed without installing Denali CTP3 first (it download/install all needed Denali prerequisities).

  9. Davide Mauri says:

    Multi-Dimensional allows you to use MDX (just like the good-old SQL Server 2005/2008), while the Tabular will allow you to use DAX (like PowerPivot).
    The two engine are totally different so you have to choose one, ore install two instances of SSAS to use both

  10. Sethu Srinivasan [MSFT] says:

    Aaron, I have posted blog entry on installing Denali CTP3 on Server Core. It might be useful for our customers working on Server core as their OS edition. http://sethusrinivasan.wordpress.com/2011/07/12/sql-server-denali-ctp3-on-windows-2008-r2-server-core/

  11. AaronBertrand says:

    Sorry Kenneth, I am not sure on the licensing/instance details about those two models. I assumed they fell under the same BISM umbrella as well.

  12. Kenneth Franklin says:

    Do you know the significance of the two SSAS server modes: Multi-Dimensional & Tabular? The install documentation indicates that they are mutually-exclusive and installing both modes requires two instances. I have been under the impression that BISM was all inclusive of both modes. What do I gain/lose by selecting one over the other?

  13. Shawn Melton says:

    I'm looking forward to trying it on Server Core, have not played much with that OS edition anyway…so it should all be fun.

  14. Louis Davidson says:

    Nice walkthrough. Will make use of it tonight when I get time to install the bits I just finished downloading!