Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

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 ... 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
  4. Check the I accept the license terms box in the License Terms window and click Next . 
    SQL_14_06.PNG
  5. 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.
  6. Click Next .The Install Setup Files window appears on the screen.
    SQL_14_02a.PNG

  7. 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

  8. If no issues are indicated, click OK .The Setup Role window appears.
    SQL_14_03.PNG
  9. Select SQL Server Feature Installation .
  10. Click Next .

  11. 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

  12. If no issues are indicated, click Next .
    SQL_14_10.PNG
  13. 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
  14. Configure the services as shown in the screenshot in the Server Configuration window.
  15. To configure the SQL Server collation as defined by Microsoft, click the tab Collation .
    SQL_14_12.PNG
  16. Click Customize and configure the SQL Server collation as defined by Microsoft, that is Latin1_General_CI_AS_KS_WSas shown in the screenshot below.
    SQL_14_13.PNG
  17. Click OK .
  18. Click Next .
    SQL_14_14.PNG
  19. Select Mixed Mode and specify the password for the SQL Server system administrator (sa) account.
    SQL_14_15.PNG
  20. Click Add Current User to add your SQL Server administrator account.
  21. (Optional) Click the Data Directories tab and modify the setup procedure.
  22. Click Next .A summary of the elements to be installed is displayed.
    SQL_14_19.PNG
  23. If all selections displayed in the Ready to Install window are correct, click Install to launch the actual installation.
  24. 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*