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 hostname and 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.
  • When using SQL Server Authentication:
    • 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.
  • Use the Maximum connection pool size text box to specify the maximum number of connections to allow. The default value is 100.
  • Check Encrypt connection to enable SQL Server packet encryption.
  • Check Hash Mode to add hashing to each saved log entry often used in Italy to fulfill government compliance requirements.
  • 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.
    Information When saving a Log Database or Log Archive Database, if the database does not exist, the database and several tables are automatically created.
    Alert We have seen cases where after creating the database an access denied error is immediately thrown. If this occurs, click the Save button again. If the error persists, verify the authentication method is valid. Make sure to configure both your primary and archive log databases.
  • Click Delete to permanently delete this object.
    Alert Log Database and Archive Log Database objects cannot be deleted.
    SQL Server Properties

Related Topics

Data Providers

Data Provider Properties

Database Monitoring Templates