SQL Server 2014 Installation Steps

Installing a new instance of SQL Server 2014 Enterprise Edition is an easy task by using SQL Server setup installation wizard.

Once an instance is installed on your system, you have option of installing multiple instances of same SQL Server on your system.

Before installation please ensure and check the hardware and software minimum requirements for installing SQL Server 2014.

Step-by-step procedure

Firstly, go to the SQL Server Setup folder, Click on Setup as in the following,

Example

setup

  1. In first step of Planning: You have the option of Insuring/Checking Basic Hardware & software requirements before installation:

    1

    Click on Hardware and Software Requirements: It will take you to the online Microsoft page, please check requirements before installing SQL Server 2014. 

    For full Hardware, Software and Memory requirements, please visit Microsoft website, Click on this Link:

  2. Click on Installation: In this section click on New SQL Server stand-alone installation or add features to an existing installation.

    2

  3. A new window will open: Click Next.

    3

  4. Clicking on Next under Install Rules: You can see rules passed, error on Windows firewall, for this click on warning and TurnOff windows firewall and click Next.

    4
     
  5. In Installation Type: Select Perform a new installation of SQL Server 2014 and click Next.

    5

  6. In Product key: Enter the product key, click on next.

    6

  7. In License Terms: accept terms, click on Next.

    7

  8. In Setup Role: Select SQl Server Feature Installation and click on Next,

    8

  9. In Feature Selection: Select features as All, Instance Saving location can be changed and click Next, 

    9

  10. In Instance Configuration: You can select Default option for default instance name, my system already having server instances, so I selected Named instance for new instance name, Now click on Next.

    10

  11. In Server Configuration: Click on Next.

    11

  12. In Database Engine Configuration: You have option to provide Window authentication or Mixed Mode for separate login account. Make Sql Server Login account and click on Add Current User to add windows authentication for existing user. Click on Next.

    12

  13. In Analysis Services Configuration: Click on Add Current User for login authentication and click on Next.

    13

  14. In Reporting Services Configuration: Select Install and Configure option and click Next.

    14

  15. In Ready to Install: Provide Configuration files saving path on your system. Click Install.

    15

  16. Now you will see Installation Progress as in the following,

    16

  17. Once Installation is completed, you will see Features as Succeeded. Now click Close.
          17


Now search SQL Server 2014 Management Studio in your system search/window 10 cortana by typing …SQL. Here's the screenshot,

Example

18

Click on SQL Server 2014 Management Studio

Then select Server name: It is the server instance you have created or if you have multiple instance just click on Browse for more and select the desired server.

19

When you clicked on Browse for more, the following window will open, select your server name instance that you have created in it.

20

Once login is done you can access SQL Server that you have created: MSSQLSERVER2 is the one I have installed and it is ready for use as in the following,

21