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 the following sections for additional information:

• SQL Server Express and ARM

• SQL Server Express integration

Enter the credentials

1. Under SQL Server, enter the following information: 

   • SQL Server name

   • SQL Server instance

   • SQL database name (with no spaces). See Identify the SQL Server instance name for an example.

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

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