SQL Server 2014 CTP 2 – Installation

SQL Server 2014 CTP 2 was already announced, which is available now for download as a community technology preview.

You can now download SQL Server 2014 CTP2 from http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx. This post covers a step-by-step installation guide of SQL Server 2014 CTP 2 with screen shots. Future release or final release may not be exactly same but should be very similar to this. We will perform this installation on Virtual test machine with Windows 2008 R2 Enterprise Edition X64.

Upgrading from Microsoft SQL Server 2014 CTP 1 to Microsoft SQL Server 2014 CTP 2 is NOT supported. So make sure that you remove Microsoft SQL Server 2014 CTP 1 before proceeding for installation.

Installation Steps

Step 1: Select the installation type. Here we will perform standalone installation thus selecting the same.

Step 2:  We will keep the edition details default and Click Next to continue.

Step 3: Read and accept term and conditions. Click next to continue.

Step 4: Setup will check Global Rules on this page. Product update page was skipped.

Step 5:  Setup should pass Install rules. You may ignore warnings and go ahead based on case to case basis. Click next to continue.

Step 6: We will proceed with Feature install selection once the check phase is completed. I have selected default. Click next to continue.

Step 7: Select the Features that you would like to install.

Step 8:  Based on the selected features the SQL Server 2014 CTP 2 setup will perform additional Feature Rules check. Click next to continue.

Step 9: Provide the instance name if you want to install a named instance here. I have selected default instance here. Click next to continue.

Step 10: Specify account name and startup type on this page. Move to adjacent tab.

Step 11: There is default checking of Collation settings for Database Engine & Analysis Services. You can customize it. Click next to continue.

Step 12: On the Server Configuration tab, specify the Authentication type and add the users who will have Administrative Privileges on Database Engine. Here I have added my account as Administrator. Switch to adjacent tab.

Step 13: Select the locations in Data Dictionaries tab. I have kept them as default. Switch to last tab.

Step 14: On File stream tab you might want to enable the filestream feature. For now, I have kept it as disabled. Click next to continue.

Step 15: On the Server Configuration tab, add the users who will have Administrative Privileges on Analysis Services. Here I have added my account as Administrator. Switch to adjacent tab.

Step 16: Select the locations in Data Dictionaries tab. I have kept them as the default. Click next to continue.

Step 17: On Reporting Services Configuration page, select the option for Reporting services install. I have selected ‘Install Only’ as I will configure it later .Click next to continue.

Step 18: Some more checks on Feature Configuration Rules page. Click next to continue.

Step 19: We are ready to install. You might like to verify the selected configurations before proceeding. Click on Install button.

Step 20: Installation is in progress.

Step 21: Finally the setup is successful with the pop up window suggesting to reboot the system after the successful installation of SQL Server 2014 CTP 2.

Now we have SQL Server 2014 CTP 2 installed. Let’s connect to SSMS and verify the build.

Conclusion

SQL Server 2014 CTP 2 wizard is almost similar to SQL Server 2012. Soon we will explore SQL Server 2014 features in upcoming blogs.