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“)

01_Starting_Installation_of_SQLServer2014_CTP1

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

02_Starting_Installation_of_SQLServer2014_CTP1

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.

03_Starting_Installation_of_SQLServer2014_CTP1

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

04_Installation_Setup_Support_Rules

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.

05_Enter_Product_Key

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.

06_License_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.

07_Install_Setup_Files

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.

08_Setup_Support_Rules

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.

09_Setup_Role

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

10_Feature_Selection

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

11_Installation_Rules

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.

12_Instance_Configuration

 

13_Instance_Configuration_MyPractices

13) Review the disk summary

14_DiskSpace_Requirements

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_Server_Configuration

16_Server_Configuration_Accounts

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)

17_Database_Engine_Configuration

18_Database_Engine_Configuration

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

19_Analysis_Services_Configuration

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.

20_Reporting_Services_Configuration

18) Distributed Replay Controller – Assign the respective Administrator

21_DRC_Configuration

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

22_DRC_Configuration_Specify_ControllerName

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)

23_Error_Reporting

21) Installation Configuration Rules

24_Installation_Configuration_Rules

22) Summary of the configuration settings

25_Ready_To_Install

23) Installation Progress – There we go…

26_Installation_Progress

24) Installation Completed

27_Installation_Complete

28_Installation_Complete

25) Verification of the SQL Server version

29_Start_Menu

30_Start_Program

31_SSMS

32_Verification_of_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…

Regards,
Milton Goh

Leave a Reply