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 you 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 your machine and other resources comply with the system requirements.


Figure 2.  Runnning Setup

Enter Product key and License Agreement



The next screen will ask you for product key and the license agreement. Enter "evaluation"
for  the product key. This will give you 180 days to evaluate. You 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 you install SQL Server setup files. You 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 you to choose which installation path you want go through which is either you want to “perform a new installation” or Add or remove feature from an existing SQL Server installation instance. If you 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 you all the current installed instances of SQL Server.

From here you 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

You might have seen this in figure 4. But if you are fond of playing "spot the difference" you can find it on the left side of the dialog which basically tells you where you 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. You need to have the bar all green before you can proceed.

Figure 11.  Installation rules

Instance configuration

This dialog box will ask you 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 you if you have available hard disk space requirement before you can proceed with the setup.

 Figure 13.  Disk Space Consideration

Service Account




Analysis Service Configuration


Here you are going to "add current user" as administrator. If you are the current user, you alone
would be the administrator of the feature. If you leave, this machine cannot be used by anyone
with an "admin" privilege. For development environment you 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 you have a domain group "Domain_name\SQLAdmins" and add them as 
administrator of the SQL feature.

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




Reporting Service Configuration




Installation Configuration Rules

 

Summary






Succeeded