Step by Step Installation of SQL Server 2014 CTP1 & work with SQL Azure database on SSMS 2014 CTP1


SQL Server 2014 CTP 1 was already announced in TechEd 2013 North America , which is available now for download as community technology preview. You can download now SQL Server 2014 CTP1 from here.

SQL Server 2014 CTP1 has an added support for in-memory OLTP processing, 99.95% High Availability Always On preview features & focuses more on Data Explorer (Microsoft HDInsight) along with Lambda Architecture preview.

  • Lets check for a quick step by step installation guidelines of SQL Server 2014 CTP1 on Windows Server 2012 Datacenter edition.

Installation

  • Click on Installation option to start installation of a new instance of SQL Server 2014 CTP1 edition, alternatively , you can upgrade from SQL server 2012 SP1 instance from Update section.

SetupSupport

 

  • Specify Evaluation edition of SQL Server 2014 CTP 1 version.

ProductKey

 

 

SetupRole

  • Lets select the features available required for SQL Server 2014 CTP1 standalone instance.

Features

  • Click on Next in order to start the ‘Installation Rule Engine‘ for SQL Server 2014.

InstallationRules

  • Specify the instance name of the SQL instance.

InstanceConfig

ServerConfig

 

  • Next , specify the authentication mode & setup password for SQL Server authentication.

Authentication

 

  • As you can see , in SQL Server 2014 CTP1 , there is default checking of Collation settings for Database Engine & Analysis Services. You can customize it.

Collation

 

  • Next, specify settings for SSAS 2014 & SSRS 2014.

SSAS

 

SSRS

 

  • Finally , execute the instance configuration rules & start installation.

InstallConfig

 

  • After installation , click on SSMS 2014 CTP 1 & login with your Windows Authentication/SQL Server Authentication credentials.

SSMS

 

SSMSlogin

 

  • Also, you can work with your Windows Azure SQL database too with SQL Server Management Studio 2014 CTP1 , you can login in with SQL Azure database credentials from SSMS 2014.

SQL Azure Login

 

TSQL_Azure

Advertisements

About Anindita
Anindita Basak is working as Big Data Cloud Consultant in Microsoft. Worked in multiple MNCs as Developer & Senior Developer on Microsoft Azure, Data Platform, IoT & BI , Data Visualization, Data warehousing & ETL & of course in Hadoop platform.She played both as FTE & v- employee in Azure platform teams of Microsoft.Passionate about .NET , Java, Python & Data Science. She is also an active Big Data & Cloud Trainer & would love share her experience in IT Training Industry. She is an author, forum contributor, blogger & technical reviewer of various books on Big Data Hadoop, HDInsight, IoT & Data Science, SQL Server PDW & PowerBI.

Leave a Reply

Please log in using one of these methods to post your comment:

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

%d bloggers like this: