> For the complete documentation index, see [llms.txt](https://docs.rmhpos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rmhpos.com/installation/install-microsoft-sql-server/installation-sql-server-management-studio.md).

# (Optional) Install Microsoft SQL Server Management Studio

This topic provides an example of how to install Microsoft SQL Server Management Studio. Refer to the official Microsoft documentation for complete installation instructions.

Installing Microsoft SQL Server Management Studio (SSMS) is optional. You do not need to use SSMS to backup, restore, connect, or configure the RMH store or central databases. Instead, you can use the RMH Store Administrator or RMH Central Administrator apps to manage the RMH databases. However, if you are already familiar with SSMS, you may prefer to use it for database management.

{% hint style="warning" %}
This topic is provided as an example only. Refer to the official Microsoft documentation if you install SSMS in stores.
{% endhint %}

1. Download and open the SQL Server installation package.
2. On the **SQL Server Installation Center** screen, click **Install SQL Server Management Tools**.

<div align="left"><img src="https://2921455087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fjgsd9U4TRO2qgcIBegi7%2Fuploads%2Fgit-blob-d18039051e5a5c6e6062aea4ee051b0183614c4d%2Fsql-new-sql-server-standalone.png?alt=media" alt=""></div>

The link opens a web page where you can download SQL Server Management Studio.

<div align="left"><img src="https://2921455087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fjgsd9U4TRO2qgcIBegi7%2Fuploads%2Fgit-blob-1402cf68654d85355ff641b89522947d83b1bf87%2Fssms-download.png?alt=media" alt=""></div>

3. Click **Download SSMS**.
4. Click **Download SQL Server Management Studio (SSMS)**.
5. Go to your **Downloads** folder.
6. Double-click the SSMS setup executable.
7. On the **Welcome** screen, select the location where you would like to install SSMS.

<div align="left"><img src="https://2921455087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fjgsd9U4TRO2qgcIBegi7%2Fuploads%2Fgit-blob-6e85e3968cdbd4873963b54292c533b4b9f4f71a%2Fssms-installation-location.png?alt=media" alt=""></div>

8. Click **Install**.
9. If prompted **Do you want to allow this app to make changes to your device?**, click **Yes**.
10. Wait while installation and configuration are completed. This may take a few minutes.

<div align="left"><img src="https://2921455087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fjgsd9U4TRO2qgcIBegi7%2Fuploads%2Fgit-blob-8a6fc2fd8b9bd662b2a39ae63db03d6e856925a2%2Fssms-installation-progress.png?alt=media" alt=""></div>

11. On the **Setup Completed** screen, click **Close**.

<div align="left"><img src="https://2921455087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fjgsd9U4TRO2qgcIBegi7%2Fuploads%2Fgit-blob-b97826f544989482194309111e877fb3d520b6de%2Fssms-installation-complete.png?alt=media" alt=""></div>

12. Open **SSMS**.
13. From **Authentication** drop-down, select **SQL Authentication**.

{% hint style="warning" %}
If you use Windows Authentication, the owner of the database will be the Windows user. If you use SQL Server Authentication, the owner of the database is the system account.
{% endhint %}

<div align="left"><img src="https://2921455087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fjgsd9U4TRO2qgcIBegi7%2Fuploads%2Fgit-blob-897f53284d58dbda45d1d312385f27409c7a193d%2Fssms-sql-server-connection.png?alt=media" alt=""></div>

14. Enter the **Login** and **Password** for the system account.
15. (Optional) Select **Remember password**.
16. From the **Encryption** drop-down, select **Optional**.
17. Click **Connect**.


---

# 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://docs.rmhpos.com/installation/install-microsoft-sql-server/installation-sql-server-management-studio.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.
