Installation Process and Preview of SQL Server 2014 CTP 1

I am really excited that today Microsoft has released the line of updated products such as,-

  1. SQL Server 2014 CTP 1
  2. System Center 2012 R2
  3. Windows Server 2012 R2

Times like this really kept me excited and busy trying out the new release and hopefully without much interference from my job, I will be able to meddle and understand the new features in the upcoming releases. For every product release, there bound to have installation guide that will be floating around and I hope to the first few to share with you my experience of installing this preview products. 🙂

Here goes… While downloading the media from TechNet, I have already prepare one of the virtual machine that is loaded with Windows Server 2012 Standard Edition.

1) Insert the media via Hyper-V console and the ISO will auto run (if it doesn’t, click on the disc drive at “My Computer“)


2) This menu page looks rather similar to the one of SQL Server 2012.


3) Click on “Installation” and in my case since this is will be a stand-alone database server, I always select the first option “New SQL Server stand-alone installation or add features to an existing installation.


4) The “Setup Support Rules” will appear, just take things as default. Click “OK“.


5) If you have a product key, enter the product key and the installer will determine what version of SQL Server you are entitled to, for the demo purposes, I am selecting “Evaluation” version.


6) In the “License Terms” page, you may just want to check the checkbox “I accept the license terms” and continue with the installation unless you do not comply with the agreement terms.


7) The installer will continue to install the Setup Files on the system. One feature I really like since version 2012 is that it will bundle in new product updates available during the installation rather than patching it manually later on after installation.


8) Once “Setup Support Rules” has completed, review the results of the rules to see if there is any show-stopper. For my case, Windows Firewall isn’t a show-stopper even though there is “Warning” sign because it just means that even if you installed SQL Server, users may not be able to access this server as the required ports are not opened.


9) Select the type of role you want this database server to be configured, for all demo machine, I tends to choose “All Features with Defaults” so that I can have a better understanding of what is being changed.


10) Leaving this as default as I wish to install all features available.


11) Installation rules completed to verify that the necessary files and settings are correct before the configuration starts.


12) Instance Configuration – Configure the Instance ID and defining the root directory. All along, I always make sure I do not have any SQL related stuffs sitting on the same drive as my OS. Therefore, I will do some modification as shown in the 2nd image below.




13) Review the disk summary


14) Defining the Service Accounts – As shown in the 2nd image, I always have a set of practices that I align with for all my deployments.



15) Database Engine Configuration – This is the part to select whether you will need what type of Authentication Mode and specifying the SQL Server Administrator (You need not define all the Administrator at one go, you may do so later on using SQL Server Management Studio and assigning the various roles to the users)



16) Analysis Services Configuration – Leave the default settings and add the right administrator to it.


17) Reporting Services Configuration – The standard menu where it gives you two options to select from,- I usually goes for the first one to let SQL Server Installer do the job for configuring the Reporting Services for me.


18) Distributed Replay Controller – Assign the respective Administrator


19) Distributed Replace Client – Define the name of the Controller Name


20) Error Reporting – Somehow, I feel that this option should only be provided upon meeting any errors and this page should be left out during installation. (Just my opinion)


21) Installation Configuration Rules


22) Summary of the configuration settings


23) Installation Progress – There we go…


24) Installation Completed



25) Verification of the SQL Server version






All in all, I feel that this release of the SQL Server has not changed much in terms of the ecstatic which is good. It just means that Microsoft is really accepting opinion from the grounds and putting in more useful features that people are requesting for! For more information of what’s new in SQL Server 2014, check out of one of the article that I personally like here. In my next few posts on SQL Server 2014, I will be experimenting out and write out the experience that I have with the “Cloud“! 🙂

Until then…

Milton Goh

Installation Process and Preview of SQL Server 2014 CTP 1

Leave a Reply

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

You are commenting using your 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