Install SQL Server Express

Install SQL Server Express

Before starting Cheel ERP, you must have installed a database management system. Database installation is an operation that is usually performed by an IT professional or a user with the necessary technical knowledge.

If you are working on a network, the SQL Server Express database manager must be installed on your Windows server. If you are not connected to a local network, you can install SQL Server Express on your Windows computer.

1. Download SQL Server Express

  1. To download SQL Server Express, open the following web page:
    https://www.microsoft.com/fr-FR/download/details.aspx?id=101064

  2. Select the French language and click on Download :

2. Change regional options

Before running the downloaded file, you need to temporarily change your PC's regional settings to French (France ). Proceed as follows:
  1. Open the Control Panel and select Clock & Region :


  2. Click on Region :


  3. In the Region form, select the French (France) format and click Apply :


    Leave this form open. You will return to it at the end of the SQL Server Express installation to restore the original French (Swiss) format.

3. Install SQL Server Express

  1. Double-click the downloaded SQL Server Express file:


  2. On the Select an installation type page, select Custom :

  3. On the Specify the target location for downloading SQL Server media page, leave the default settings and click Install :


  4. On the SQL Server Installation Center page, click New standalone installation of SQL Server or adding features to an existing installation :


  5. In the License Agreement Terms step, accept the terms of the agreement and click Next :

  6. In the Microsoft Update step, check Use Microsoft Update to check for updates (recommended) and click Next :


  7. The Installation Rules page appears. This step identifies errors that can occur while running the installer. The search results should display a warning only in the Windows Firewall line. Click Next :


  8. On the Feature Selection page, clear the " SQL Server Replication" and "Machine Learning Services and Language Extensions" checkboxes. Click Next :


  9. On the Instance Configuration page, leave the default names and click Next :


  10. On the Server Configuration page, select Grant the "Perform a volume maintenance task" privilege to the SQL Server Database Engine service . Click Next :


  11. On the Database Engine Configuration page:
    1. Enable the following authentication mode: Mixed mode (SQL Server authentication and Windows authentication)
    2. Enter the password for the user sa . Be sure to keep this password safe!
    3. Click Next .

  12. The SQL Server Express installation is complete. Click Close :

4. Restore regional options in "Swiss French"

  1. In the Region form, select the French (Switzerland) format and click OK.
    If the Region form is no longer open, refer to the Modify regional options section of this page.

5. Allow access from other computers

By default, SQL Server does not allow access from other computers. To access it from other workstations, you must first configure the firewall on the computer or server where you installed SQL Server.

Configure SQL Server to accept incoming TCP/IP connections

  1. Open the SQL Server Configuration Manager console as an Administrator (Important, otherwise some options will not be visible). For example:
    1. SQL Server 2022: C:\Windows\SysWOW64\SQLServerManager16.msc
    2. SQL Server 2019: C:\Windows\SysWOW64\SQLServerManager15.msc
    3. Click here to see other versions
  2. Navigate to SQL Server Network Configuration , Protocols for <Instance Name> .
    1. Enable the TCP/IP protocol.


    2. Open the TCP/IP Properties and open the IP Addresses tab

      1. Verify that the default TCP port ( 1433 ) is set for IPAll (or another port if SQL Server uses a custom port).
      2. Ensure that the Dynamic TCP Ports field is empty or correctly configured if dynamic ports are used.

Open port 1433 in the Windows firewall

  1. Run wf.msc to start the Windows Firewall
  2. Create a new Inbound Traffic Rule
    1. Type: Port
    2. Protocol: TCP
    3. Specific local port: 1433 (or the one you defined in the SQL Server configuration)
    4. Allow connection
    5. When: Estate and Private
    6. Name the rule (e.g., SQL Server)


Restart SQL Server services

  1. Run services.msc to start the Windows Services console
  2. Locate the SQL Server services
  3. Stop and then start the SQL Server services [Instance Name]

Warning
It is recommended to create a user with the sysadmin role to connect to the database. To create this user, please install SQL Server Management Studio (SSMS) . For instructions on installing and creating this sysadmin user, please refer to the article Installing SQL Server Management Studio (SSMS) .

Notes
Now that SQL Server Express is installed, you can install Cheel ERP and create an organization. Refer to the article Step 3 - Install Cheel ERP and create an organization .