3.2 Install SQL Server Express

  1. Launch the SQL Server Express installation file.

  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.

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

  5. In the Product Updates page, click Next.

  6. In the Feature Selection page, select the appropriate instance features and the location for the instance data and click Next.

  7. On the Instance Configuration page, specify a named instance and click Next.

  8. In the Server Configuration page, click the Collation tab.

  9. Click Customize.

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

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

  12. Click OK.

  13. Click Next.

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

    Storage Manager does not support Windows authentication mode (also known as Integrated Security).

  15. Click Next.

  16. In the Error Reporting page, click Next.

  17. In the Complete page, click Close.

  18. Launch SQL Server Configuration Manager.

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

  20. Click Protocols for SQLEXPRESS.

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

  22. In the warning dialog box, click OK.

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

  24. In the TCP/IP Properties dialog box, click the IP Addresses tab.

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

  26. Select TCP Port and enter 1433.

  27. Click Apply.

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

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

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

  31. Right-click SQL Server (SQLEXPRESS) and select Restart.