Installing Microsoft SQL Server 2014

  1. Start setup.exe .SQL_14_01.PNG
  2. Click Installation in the left window part and New SOL Server stand-alone installation Installing-Microsoft-SQL-Server-2014 at the right.
     The SQL Server 2012 Setup wizard is launched.
  3. Enter your product key in the Product Key window and click Next .

SQL_14_05.PNG

  1. Check the I accept the license terms box in the License Terms window and click Next .

SQL_14_06.PNG

  1. Check if there are any updates available after your computer has established the connection to the SQL Server internet. If there are no updates to be installed, click Next , otherwise install these and restart this procedure.
  2. Click Next .The Install Setup Files window appears on the screen.SQL_14_02a.PNG

  3. Click Next .The Install Rules window appears on the screen and starts some initial tests. 

    Note:

    Click Details / Hide Details to display or hide the tests and test results.

    SQL_14_02.PNG

  4. If no issues are indicated, click OK .The Setup Role window appears.SQL_14_03.PNG
  5. Select SQL Server Feature Installation .
  6. Click Next .
  7. Select the rquired functionalities and modify, if necessary, the setup procedure in the Feature Selection window.

SQL_14_08.PNG

Do not forget to tick the two boxes concerning the Management Studio .

A test is executed and its results are shown in the Features Rules window.SQL_14_09.PNG

  1. If no issues are indicated, click Next .

SQL_14_10.PNG

  1. Keep the first option selected or choose a named instance and enter your instance ID in the Instance Configuration window. Click Next to continue.SQL_14_11.PNG
  2. Configure the services as shown in the screenshot in the Server Configuration window.
  3. To configure the SQL Server collation as defined by Microsoft, click the tab Collation .SQL_14_12.PNG
  4. Click Customize and configure the SQL Server collation as defined by Microsoft, that is Latin1_General_CI_AS_KS_WS as shown in the screenshot below.SQL_14_13.PNG
  5. Click OK .
  6. Click Next .SQL_14_14.PNG
  7. Select Mixed Mode and specify the password for the SQL Server system administrator (sa) account.SQL_14_15.PNG
  8. Click Add Current User to add your SQL Server administrator account.
  9. (Optional) Click the Data Directories tab and modify the setup procedure.
  10. Click Next .A summary of the elements to be installed is displayed.SQL_14_19.PNG
  11. If all selections displayed in the Ready to Install window are correct, click Install to launch the actual installation.
  12. When all features are installed and their status is set to Succeeded in the Complete window, click Close .SQL_14_21.PNG

The installation process executed successfully. You can now start the Management Studio from your desktop for further configuration.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*