July 12, 2011 | SQL Server

SQL Server v.Next (Denali) : CTP3 is here!!!

The CTP3 of SQL Server Code-Named "Denali" is now available. You can download the bits here:

 
<a href="http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx" title="http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx" target="_blank">Download SQL Server "Denali" CTP3</a>
<i>(You will need to use File Transfer Manager on Windows, and a Java applet on Mac OS.)  </i>

If you are just interested in the Express version, you can go here (no FTM required):

Download SQL Server "Denali" Express CTP3

There were release notes available last week, but they were taken down when they became too publicized. They have been made available again:

http://social.technet.microsoft.com/wiki/contents/articles/3711.aspx

Right now, after the download starts, you will see this:

 

But that link just leads to the SQL Server Learning Center, which still only has information on 2005, 2008 and 2008 R2. 

In the meantime, I've assembled my own release notes for you, summarizing some of the more salient points, adding my own two cents where appropriate, and leaving out several of the obscure issues that are unlikely to affect a large number of users. I will follow up with my install experiences (I posted a setup walk-through here) and what else I notice. For the first time in a while, I'm getting the bits at the same time as the public, so I don't have a ton of posts queued up and ready to go. I can tell you that the build number is 11.0.1440:

Microsoft SQL Server "Denali" (CTP3) - 11.0.1440.19 (X64) 
    Jun 24 2011 17:31:09 
    Copyright (c) Microsoft Corporation
    Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1)

 

Operating System Support & Prerequisites

I talked about Microsoft's plans in this area several weeks ago, and wasn't surprised when I saw the list of supported operating systems in the release notes for CTP3. Here are the different sets of operating systems that are supported (or not supported), and what else you need to know to get Denali up and running on them.

 
Windows 7 &amp; Windows Server 2008 R2 
  <blockquote>Denali is officially supported on Windows 7 Service Pack 1 and Windows Server 2008 R2 Service Pack 1. It will install and run fine if you don't have Service Pack 1 installed, but you will probably get one of those nasty-gram "known compatibility issues" dialogs that suggest you update your operating system. Nip that in the bud now, and install SP1. If you don't already have <a href="http://www.microsoft.com/download/en/details.aspx?id=22" title="http://www.microsoft.com/download/en/details.aspx?id=22" target="_blank">.NET Framework 3.5 SP1</a> installed, you will need to install it. You will need to enable both the .NET Framework 3.5 SP1 and .NET Framework 4.0 (which should already be installed) in order to install most of the common Denali components on Windows 7 and Windows Server 2008 R2. You can get away with keeping them disabled for a couple of components, but I would suggest just making sure they're enabled regardless of how much or how little you plan to install.

Windows Server 2008 R2 Server Core

Denali is supported on Windows Server 2008 R2 SP1 Server Core. This is the first time SQL Server has been officially supported on a Server Core operating system. There were hacks around that would allow you to install SQL Server 2008, for example, on Windows Server 2008 Server Core, but this configuration is *not* supported. (And if you're not aware of the benefits of Server Core, I strongly recommend you take a peek.) Note that the setup UI is not supported; you need to use Quiet (/Q) or Quiet Simple (/QS) from the command line, as well as an /Action parameter, in order to continue. If you are installing the Express version of Denali on server core, you will need to download and install the standalone installer of .NET Framework 4.0 for Server Core before proceeding with Denali setup. Unlike the "full" version of Windows Server 2008 R2, and unlike Denali setup when run against those other operating systems, the framework isn't present by default on Server Core – and the Express version of Denali will not install it for you. I'm hoping there is a clear and easy way for folks distributing Express-based applications to both normal and Server Core installations, without a whole lot of extra hassle for their users.

If you're going to install on Server Core, I highly recommend this post from Microsoft's Sethu Srinivasan:

http://sethusrinivasan.wordpress.com/2011/07/12/sql-server-denali-ctp3-on-windows-2008-r2-server-core/
 

Windows Vista & Windows Server 2008

Denali is supported on Windows Vista Service Pack 2 and Windows Server 2008 Service Pack 2. I suspect installation may be blocked if you are at Service Pack 1 or RTM (though it may just be a warning like above), so please make sure you are at Service Pack 2 if possible. Unlike previous versions of SQL Server, you will need to install the .NET Framework 3.5 SP1 and then this update from KB #956250 before you run setup. Denali will, however, install the .NET Framework 4.0, if you don't already have it. Note that CTP3 (because of PowerShell 2.0 requirements) cannot be installed on Vista & Windows Server 2008 for these operating system languages: Bulgarian, Estonian, Croatian, Lithuanian, Latvian, Romanian, Serbian, Slovak, Slovenian, Thai, or Ukrainian. In these cases setup won't be blocked per se, but you will get an error message that simply says, "This package is not applicable."

Windows XP & Windows Server 2003

Denali is *not* supported on Windows XP (or Windows Server 2003). If this is your preferred operating system, or if you have legacy applications that won't work on newer operating systems, you will need to use virtualization software (Virtual PC 2007, VirtualBox, VMWare Workstation) to run a more modern operating system, and install Denali there. You also might consider upgrading to a newer version of Windows, running Denali there, and running your legacy apps under XP mode. In Windows 7, you can run the newer version of Virtual PC, with or without XP Mode. In fact it is probably wise to consider one of these approaches regardless of what operating system you're running – it is a beta, after all.

Windows ME, 98SE, 98 & 95

Ha ha, just kidding.

 
All Operating Systems
  <blockquote>If you're not already running PowerShell 2.0, you will need it for both the database engine and Management Studio. Unlike previous versions, setup will not install PowerShell for you. Everything you need to be sure PowerShell 2.0 is enabled on your machine can be found in <a href="http://support.microsoft.com/kb/968929" title="http://support.microsoft.com/kb/968929" target="_blank">KB #968929</a>. If your operating system is x64, make sure to choose the 64-bit Management Tools and 64-bit Windows PowerShell Extensions for SQL Server. The 32-bit extensions will not work.

Time Bomb

The CTP is furnished in Express and Evaluation Editions. While the Express Edition does not expire, it is likely against the CTP EULA to run it beyond the 180 days. If you want the full product, be aware that it is a hard stop at 180 days – the product will stop working the next time you restart the service or reboot your computer. Unlike Windows, there is no secret command-line switch to re-arm the evaluation time bomb as you approach the 180 day limit. I wrote about this issue regarding CTP1 in April, and had a ton of fun trying to uninstall SQL Server 2008 R2 Evaluation Edition last October. So, just something to keep in mind.
 

Other issues you are likely to encounter

(I'm going to leave out potential issues with Analysis Services, Reporting Services, Data Quality Services, Master Data Services, and several less common issues. For full details on these things, please see the release notes when they come out.)

If you are running IPv6 only, the Help Viewer will not run correctly. The simplest workaround is to enable IPv4; there is a much more tedious workaround listed in the official release notes..

Saving a maintenance plan in Denali's designer will make it so that earlier versions of SSMS will not be able to edit it (or perhaps even open it). No word on whether the plan will still run on the previous version – I assume so since it is a breaking change in the designer, not the code it produces.

Because not all of the Visual Studio-related components are complete, after installing CTP3 on a system that is running Visual Studio 2010, you'll need to (re-)apply Visual Studio 2010 Service Pack 1.

Double-clicking on .SQL files will open a new instance of Management Studio, every time. If you want to open multiple .SQL files in the same instance of SSMS, use File > Open. IIRC this symptom was present in CTP1 as well.

In order to debug queries, you need to use the "Run as Administrator" option when launching Management Studio. This was also true in CTP1.

To take advantage of all of the features of AlwaysOn Availability Groups, in addition to this set of requirements, you'll need to be running under trace flag 9532. This is because not all of the features are finished in CTP3; it reminds me somewhat of how database mirroring was not quite ready in the initial release of SQL Server 2005, not really being supported until Service Pack 1.

  

17 comments on this post

    • Arthur - July 12, 2011, 5:03 PM

      Does this build break BIDS/SSIS?

    • AaronBertrand - July 12, 2011, 5:13 PM

      Not sure Arthur; I don't have any instances where BIDS or SSIS are installed.

    • Foo - July 12, 2011, 8:40 PM

      Has anyone been able to download the CTP 3?  I keep winding up in circular-link hell and really going nowhere…

    • AaronBertrand - July 12, 2011, 9:30 PM

      Foo, the download has worked for everyone I've talked to. Which platform / language are you trying to download? Are you seeing File Transfer Manager at all?

    • Haywood - July 12, 2011, 11:33 PM

      Had to use IE, the download manager was not starting in FF….

    • techvslife - July 13, 2011, 4:57 PM

      Had same issue on visual studio 2010 sp1 and silverlight — did NOT have ctp1 installed however.  Had sql 2008 r2 installed which I had to remove because it was an "unknown" version to ctp 3 denali to upgrade (too recent, cumulative update #9 I think).  It may be that the setup files left by the initial aborted installed of ctp 3 denali, or the 2008 r2 files, created the same issue you had for me.

    • AaronBertrand - July 13, 2011, 5:25 PM

      Arthur, you may want to check Max Trinidad's blog about having CTP3 and 2008/R2 BIDS play nice together:
      http://www.maxtblog.com/2011/07/sql-server-denali-side-by-side-2008-r2-bids-issue-workaround/
      But my advice would almost always be to install Denali on a different machine than one where you rely on existing versions of SQL Server / Visual Studio.

    • Mark - August 10, 2011, 9:03 PM

      I have reinstalled VS 2010 SP1 but still get a bunch of errors when I start SSMS. What is a problem?

    • AaronBertrand - August 10, 2011, 9:31 PM

      I have no idea Mark, you'll need to better define "a bunch of errors"… did you search for any of the explicit error message strings?

    • Mark - August 10, 2011, 9:44 PM

      All errors are about VS packages. I tried entering error messages into Google, did not get anything I could use. Here is first error message:
      The "VsDebugPresentationPackage, Version=10.0.0.0 Culture ……. did not load properly.
      The problem may have been caused by a configuration change or by the installation of another extension. …..

    • AaronBertrand - August 10, 2011, 9:50 PM

      I'm not sure that I'll be able to help debug your environment. Did you *completely* remove any previous Denali CTP bits? Can you reproduce the same issue on another machine that doesn't have VS and/or didn't have a previous CTP of Denali on it? Did you see my comment to Arthur on July 13, where I strongly recommend using a different machine or a VM for Denali, than a machine where you rely on Visual Studio?

    • Mark - August 10, 2011, 9:55 PM

      I did not have any previous CTPs installed. Well, it's fine, the released version will work, perhaps.

    • John - October 31, 2011, 3:12 PM

      Hello Aaron,
      I am trying to work with a trial version of sql2008.
      I am trying to follow your guidelines to get the get CTP3 installed and working.
      and part of the directions say to 'select the operating system you plan to install'.  I thought the virtual machine was so that you could work with what you have (namely, XP in my case).  So, we have to install something else here?
      I am a math person, but not that savvy when it comes to computers and corresponding terminology.
      thanks

    • AaronBertrand - October 31, 2011, 5:37 PM

      John, I'm not sure where I said that – I looked but couldn't find anything like that. I don't believe I was suggesting you need to install a different operating system, I can only guess that I meant "choose the operating system where you're going to install." Can you point out where I said that so I can help clarify?

    • Santosh P Umarani - November 24, 2011, 7:04 AM

      Hi,
      I've installed SQL Server Denali CTP3 and Windows Server 2008 R2. Can you please let me know how I get/install Project Crescent?
      Also, please send an email to esantoshu@gmail.com
      Thanks,
      Santosh

    • Aaron Bertrand - November 24, 2011, 7:19 AM

      Santosh, you should be using RC0 now, not CTP3. I haven't played with Crescent ("PowerView") but there are some installation instructions here: http://msdn.microsoft.com/en-us/library/hh231687(v=sql.110).aspx some feature details here: http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/11/17/what-s-new-in-power-view.aspx and download RC0 here: http://www.microsoft.com/download/en/details.aspx?id=28145

    • eswaraiah - January 16, 2014, 6:28 AM

      TITLE: Microsoft SQL Server 2012  Setup
      ——————————
      The following error has occurred:
      Microsoft .NET Framework 4.0 installation has failed with exit code 536870913.
      For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0xC578B891%25400xFF41F766%25401421%25402
      ——————————
      BUTTONS:
      OK
      ——————————
      TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
      ——————————
      The following error has occurred:
      Microsoft .NET Framework 4.0 installation has failed with exit code 9.
      For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xC578B891%25400xFF41F766%25401421%25402
      frame work4.0
      http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=DotNetKB2544514%40Install%400×536870913
      ——————————
      BUTTONS:
      OK
      plz help me am installing .net framework4.0 also but showing same message like this,if you know why this is came send me information to eswaraiahpasupulati@gmail.com

Comments are closed.