Installing SQL Server Denali CTP 1 – A step by step guide

Please refer to this post for step by step installation guide of SQL Server Denali (possibly SQL 2011) with screen prints. However please note that this is an installation from CTP1 as available at as of now. Future release or final release may not be exactly same but should be very similer.

Step 1: Select the installation type. (I am selecting New SQL Server Standalone installation)

Step 2: Setup should pass all the setup support rules. Then click OK to proceed.

Step 3: Install Setup Support Files by clicking on “Install” button.

Step 4: Setup should pass setup support rules. You may ignore warnings and go ahead based on case to case basis. Click Next to continue.

Step 5: Select Edition or specify the key. (For volume licensing, key should be auto populated in released versions). Here I am selecting Enterprise Evaluation here. Click Next to continue.

Step 6: Accept license terms and click Continue. Decide if you want to send the statistical data to Microsoft and check the relevant box appropriately.

Step 7: Select Feature Role. I am selecting SQL Server Feature Installation. Click Next to continue.

Step 8: Select the features you want to install and modify shared feature directory path if needed. Then click Next to continue.

Step 9: In next screen, it should pass all the installation rules. You may want to ignore some warnings if appropriate. Click Next to continue.

Step 10: Configure instance level details like selecting default instance or name an instance. Also customize instance’s root directory if required and then click Next to continue.

Here I specified D:\SQLDenali as instance root directory and installing default instance.

Step 11: Drive space should be available for the installation. Then click Next to continue.

Step 12: Give details at Server configuration page. (Give credential on which services should run and change the server (SS and AS) coalition if required). Then click Next to continue.

Here I am darkening the service account details I am using for this installation for security purpose.

Step 13: Complete the database engine configuration and click next. Make sure to add the initial administrative member of the server and customized default data directories. Click Next to continue.

Here I added my account to continue but intentionally darkened it.

Step 14: Complete similar configuration for analysis service and click next.

Note: Here again I added my account as administrator and darkened it.

Step 15: Define how you want reporting service to be installed. Here I am choosing “Install the native mode default configuration” as I want SSRS instance to be usable immediately after the installation is complete. Then click Next.

Step 16: Define if you want to send data to Microsoft and then click Next to continue.

Step 17: Installation configuration rule should be passed. Then click Next to continue. You may want to ignore some warning if it is suitable for you.

Step 18: AT this stage, everything is ready to install. Review the configuration and then click Install to continue.

Step 19: Grab a cup of coffee while the installation is complete.

Step 20: After the installation is complete, you should see the installation status as success. You may want to review the log from the GUI only to review the log. Click close to stat playing with Denali.

Now you have SQL Server Denali up and running on your machine for your first look. Also you do not have to reboot your server after this installation is complete.

NB. If you have .net framework version only up to 3.5 SP1 installed on your server or does not have powershell 2.0 installed on your server, you will face issues with installing Denali. Please refer to below posts for the resolution of such issues: