Table of Contents
- Introduction
- System Requirements
- Assign Service Logon As Credentials
- Server Configuration
- Agent-Based Monitoring
- Azure Relay Hybrid Connection
- Account Lockout Monitoring and Reporting
- Data Providers
- Directory Services
- Hosts
- Templates
- Template Properties
- Batch Update Templates
- Log Management Templates
- File and Directory Monitor Templates
- Windows Monitor Templates
- Account Lockout Monitor Template
- Logon Monitor Template
- CPU Monitor Template
- Memory Monitor Template
- Disk Space Monitor Template
- SMART Monitor Template
- Process Monitor Template
- Service Monitor Template
- Performance Counter Monitor Template
- Active Directory User Monitor Template
- Active Directory User Integrity Monitor Template
- Clock Synchronization Template
- Defragment NTFS Disks Template
- Network and Application Monitor Templates
- SSL Certificate Monitor Templates
- Email Monitor Templates
- SNMP Monitor Templates
- Monitor Hierarchy
- Reports
- Auto-Configurators
- Options
- Actions
- Filters
- Schedules
- Shared Views
- General Executable Properties
- Assign Actions
- Assign Directories
- Assign Disks
- Assign Shares
- Assign Files
- Assign Consolidated Logs
- Assign Event Logs
- Assign Active Directory Audit Logs
- Target Files and Sub-Directories
- Define Log Entry Columns
- Define CSV and W3C Log Entry Columns
- Active Directory User and Group Filters
- Explicitly Assigned Logs
- Report Columns
- Report Date/Time Ranges
- Report Security Event Log Filters
- SNMP Browser
- SSH Shell
- Exporting and Importing Configuration Objects
- Command Line Interface
- Troubleshooting
- Terminology
Microsoft SQL Server Data Provider Properties
The Data Provider Properties view enables you to view and modify a Data Provider's settings.
To view or modify a SQL Server Data Provider:
- Use the Server text box to specify the SQL Server instance.
- Use the Database text box to specify the database.
-
Use the Authentication Method drop-down to select either:
Option Description Integrated Windows Authentication Uses the service credentials to connect. SQL Server Authentication Uses a SQL Server defined user to connect. - Use the Username text box to specify the SQL Server user name.
- Use the Password text box to specify the SQL Server user's password.
- Use the Connection timeout text box to specify the maximum time to wait for an available connection in the connection pool before timing out.
- Use the Execution timeout text box to specify the maximum time to wait for SQL statements to complete before timing out.
- Check Encrypt connection to enable SQL Server packet encryption.
- Use the Encoding drop-down to enable Unicode support.
- Click the Test button to check the settings.
-
Click the Save button to save the settings.
When saving a Log Database or Log Archive Database, if the database does not exist, the database and several tables are automatically created. -
Click Delete to permanently delete this object.
Log Database and Archive Log Database objects cannot be deleted.