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:

• 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 Batch size drop-down to specify the number of entries to to batch insert into the log databases.
• 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.

• Click Delete to permanently delete this object.

SQL Server Properties View

Related Topics

Data Providers

Data Provider Properties

Database Monitoring Templates