3.3 Install SQL Server Express

  1. Launch the SQL Server Express installation file.

  2. Choose a directory for the extracted files and click OK.

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

  4. In the License Terms page, accept the license terms and click Next.

  5. In the Product Updates page, click Next.

  6. Select Use Microsoft Update to check for updates (recommended), then click Next.

  7. In the Install Rules page, click Next.

  8. Click Unselect All.

  9. Select the Database Engine Services check box.

  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.

  11. Click Next.

  12. In the Feature Rules page, click Next.

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

  14. In the Server Configuration page, click the Collation tab and then click Customize.

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

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

  17. Click OK.

  18. Click Next.

  19. Select the Mixed Mode (SQL Server authentication and Windows authentication) option, enter and confirm an SQL Server administrator password, and then click Add Current User.

  20. Click Next.

  21. In the Complete page, click Close.

  22. Launch SQL Server Configuration Manager.

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

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

  25. In the right pane, right-click TCP/IP and select Enable.

  26. In the warning dialog box, click OK.

  27. Right-click TCP/IP again and select Properties.

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

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

  30. Scroll down to the IPALL heading and for the TCP Port field, and enter 1433.

  31. Click Apply.

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

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

  34. In the SQL Server Configuration Manager, click SQL Server Services.

  35. Right-click SQL Server (FSFDB) and select Restart.

  36. Close the SQL Server Configuration Manager.

  37. Launch Windows Firewall with Advanced Security.

  38. From the left column, click Inbound Rules.

  39. From the Actions column, click New Rule.

  40. In the Rule Type page, select Port.

  41. Click Next.

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

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

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

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

    For example SQL Server Express.

  46. Click Finish.