Configuring authentication methods
There are two modes of authentication that Agile Service Manager can use to discover an SQL Server.
Windows integrated security authentication.
- Install SSH on the Agile Service Manager gateway as required.
- For discovery that uses a gateway, enable WMI on all target Windows systems. WMI is enabled by default.
By default, discovery using a gateway automatically installs the Agile Service Manager WMI Provider on all target Windows systems during the discovery process.
Discovering a SQL Server requires that the Windows Server must be discoverable, but also requires that additional access is granted to Agile Service Manager.
There are two modes of authentication that Agile Service Manager can use to discover an SQL Server:
- Windows authentication
- For Windows authentication, you must meet the following
requirements:
- The Windows user used for the discovery of the SQL
Server must have the
Allow Log on Locallyuser right on the gateway server. - The user must have privileges to log on to the SQL Server system. Preferably the user is a domain user and the server system trusts the domain of the gateway server.
- Add the Windows user and password to the access list for the SQL Server.
- The Windows user used for the discovery of the SQL
Server must have the
- SQL Server authentication
- For SQL Server authentication, add the SQL Server user to the access list for the SQL Server.
To determine the type of authentication you need to use, verify with your SQL Server administrator which mode the SQL Server is running. Mixed mode supports both types of authentication.