3.4 Install a New Instance of SQL Server

The following procedures are specific to Microsoft SQL Server 2017. Procedures will vary based on your version of SQL Server.

  1. From the Microsoft SQL Server ISO, double-click setup.exe.

  2. On the SQL Server Installation Center page, click Installation.

  3. Select New SQL Server stand-alone installation or add features to an existing installation.

    The Setup Support Rules operation is run.

  4. When the operation has completed, click OK.

  5. When prompted, enter your product key, then click Next.

  6. Accept the license terms and click Next.

  7. Include all Microsoft SQL Server product updates, then click Next.

    The Setup Support Rules operation is run again.

  8. When the operation has completed, click Next.

  9. On the Feature Selection page, select Database Engine Services.

  10. In the Instance root directory, Shared feature directory, and Shared feature directory (x86) fields, specify the path where you want to SQL instance to reside, then click Next.

  11. In the Instance Configuration page, click the Named instance option and specify a descriptive name for the instance such as FSFDB and click Next.

  12. On the Server Configuration page, click the Collation tab.

  13. Click Customize.

  14. Click the Windows collation designator and sort order option.

  15. From the Collation designator drop-down menu, select an acceptable collation and settings for your locale.

    For example, in North America, an acceptable collation would be Latin1_General_100 with the Accent-sensitive check box selected.

    We recommend that you select a collation that aligns with the Windows locale of the server where the Engine is installed.

    For more information on collation and locales, refer to this Microsoft document.

  16. Click OK.

  17. Click Next.

  18. On the Database Engine Configuration page, select the Mixed Mode (SQL Server authentication and Windows authentication) option, enter and confirm the SQL Server administrator password, then click Add Current User.

  19. Click Install.

  20. When the installation has completed, click Close to close the wizard.

  21. Launch SQL Server Configuration Manager.

  22. In the left pane, expand SQL Server Network Configuration.

  23. Click Protocols for FSFDB (or the name of the database instance you chose earlier).

  24. Right-click TCP/IP and select Properties.

  25. Click the IP Addresses tab.

  26. Under the IP2 heading, for the Enabled field, right-click to select the drop-down men and change the setting to Yes.

  27. Select TCP Dynamic Ports and clear the field so there is no number associated to it.

  28. Scroll down to the IPALL heading and for the TCP Dynamic Ports field, clear the field so there is no number associated to it.

  29. In the TCP Port field, and enter 1433.

  30. Click Apply.

  31. When the warning dialog box appears, click OK.

  32. Click OK to close the TCP/IP Properties page.

  33. Close the SQL Server Configuration Manager.

  34. Launch Windows Firewall with Advanced Security.

  35. From the left column, click Inbound Rules.

  36. From the Actions column, click New Rule.

  37. In the Rule Type page, select Port.

  38. Click Next.

  39. In the Protocol and Ports page, enter 1433 in the Specific local ports field, then click Next.

  40. In the Action page, accept the default setting by clicking Next.

  41. In the Profile page, accept the default settings by clicking Next.

  42. In the Name page, specify a name for the new inbound rule in the Name field.

    For example, SQL Server.

  43. Click Finish.