Enterprise SIEM, Centralized Log Management, Security, Compliance, Server Monitoring and Uptime Monitoring Software
Table of Contents

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:
    OptionDescription
    Integrated Windows AuthenticationUses the service credentials to connect.
    SQL Server AuthenticationUses 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.

Related Topics

Data Providers

Data Provider Properties

Database Monitoring Templates