To configure an Action Knowledge Script to use SQL Server authentication, in Knowledge Scripts where it is applicable and allowed, the SQL Server login username must have its password added to the Security Manager with the proper label indicating the name of the SQL Server instance to which it will be connected from the Knowledge Script.
On the Custom tab in Security Manager, complete the following fields for the SQL Server to which a connection is to be made:
Field |
Description |
---|---|
Label |
sql$<Server Instance name> For example, if the SQL Server instance to which the Knowledge Script is to connect is SERVERTEST, you would type sql$SERVERTEST. |
Sub-label |
SQL user name that exists in the SQL Server instance. |
Value 1 |
Password for the user entered in the Sub-Label field. |
Extended application support |
Required field. Encrypts the user name and password in Security Manager. |
Windows servers running AppManager
By default, this script is only run once for each computer.
Set the following parameters as needed:
Parameter |
How to Set It |
---|---|
Event Notification |
|
Raise an event if discovery succeeds? |
Select Yes to raise an event when discovery succeeds. The default is unselected. |
Event severity when discovery succeeds |
Set the event severity level, from 1 to 40, to reflect the importance of an event in which when the discovery succeeds. The default is 25. |
Raise event if discovery fails? |
Select Yes to raise an event when discovery fails. The default is Yes. |
Event severity when discovery fails |
Set the event severity level, from 1 to 40, to reflect the importance of an event in which the discovery fails. The default is 5. |
Event severity when job fails |
Set the severity level, from 1 to 40, to indicate the importance of an event in which the Discovery_AMHealth job itself fails. The default is 35. |
SQL Server login |
Specify the SQL user name required for access to the AppManager repository (QDB). Leave this field blank to use Windows NT authentication. NOTE:If you want to use a specific SQL Server login account, use Security Manager to update the AppManager repository with the SQL Server logins that you want to use. . |