Install Microsoft SQL Server 2014

Note: 

It is recommended to perform Windows Update to enhance the SQL Server security and performance before running the installation.

Preparations

M3 BE SQL Server Instance Requirements

  1. Mount the Microsoft SQL Server 2014 installation media on the server.
  2. Run setup.exe and select Installation/New SQL Server stand-alone installation or add features to an existing installation.
  3. Check for warnings or errors in Setup Support Rules, and click OK.
  4. Optionally: Accept installation of Product Updates (if any) and click Next.
  5. Check for warnings or errors in Setup Support Rules, and click Next.
  6. Optionally: Select Perform a new installation of SQL Server in Installation Type, and click Next.
  7. Enter the Product Key and click Next.
  8. Accept the licensing terms in the License Terms window, and click Next.
  9. Select SQL Server Feature Installation in Setup Role and click Next.
  10. Select the following options in the window Feature Selection, and accept or change shared feature directory:
    • Database Engine Services

    • Client Tools Connectivity

    • Management Tools - Basic

    • Management Tools - Complete

      Note: 

      SQL Management Tools can only be installed on a Windows Server 2014 with full GUI interface configuration.

    Click Next.

  11. In the Installation Rules window, check for errors and warnings and click Next.
  12. In the Instance Configuration window, leave the Default instance check box selected,or name the new Named instance. Accept or change the Instance root directory, and click Next.
  13. In the Server Configuration window, select a specific, dedicated Windows user account (local or domain) for all SQL Server services and enter passwords. In the Collation tab, choose Latin_General (Latin_General_BIN2) binary sort for Database Engine, and click Next.
  14. In the Database Engine Configuration window, select Mixed mode (SQL Server authentication and Windows authentication).

    Specify the sa login password.

    Note

    Always use a strong password for the sa account and change the password periodically.

    Add a (current) User as SQL Server administrator.

    Accept or change data directories in the "Data Directories" tab.

    Do not enable FILESTREAM for Transact-SQL access in the FILESTREAM tab.

    Click Next.

  15. In the Error Reporting window, click Next.
  16. In the Installation Configuration Rules window, check for errors and warnings and click Next.
  17. In the Ready to Install window, check the summary and click Install.
  18. In the Complete window, click Close.