MS SQL Server Installation Manual

Note: If a MS SQL Server 2014 version is already present on your server, the order of the steps may slightly differ.

1. Depending on your settings:
   • Right-click Setup.exe when you can choose between 'Setup.exe' and 'Setup.exe.config'.
   • Right-click Setup when you can choose between 'Setup' and 'Setup.exe'.

   Then click Run as administrator to run the MS SQL Server setup with elevated privileges. Allow the application to modify your register.

2. Click Installation in the left-hand pane.
3. Click New SQL Server Stand-alone installation or add features to an existing installation. in the right-hand pane.
4. Enter your product key, or use the product key of the installation software, then click Next.
5. Activate the I accept the license terms field and then click Next.
6. Click Next. For servers, also configurate the firewall (please refer to http://msdn.microsoft.com/en-us/library/cc646023.aspx).
7. Activate Perform a new installation of SQL Server 2014 and then click Next.
8. Click Next.
9. Activate Database Engine Services, Full-Text and Semantic Extractions for Search, and Management Tools – Complete, and then click Next.
10. Click Next.
11. Activate Named instance, type a name for your MS SQL Server instance in the Instance ID field and then click Next.
12. Click Next.
13. For SQL Server Agent select Automatic.

    In a high security environment, the SQL Server Browser service should be turned off.

14. Click the Collation tab. If the Database Engine does not use Latin1_General_CI_AS, click the Customize button.

    Attention: SQL_Latin1_General_CI_AS should also be changed to Latin1_General_CI_AS.

15. If you have to change the collation, activate Windows collation designator and sort order. In the Collation designator field, select 'Latin1_General’ (Western European characters), click the check box Accent Sensitive and click OK. In the Server Configuration form the collation name is automatically changed to ‘Latin1_General_CI_AS’ (Case-Insensitive, Accent-Sensitive).
16. Click Next.
17. Activate Mixed Mode (SQL Server authentication mode and Windows authentication), enter a password for the administrator in the Enter password and Confirm passwords field, and add an administrator in the Specify SQL Server administrators list in one of the following ways:
    • Click Add Current User to add the current user as an administrator, or
    • Click Add and select an administrator.
18. Click the Data Directories tab. Enter the standard Isah paths as shown below.Note: change '<Nr>' to the SQL Server version number (SQL Server 2012 = MSSQL11, SQL Server 2014 = MSSQL12, SQL Server 2016 = MSSQL13), and <INSTANCE> to the MS SQL Server instance name you have chosen.
    • Data root directory: D:\Isah\Database
    • System database directory: D:\Isah\Database\MSSQL<Nr>.<INSTANCE >\MSSQL\Sys
    • User database directory: D:\Isah\Database\MSSQL<Nr>.<INSTANCE >\MSSQL\Data
    • User database log directory: D:\Isah\Database\MSSQL<Nr>.<INSTANCE >\MSSQL\Log
    • Temp DB directory: D:\Isah\Database\MSSQL<Nr>.<INSTANCE >\MSSQL\Temp
    • Temp DB log directory: D:\Isah\Database\MSSQL<Nr>.<INSTANCE >\MSSQL\Temp
    • Backup directory: D:\Isah\Database\MSSQL<Nr>.<INSTANCE >\MSSQL\Backup

    For higher performance, log and data directories should be placed on separate disks with a separate IO channel. Small systems might not have a D drive. In that case, use C instead. However, hardware configuration is a system administrator issue that falls outside the scope of this document. Apart from the drive, it is strongly recommend to use the paths as suggested in this document.

19. Click Next.
20. Click Install. Please wait until the installation is complete.
21. Click Close.
22. Close the SQL Server Installation Centre form.