Enter SQL server credentials

Enter the SQL server name, the name of the instance and the data base (no spaces allowed).

Please note additional information to the SQL instance name.

By default, the simple recovery mode (recommended) is configured for the ARM data base. Switching to the full recovery mode is only possible once the initial configuration has been completed (also see: switch data base recovery mode).

 

 

Specify the type of logon to the SQL server.

Option enabled

Windows authentication is used with the credentials of the ARM server (on the left-hand side)

Option disabled

SQL server authentication is used. Enter user name and password to log into the SQL server.

Please see additional notes and references for the use of service accounts.

 

  1. Click the button to verify the credentials.
  2. If valid credentials have been entered, ARM displays the message "Test successful".

 

Identify the SQL server instance name

The instance name can be identified by using the services console:

services.msc

 

EXCEPTION:

A standard SQL server (or higher) can be installed without assigning an instance name. This will then be displayed as "SQL Server (MSSQLSERVER)" in the services console. In this scenario the SQL server instance field must remain empty when using the ARM basic configuration. The word "(local)" is shown in grey as a placeholder.