Documentation forAccess Rights Manager

Enter the SQL Server credentials

Enter the SQL Server database credentials to set up your configuration. When you are finished verify the credentials to ensure they are valid and then identify the SQL server instance name.

See SQL Server Express and ARM for details.

SQL Server Express is not included in the ARM installation package. If you choose the Express installation, the ARM installer downloads and installs SQL Server 2025 Express, including the appropriate pre-configuration. Installs on the automatic path will require internet access, while a manual path allows you to point to a pre-downloaded installer for servers without internet access.

Enter the credentials

  1. Under SQL Server, enter the following information: 

  2. Activate the encrypted data transfer between the ARM server and the SQL server. The encrypted data transfer must first be prepared as described in the following instructions: Enable encrypted connections to the Database Engine (© 2020 Microsoft, https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sqlallproducts-allversions, obtained on August 31, 2020).

  3. The Trust Server Certificate checkbox is selected True by default. When it is selected, ARM trusts the TLS certificate presented by SQL Server without validating the certificate chain. Clear the checkbox if SQL Server uses a certificate issued by a trusted certification authority (CA) and you want ARM to strictly validate the certificate.

  4. By default, the Simple recovery mode (recommended) is configured for the Access Rights Manager database. Switching to the full recovery mode is only possible after you complete the initial configuration.

    See Switch data base recovery mode for more information.

  5. Select the type of log in method to SQL Server.

    If you select the Use Integrated Security (Windows Authentication) checkbox, Windows authentication is used with the Access Rights Manager server credentials (as explained under Quick info in the left column).

    If you do not select the Use Integrated Security (Windows Authentication) checkbox, SQL Server authentication is used. Enter the SQL Server user name and password to log in to SQL Server.
    SolarWinds recommends the use of service accounts.

Verify the credentials

  1. Click the refresh button to verify the connection to SQL Server running on your SQL database server.

  2. If your credentials are valid, ARM displays the following message:

    Test successful

Identify the SQL Server instance name

You can identify the SQL Server instance name by opening the Services console and entering the following command:

services.msc

You can install a standard SQL Server (or higher) version without assigning an instance name. This version is displayed in the Services Console as:

SQL Server (MSSQLSERVER)

In this configuration, the SQL Server Instance field must remain empty. "Local" displays in grayed out text as a placeholder.

See Switch the database recovery mode to continue the basic configuration setup.