SQL Server 2014 CTP1 installation Step By Step

-
  • 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
    About these ads

    Comments

    Post a Comment

    Popular posts from this blog

    SharePoint 2007 - Simple Task Dashboard

    -
    Image
    example of creating a simple Task Dashboard. This is a pretty basic example of using all OOTB (out of the box) features and combining them to quickly build a solution. Scenario: We want to provide a way for users to easily see a summary of the current project tasks. We want them to be able to see the following information: Open Tasks Assigned to Them Overdue Tasks Tasks Due This Week Task Calendar Tasks Assigned to Others Solution: To build this solution we will be using several different tools available in SharePoint, all included in the list below: Task List Task List Views We will create views for each of the different ways we want to see the data displayed on our dashboard. Web Part Page List View Web Parts Custom Navigation The first thing we will do is create our task lists and then configure all the views that we need. To create the list, go to View All Site Content, Create and then select the Task list. Next, we will need to configure our custom views. To do this, w
    Read more

    MERGE transformation in SSIS

    -
    Image
    In this post we are gonna discuss about MERGE transformation. MERGE in SSIS is equal to UNION ALL in SQL Server. This transformation unions two datasets/tables.The merge Transformation combines two  sorted  dataset into single dataset. Highlighted the text SORTED in last statement because “It is not possible to use MERGE when the inputs are NOT SORTED”. There is one more transformation which is very similar to this i.e UNION ALL. The Merge Transformation is similar to the union all transformations. Use the union all transformation instead of the merge transformation in the following situations. The transformation inputs are not sorted The combined output does not need to be sorted. The transformation has more than two inputs. MERGE takes ONLY TWO inputs where as UNION ALL can take more than two. Now lets see how to configure MERGE transformation with an example. I created TWO tables with names MergeA and MergeB and inserted few records into each table as shown below.
    Read more