Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Unified Supply Chain

TABLE OF CONTENTS

SQL Express setup

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedAug 14, 2026
  • 4 minute read

Note: These instructions apply to SQL Server Express 2022. The installation process may be slightly different for other versions and editions.

  1. Download the appropriate Microsoft SQL Server installer. For SQL Express 2022, download SQLServer2022-SSEI-Expr.exe from https://www.microsoft.com/en-us/download/details.aspx?id=104781.

  2. Once the file has downloaded, double-click it to launch the installer.

  3. Select Custom as installation type.

  4. Change the download location if desired and click Install.

  5. Wait for the download to complete, after which the SQL Server Installation Center opens.

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

  7. Accept the license terms and click Next.

  8. On the Feature Selection page, ensure only Database Engine Services is selected and click Next.

  9. On the Instance Configuration page, accept the default instance name of SQLEXPRESS and click Next.

  10. On the Server Configuration page, go to the Collation tab and make sure Database Engine is set to Latin1_General_CI_AS.

    SqlCollation

    If not, click Customize and change your collation options to match the following image. Click OK when finished and then Next in the main setup window.

    SqlCollationConfig

  11. On the Database Engine Configuration page, ensure the current user is specified in the SQL server administrators box then click Next.

  12. The installation of SQL Express is now complete and you may close the setup wizard.

  13. Download the SQL Server Management Studio from https://aka.ms/ssmsfullsetup.

  14. Double-click the SSMS-Setup-ENU.exe file to launch the installer.

  15. Click Install and wait for the installation to complete.

    Note: If the installation of the SQL server was performed by a member of your IT support team, or run under a separate administrative account, you must complete the following steps before running the AVEVA Unified Supply Chain installer.

  16. Open SQL Server Management Studio. In the Start menu type SQL Server Management Studio, or find the shortcut in the Microsoft SQL Server program group. Ensure you connect as a user with administrator privileges.

  17. If using SQL Server Management Studio release 20 or later, set Encryption to Optional in the Connection Security section of the Connect to Server dialog. Click the Options button to expand the dialog if you don't see this section.

  18. Type .\SQLEXPRESS in the Server name box and click Connect. The Object Explorer connects to the SQLEXPRESS server.

    Embedded Image (65% Scaling) (LIVE)

  19. Expand the Security node.

    1. Right-click Logins and choose New Login from the context menu.

      Embedded Image (65% Scaling) (LIVE)

    2. Click the search button next to Login name, type your Windows user name into the text box and click Check Names. When the correct user is found click OK.

    3. Select the Server Roles page and ensure dbcreator is selected.

  20. Click OK to create the user and close SQL Server Management Studio.