The next version of SQL Server, Code Named Denali (CTP 1) was released in the recent PASS Summit. For the detail requirement of hardware & software to install SQL Server Denali CTP1, click here. I am installing SQL Server Denali CTP 1 on a virtual machine running Windows Server 2008 Evaluation edition with SP2. After installing the service pack, make sure you have installed all the latest windows updates along with the latest version of DotNet Framework (min. 3.5 SP1 or above). Another required feature is Windows PowerShell v2.0; make sure you have installed the Windows PowerShell v2.0 before starting the Denali setup.
Once the DotNet framework installation is completed, restart the server. After the server is rebooted, start the SQL Server Denali installation. After you start the installation, you will get the following screen.
Click on the Installation tab on the left-side panel. For this post, we are going to perform a stand-alone installation. Click on New SQL Server stand-alone installation or add new features to an existing installation to continue.
Once the installation will be completed click on OK to continue to setup. Select the edition you want to install. For this demo, we are going to install the Enterprise Evaluation edition.Select the Licensing Term and install the Setup Support files. Select the SQL Server Feature Installation to continue.
The arrow mark above shows the location of the SQL Server configuration file. If you want to install SQL Server Denali on multiple environments with the same configuration, you can use this configuration file. It is very helpful incase you are performing script based installation. Click on the Install button to start the installation. Once the installation is completed, you will get the following screen:
As you may have already noticed there are less components listed above then the list which we selected during installation. The initial installation failed to install the above sub-components, so I have to re-run the setup to add the above four sub-components. Since all the required components are installed, now its time to start configuring SQL Server code-named Denali. Open SQL Server Configuration Manager from the Start Menu (Start Menu –>All Programs –>Microsoft SQL Server Denali CTP1 –>Configuration Tools) as shown below:
In this post, we have install SQL Server Code-Named Denali in a virtual environment. We will look into the other features in the later posts.