(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.

This topic is provided as an example only. Refer to the official Microsoft documentation if you install SSMS in stores.

1. Download and open the SQL Server installation package.

2. On the SQL Server Installation Center screen, click Install SQL Server Management Tools.

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

1. Click Download SSMS.

2. Click Download SQL Server Management Studio (SSMS).

3. Go to your Downloads folder.

4. Double-click the SSMS setup executable.

5. On the Welcome screen, select the location where you would like to install SSMS.

1. Click Install.

2. If prompted Do you want to allow this app to make changes to your device?, click Yes.

3. Wait while installation and configuration are completed. This may take a few minutes.

1. On the Setup Completed screen, click Close.

1. Open SSMS.

2. From Authentication drop-down, select SQL Authentication.

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.

1. Enter the Login and Password for the system account.

2. (Optional) Select Remember password.

3. From the Encryption drop-down, select Optional.

4. Click Connect.