This document will guide you how to install SQL Server Denali CTP3. This is intended to give you a “quick start” of Denali CTP3 installation  but this is not a document intended to replace the full  product's installation guide  found on MSDN Library from this link:

Installation How-to Topics : SQL Server Denali

SQL Server Denali CTP 3 is available for download from  this link. If you are a hobbyist or an enthusiast of SQL server  and you want to deep dive into SQL server, I would suggest that you go for 64 bit version because some of the SQL Server features are not available in 32 bit.



Beginning Installation

Assuming we have successfully downloaded the installer, click on it to begin installation as shown in figure 1.  step no #1. This will extract the installer to a folder named “SQLFULL_x64_ENU” see step #2  as shown  below:


Figure 1:  extracting the installer

Run Setup


The next step is to run the setup. Click on Setup as illustrated in setup #1 of figure 2. Click installation as shown in step #2.  Click on “new SQL Server stand-alone installation or add features to an existing installation” as shown in step #3. Step 4 Will launch “setup and support rules” which will check if our machine and other resources comply with the system requirements.


Figure 2.  Runnning Setup

Enter Product key and License Agreement



The next screen will ask us for product key and the license agreement. Enter "evaluation"
for  the product key. This will give us 180 days to evaluate. We have to "Accept the license
term" to proceed



Figure #3 Enter product Key


Figure 4. License Terms

Setup Support rules

Setup and support rules will report all the possible problems that might occur when we install SQL Server setup files. We need to address all the items that fail before setup can continue. (Please note the text in bold on the series of steps at the left side of the dialog box. This tells you where you are in the entire setup process.)

 Figure 6. Setup Support Rules

Installation Type

This windows will allow us to choose which installation path we want go through which is either we want to “perform a new installation” or Add or remove feature from an existing SQL Server installation instance. If we are coming from “SQL Server 2000”, an instance here (starting from SQL Server 2005) refers to an installation instance which contains features such as SAAS, SSRS and SSIS. This features can be referred to by the instance name. For example an SSAS server can be referred to as “Server1\instance1” and its database engine can  be referred to as the same.

 This window will also show us all the current installed instances of SQL Server.

From here we need to click Next to continue.

Figure 7: Installation Type

Product key Again

I think this is a bug. Denali CTP 3 will ask for a product key again for the second time.
A possible defect has been logged to Microsoft Connect found from this
link.



Figure 8. SQL Server installation requesting product key again

And Yet Another License Agreement

We might have seen this in figure 4. But if we are fond of playing "spot the difference" we can find it on the left side of the dialog which basically tells us where we are in the setup process.


Figure 9. Another prompt for license terms

Setup Roles

For this I’m going to choose the feature installation which will install SSRS, SSAS, SSIS and the Database engine.


 Figure 10. Setup roles

Installation Rules

This will check if all the required features will push through. We  need to have the bar all green before we can proceed.

Figure 11.  Installation rules

Instance configuration

This dialog box will ask us to name the "instance".   Remember that the instance name  “does not only refer” to the “database instance” but to all feature installation.  For example, in figure 12 below, the instance name is “SQL_DENALI_X64” . Therefore my my box will have an individual  SSRS, SSAS, SSIS and database servers but all of them  will all be referred to as “myServername\SQL_DenaliX64”.

Figure 12. Instance Configuration

Disk space requirements

This dialog will show us if we have available hard disk space requirement before we can proceed with the setup.

 Figure 13.  Disk Space Consideration

Service Account




Analysis Service Configuration


Here we are going to "add current user" as administrator. If we are the current user, we alone
would be the administrator of the feature. If we leave, this machine cannot be used by anyone
with an "admin" privilege. For development environment we can click "add" to add
the builtin\administrator account so that any administrator of the computer can also be an  admin to that SQL feature.
For production environment I suggest that  we have a domain group "Domain_name\SQLAdmins" and add them as 
administrator of the SQL feature.

We will have to configure several services (data engine, ssis,ssrs) in this manner. If we do not add others
as administrator to the box. The feature instance will be unusable when we are gone or leave the company.
If we add the built-in administrator all administrator in the box can access sql server. We will need to configure
the service based on what we need.  An important point to remember here is that we should manage permissions
in groups (active directory group).




Reporting Service Configuration




Installation Configuration Rules

 

Summary






Succeeded