How to create a Microsoft SQL Server Express instance called SOPHOS

  • Article ID: 111835
  • Rating:
  • 9 customers rated this article 3.2 out of 6
  • Updated: 20 Aug 2015

As part of troubleshooting installation problems or as a workaround, it may be necessary for you to manually create a Microsoft SQL Server named instance before installing PureMessage or Enterprise Console. This article will take you through step by step how to create a 'SOPHOS' named instance.

Known to apply to the following product:

PureMessage for Microsoft Exchange
Enterprise Console

What To Do:

  1. Having run the installer of Enterprise Console (E.g. sec_521_sfx.exe) on the computer, depending on the version of Enterprise Console, navigate to ([SQLversion] should be replaced by whatever version is listed in the SEC installer):
    • C:\sec_[Version]\ServerInstaller\pre-reqs\sqlExpress[SQLversion]\

    Note: you can also download the latest version of Microsoft SQL Server Express from:‎.  If doing so, you should check the version you are downloading is supported by the Sophos product you are going on to install later.  For more information, see article 118620 for details on the system requirements of Sophos products.

    If you are installing a SQL Server Exress instance to use with PureMessage, navigate to extracted location: "C:\pmex_[Version]\resources\".

  2. Double click either:
    • 32-bit: SQLEXPR32_x86_ENU.exe (Use this if you are on a 32-bit OS)
    • 64-bit: SQLEXPR_x64_ENU.exe (Use this if you are on a 64-bit OS)

  3. The pre-requisite check will run and at the end will prompt to install anything missing. If there are any errors, these will need to be resolved before the installer can proceed. If all pre-reqs are installed, the 'SQL Server Installation Center' window will appear.

  4. Click on the Installation link on the left-hand side.

    There may be a slight variation between the versions of SQL Server Express.
  • SQL Server Installation Center
  1. Click on 'New installation or add features to an existing installation'.
  2. The installation will run through the 'Setup Support Rules', confirming SQL can install on this machine.
  3. Correct any failures.
  4. Once passed click on 'OK' to continue.
  • Setup Support Files
  1. Click on 'Install'.
  2. Click 'Next'.
  3. Specify a free edition will be automatically selected. Enter the product key will be greyed out
  4. Click 'Next'.
  • Setup Support Files
  1. Click 'Install'
  2. Setup Support Files will install
  3. Click 'Next' 
  • Feature Selection
  1. Tick the 'Database Engine Services' box
  2. Click 'Next'
  • Instance Configuration
  1. Change the Named instance from SQLExpress to SOPHOS
  2. Click 'Next'
  • Disk Space Requirements
  1. Click 'Next'
  • Server Configuration
  1. Ensure the 'Account Name' for the 'SQL Server Database Engine' is set to an appropriate account. E.g. 'NT AUTHORITY\NETWORK SERVICE' and it is set to 'Automatic' startup.

     'NT AUTHORITY\SYSTEM' may also be used but typically has more rights than are required.  It is also required on a Domain Controller even though Microsoft doesn't recommend install SQL on a Domain Controller.

  2. Click 'Next'
  • Database Engine Configuration
  1. Ensure 'Windows authentication mode' is selected under 'Account Provisioning'.
  2. Click on 'Add Current User' (or click the Add button and add the Administrator user).
  3. Click 'Next'.

    Note: It is recommended to store SQL "Data" and "Logs" directories on different physical drives in order to maximize performance.
  • Error and Usage Reporting
  1. Tick which reports you wish to send to Microsoft. Leave un-ticked if you do not wish to send reports.
  2. Click 'Next'.
  • Installation Configuration Rules
  1. Click Next
  • Ready to Install
  1. Click Install
  2. The Installation will start
  3. Click 'Next' when complete
  • Complete
  1. Click 'Close'

Your SQL Server installation should have completed successfully. You may be prompted for a reboot. Press OK to this message then reboot the server.

If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent