Authentication to SQL Server

When you select the Microsoft SQL Server database type during installation, you can choose between two authentication methods for the database engine, Windows authentication and SQL Server authentication.

The authentication requires either an SQL user or a Windows user. Each of them must be a member of certain database roles in SQL Server. For further information, see SQL Server users and application roles.

 

Method Description
Windows authentication 'Trusted connection': The user identity is confirmed by Windows.

The Scout service must be run with a user account equipped with the relevant permissions in SQL Server.1

  • In the Scout installation dialog, specify the account name in the form
    DOMAIN\username (no case-sensitivity)

    Example: INT\mmi

For the Scout installation, either a user with the relevant permissions in SQL Server or the technical user account (Log on as a service) to be used must be logged on to the Windows server system.
SQL Server authentication The username and password must refer to an SQL Server user account with the relevant user rights in SQL Server.
  • In the Scout installation dialog, specify the SQL username and password.

 

If you choose to install the Scout Enterprise Management Suite completely, three databases are required. You can configure access to the three databases in the following ways: