Skip to content

Adding an SQL Server Application

To integrate with SQL Server, you must first create an application entry in File Access Manager. This entry includes the identification, connection details, and other parameters necessary to create the link.

To add an application:

  1. Go to Admin > Applications.
  2. Select Add New to open the New Application Wizard.

Select Wizard Type

  1. Select Standard Application
  2. Select Next to open the General Details page.

General Details

  • Application Type - SQL Server
  • Application Name - Logical name of the application
  • Description - Description of the application
  • Tags - Select tags for the application from the dropdown menu, and / or type a new name, and select Enter to create a new tag. The dropdown list of tags filters out matching tags as you type and displays up to 50 tags.

Note

The tags replace the Logical container field that was used when creating applications in releases before 8.2.

  • Event Manager Server - This option is available if there are more than one event manager servers configured in the system. Select an event manager from the drop down menu.

  • Identity Collector - Select from the Identity Collector dropdown menu.

    • You can create identity collectors in the administrative client. Applications > Configuration > Permissions Management > Identity Collectors. Refer to (add link to OOTB Identity Collection) in the Collector Installation File Access Manager Administrator Guide for further details.
    • If adding a new identity collector, press the Refresh button to update the Identity Collector dropdown list.

Select Next to open the Connection Details page.

Connection Details

  • Server / Instance Path - The name of the SQL Server Instance.
  • Port - The port of the instance, or 0 - for SQL browser connectivity. Default is set to 1433.
  • Authentication Type - Select Windows authentication to use AD Credentials to re-authenticate for the given user/password. SQL Authentication is used by default.
  • Domain Name - For Windows authentication only. For SQL Authentication this field should remain empty.

  • User Name / password - Windows user name without domain, or SQL login for SQL authentication.

    Note

    Do not use the format domain\username.

  • Query Timeout (min) - In minutes. The default timeout is 0, which means ‘wait indefinitely’.

  • Activities Query - This query will periodically run to fetch new activities from the table(s) defined as containing activity records. For more information, refer to Activity Monitor Operation Principles.
  • Activity ID Column Name - The column name in the Activities Query which identifies the unique id of the activity. This column is used to query for new activities periodically
  • Business Resource Column Name - The column name in the Activities Query which will be displayed to the user as the Business Resource Full Path in the Activities Forensics
  • Domain Column Name - The column name in the Activities Query which will be displayed to the user as the Domain in the Activities Forensics. This field is optional
  • Username Column Name - The column name in the Activities Query which will be displayed to the user as the User Name in the Activities Forensics
  • Activity Timestamp Column Name - The column name in the Activities Query which represents the time the activity occurred
  • Activity Action Column Name - The column name in the Activities Query which represents the action of the activity – not mandatory

  • Sample Event Column Name - Either by Event ID or by Date.

    Note

    The SQL Server connector adds a condition to fetch only new events for each query. This condition is created with the Sample Event Column.

Select Next.