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(For Scout Enterprise Management Suite 15.5 and later versions, gMSA (Group Managed Service Accounts) are also supported)). | |
In the Scout installation dialog, specify the account name in the form DOMAIN\username (no case-sensitivity) Example: INT\mmi
|
|
| Note: 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:
-
If the same authentication method is used for all databases, you can configure different users for each database.
-
If the same user is used for all databases, you can configure different authentication methods for accessing each database.