> For the complete documentation index, see [llms.txt](https://help.security.gallagher.com/knowledge-hub/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.security.gallagher.com/knowledge-hub/configuration-client/integrated-systems/salto-lock-interface/space-installation-instructions/1-installing-microsoft-sql-server-for-use-with-the-salto-application.md).

# 1. Installing Microsoft SQL Server for use with the Salto application

To install Microsoft SQL Server for use with the Salto application, perform the following procedure:

1. Open the Command Centre installation media and navigate to the SQL Express 2019 application setup files. Located in the `'vELx.xx.xxx\Setup\SQLInstall'` folder.
2. Run the **SQLEXPR\_xxx\_ENU.exe** (32-Bit) installer as administrator.

   * SQLEXPR\_x86\_ENU.exe for 32-Bit Windows operating systems
   * SQLEXPR\_x64\_ENU.exe for 64-Bit Windows operating systems

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-02396e8281463863f65c527da8bfce5662636af3%2Fsqlexpress2019_1.png?alt=media)
3. Does the following screen display?

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-f2a7d0238f5ff06fd43b51f5a4034c43fdd20b00%2Fsqlexpress2019_2.png?alt=media)

   <table><thead><tr><th width="94">If...</th><th>then...</th></tr></thead><tbody><tr><td>no,</td><td><p>the 'SQL Server Installation Centre' application displays.</p><p>Go to Step 4.</p></td></tr><tr><td>yes,</td><td><ol><li><p>Click <strong>Yes</strong>.</p><p>The Choose Directory For Extracted Files dialog box displays.</p><p><img src="https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-bbe1291b6bd1f86bd69d177b013e79af203c86d8%2Fsqlexpress2019_3.png?alt=media" alt=""></p></li><li><p>Choose a directory to extract files to and click <strong>Ok</strong>.</p><p>The Microsoft SQL Server 2019 Express file extraction starts. Once complete, the 'SQL Server Installation Centre' application displays.</p></li></ol></td></tr></tbody></table>
4. Click Installation on the left side of this screen, then click the **New installation** or **add features** **to an existing installation** option.

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-59e258fb446fddfa9654adbb52e554cc8d888eab%2Fsqlexpress2019_4.png?alt=media)

   The 'Licence Terms' screen of the SQL Server 2019 Setup wizard displays.

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-6568ad5ff9b04fcc8c7f96321bddbc99ea5a1cff%2Fsqlexpress2019_5.png?alt=media)
5. Ensure you fully understand the terms and conditions listed in the licensing agreement you are about to enter into, then tick the box to accept and click the **Next** button.

   The 'Microsoft Update' screen displays.

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-29880ec6c10f1d50e7c9cde0813f95928c65def3%2Fsqlexpress2019_6.png?alt=media)
6. Choose whether you want to **Use Microsoft Update to check for updates**, by checking the checkbox or leave it unchecked if you do not. Click the **Next** button.

   The 'Product Updates' screen displays.

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-1fee78bf680f32802164a6f59dcb73e090f4ac1e%2Fsqlexpress2019_7.png?alt=media)
7. Click the **Next** button.

   The 'Install Rules' screen displays.

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-d402b9680f2bcdbab72910b88280e68993b492e5%2Fsqlexpress2019_8.png?alt=media)
8. Click the **Next** button.

   The 'Feature Selection' screen displays.

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-6a376142bc3416732fd0631fc7a33eb6074b5fc8%2Fsqlexpress2019_9.png?alt=media)
9. Ensure all the checkboxes are checked and click the **Next** button.

   The 'Instance Configuration' screen displays.

   ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-371832b2400fac6195b37480bae9f5d1e8727c08%2Fsqlexpress2019_10.png?alt=media)
10. Enter the name "Salto" for your instance in the **Named instance** field.

    **Note:** As you enter the Instance Name, the **Instance ID** field automatically populates also.
11. Click the **Next** button.

    The 'Server Configuration' screen displays.

    ![](https://3000903572-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfCvaxj3suxNBzdwQndVT%2Fuploads%2Fgit-blob-fda15191ed94f657324dc12f068e4b53340f191b%2Fsqlexpress2019_11.png?alt=media)
12. Change the Account Name for the SQL Server Database Engine to "NT AUTHORITY\SYSTEM", and click the **Next** button.

    The 'Database Engine Configuration' screen displays.
13. **Windows Authentication Mode** should be selected by default. Leave these settings as they are and click the **Add Current User** button if the current user is not displayed in the **Specify SQL Server administrators** list.
14. Click the **Next** button.

    The 'Installation Process' screen displays. This may take a while to complete.
15. Wait while the installation process runs through the installation automatically.

    Once the progress bar reaches the end, the 'Complete' screen displays.
16. Ensure the Status of each feature is "Succeeded" and click the **Close** button.

    The Setup wizard closes.
17. Close the 'SQL Server Installation Centre' application.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.security.gallagher.com/knowledge-hub/configuration-client/integrated-systems/salto-lock-interface/space-installation-instructions/1-installing-microsoft-sql-server-for-use-with-the-salto-application.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
