Help banner

Modify Object - MS SQL Server Channel

The Microsoft* SQL Server Channel object stores the information the MS SQL Server driver needs to write events to an MS SQL Server database.

IMPORTANT: You must restart the logging server to effect any changes in Channel object configuration. For more information on restarting the logging server, refer to the Novell® Audit Administration Guide.

The following provides a description of each Channel object attribute:

Item

Description

Configuration

 

 

Server Name

The IP Address or host name of the database server.

 

 

Database

The name of the database to which the logging server writes events. This field is case sensitive.

IMPORTANT: This database must already exist. The SQL Server channel driver does not create the database. If no database name is specified, the logging server looks for NAudit. For information on creating the database, see "Preparing the Microsoft SQL Server Database" in the Novell Audit Administration Guide.

 

 

Table

The name of the database table to which the logging server writes events.

The SQL Server channel driver, lgdmssql, automatically creates this table when the logging server first loads the current Channel object configuration in memory. For information on the table structure, see MS SQL Server Channel.

Do not use hyphens, spaces, or other special characters in the table name. The default table name is NAUDITLOG.

 

 

Username

The user name for the account the logging server uses to authenticate with the database. This account adds records to the Microsoft SQL database.

 

 

Password

The password for the account the logging server uses to authenticate with the database.

 

 

Use SSL

(Optional) Select whether SSL should be used to encrypt data transferred between SLS and the Microsoft SQL server.

 

Status

By default, all Channel objects are enabled. This means that the logging server loads the Channel object's configuration in memory at startup.

IMPORTANT: The Channel object must be located in a supported Channel container for the logging server to find it. See Creating and Configuring Channel Objects for more information.

If you select the Disabled option, you must restart the Secure Logging Server for the setting to become effective. Thereafter, the logging server cannot load the object's configuration until you select Enabled.

 

Related Topics

MS SQL Server Channel

Creating and Configuring Channel Objects

Novell Audit Help

A trademark symbol (®, ™, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.

Close