Denali Series - Downloading and Installing Denali CTP3 in Win Server 2008 R2


Introduction:

In this article we are going to see how to download and install Microsoft SQL Server Codename "DENALI" CTP3 in Windows Server 2008 R2 Enterprise Edition step by step.

Overview:

In our earlier article on the release of SQL Server Code name Denali CTP3 we have seen the features of the same. In this article we will see how to proceed with downloading the installer and setting up the development environment for Denali CTP3 step by step.

Steps:

We have 2 versions that can be downloaded and used as per our requirement

Option 1 - Denali CTP3 Evaluation

We can download the installer here - Download SQL Server Denali CTP3 


Option 2 - Denali CTP3 Express

We can download the installer here - Download SQL Server Denali CTP3 Express


Here in this step by step process we are going to download and install the Evaluation version, Once we go to the download page we can see the download link Download CTP3 as shown in the screen below.

Download CTP3-1 in sql server
Clicking on the Download CTP3 link will navigate to download the version(32 bit or 64 bit). Since we are going to install it on to the Windows Server 2008 R2 Enterprise we are going to select the 64 Bit version as shown in the screen below.

select version of CTP3
 
Clicking on Download 64 button will navigate to a new page where the download starts using the Internet Download Manager as shown in the screen below.

Download CTP3
 
Once the download is completed we can see 4 files downloaded as shown in the screen below.

CTP-Files in sql server
 
Now double click on the SQLFULL_x64_ENU_Install application file to extract the required files for installation. It will take bit time to extract all the files to the same location as shown in the screen below.

EXtract CTP-Files in sql server
 
Once the extraction is over, refresh the folder and we can see a new folder created SQLFULL_x64_ENU as shown in the screen below.

SQL FULL 64 ENU-Folder
 
Now navigate to the folder and we can see a list of files as shown in the screen below. Point to Setup file and right-click on the file and select Run as administrator

Setup-File of  CPT 3
 
Now the installation process will be started and we can see the status message as shown in the screen below.

Status-Message in CPT 3

Now the new window will be opened with the different steps to carry out our installation and some links providing help for our installation steps as shown in the screen below. We can now select the Hardware and Software Requirement to check the necessary things are available for our installation. Else we can navigate to the link http://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx and check for the same.

SqlServer Installation
 
Now in the left menu navigate to Installation and we can see the option New SQL Server stand-alone installation or add features to an existing installation option as shown in the screen below. Click on that option to proceed further.

Installation-Options of sql server
 
Now we can see some Setup Support Rules will be running background to check if required process available for installation. Once its completed we can see the high level result of how many rules failed or skipped as shown in the screen below.

Setup Support Rules in sql server
 
To check in detail of the Passed results we need to click on the Show details button and we can see the complete list of rules ran and the result as well as shown in the screen below.

Setup Support Rules in sql server
 
Now click on OK button and we can see a new window with evaluation options for the licenses. Select Evaluation license or Express license as per our requirement. Since in this article we are going to evaluate the product installation we are going to select Evaluation from the list and click on Next button as shown in the screen below.

Product Key in sql server
Clicking on Next button will navigate to the Terms and conditions of the installation. Selec the check box as shown in the screen below and click on Next button

image

Now we can see the list of updates available to be downloaded and installed, as its mentioned
in the screen it first installs the Setup Update(30MB) remaining will be downloaded later and installed. Click on Next to proceed further after selecting the updates as shown in the screen below.

Product-Updates in sql server
We can now see the Setup Update gets downloaded and status of the steps as well as shown in the screen below. Once the download is completed click on Install to proceed further.

Install-setup-Files in sql server
Now we can see new set of Setup Support Rules running and providing a result as shown in the screen below. We can see 2 warnings since the server is domain controlled it shows the warning. Just ignore it and we can proceed further by clicking on Next button as shown in the screen below.

Support-Rules in sql server
Now we need to selec the type of installation which we need to proceed. Select SQL Server Feature Installation and click on Next as shown in the screen below.

Setup-Role in sql server
Now we can see the list of Features that need to be installed, we have an option at the bottom of the list as Select All to select the complete list. Also we can share the features installed directory customized by selecting the folder as shown in the screen below. Click on Next button to proceed further.

Feature-Selection in sql server
Now we can see some set of Installation Rules running and get the result as shown in the screen below. Click on Next to proceed further.

Installation-Rules in sql server
Now we need to provide our instance Name as per our wish. Here we have provided with DENALICTP as the instance name and select the install root folder and click on Next button as shown in the screen below.

Instance-Configuration in sql server
Now we can see the summary of the Disk Space available in the server and the required space for the installation of Denali CTP3 as shown in the screen below. Click on Next to proceed further.

image
Now we can see the list of services and the Startup type of each service (Manual or Automatic) based on our selection we can make it as per our requirement as shown in the screen below. Click on Next to proceed further.

Server-Configuration in sql server
Now Server configuration screen comes up, here as per our requirement we can use Windows Authentication or the Mixed Authentication modes and provide valid Password. At the bottom we can see a button Add Current User, click on that button to add the current user to the list as shown in the screen below. Click on Next to proceed further.

Database-engine-Config
Now we can see the Error Reporting option, if we need to report the error to Microsoft then we can initiate it by using the Check box enabled as shown in the screen below. Click on Next to proceed further.

Error-Reporting in sql server
Now Configuration Rules will be triggered and provide the results as shown in the screen below. Click on Next to proceed further.

Installation Config Rules in sql server
Now we can see the summary of the list of service and applications that are going to be installed listed as shown in the screen below. Click on INSTALL to proceed further and start the installation.

Ready to Install list of services
Now we can see the installation is started and the installer will do step by step process of installing all the necessary components as shown in the screen below.

Installation Progress of sql server
Once the installation is completed we can see the result and the status as shown in the screen below. Click on Close to complete the process.

sql server installation Process Completeion
No go to programs and navigate to Microsoft SQL Server Denali CTP3 and select the SQL Server Management Studio(SSMS) as shown in the screen below.

sql server Program navigation
We can see the Denali CTP3 studio starts loading as shown in the screen below.

open Denali CTP3 Studio
Once its loaded we are now good with the SSMS and start using for our development process as shown in the screen below.

SSMS Developement Process

Conclusion:

So in this article we have seen the step by step process on downloading and installing the Microsoft SQL Server Denali CTP3. In our upcoming article we will see more in-depth on the new features of Denali and New features in Denali BI.

Next Recommended Readings