SQL Server Denali : A First Look


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.image

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.image

After the initial loading screen, you will get the SQL Server Installation center as shown below:image

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.image

image

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.imageSelect the Licensing Term and install the Setup Support files. Select the SQL Server Feature Installation to continue.image

Select the required features to install in SQL Server Denali. Click on Next to continue.image

Follow the onscreen instructions to proceed further. Once you have provided all the necessary requirements, you will get the following screen.image

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:image

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:image

Expand SQL Server Network Configuration. As you can see from the below screenshot, the TCP/IP Protocol is disabled. image

We need to enable TCP/IP protocol, specify a static IP address (IPv4), disabled other IP Addresses and specify a specific port to run SQL Server. The server will be running on the default port.image

This changes will be effective after we restart the SQL Server instance. After the SQL instance is restarted, connect to the SQL Server using SSMS.image

Once you will connect to the SQL Server instance, you will get the following screen:image

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.

Advertisements

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in How To, SQL Server Denali CTP1, SQL Server Installation. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s