Verifying the SQL Server Connector Installation

Installed Services

Using Windows Service manager, or alternate tool, verify the File Access Manager services installed for the connector are available and running.

For example:

• File Access Manager Activity Monitor - <Application_Name>
• File Access Manager Permissions Collection - <Application_Name>

Log Files

You can view these error logs to check for errors:

• %SAILPOINT_HOME_LOGS%\ FilesMiniFilter_ <Application_Name>.log
• %SAILPOINT_HOME_LOGS%\PermissionCollection_<Service_Name>.log
• %SAILPOINT_HOME_LOGS%\DataClassification_<Service_Name>.log

Monitored Activities

1. Simulate activities on SQL Server.
2. Wait while activity is processed.
3. Verify that the activities display in the File Access Manager > Forensics > Activities.

Permissions Collection

1. Run the Crawler and Permissions Collector tasks Settings > Task Management > Scheduled Tasks.

2. Verify the following:

   • The tasks completed successfully.
   • Business resources were created in the resource explorer Admin > Applications > [application column] > Manage Resources.
   • Permissions display in the Permission Forensics page Forensics > Permissions.