Page History

The Add Server window of the Configuration wizard Specify Connection Credentials window allows you to specify configure the SQL Server instance credentials you want to use to connect to register with IDERA SQL Compliance Manager. Once you register an instance, you can begin auditing database activity on that server.

Select the SQL Server instance you want to register, and then click Next.

Available fields

SQL Server

Allows you to specify the name of the target SQL Server instance, using the format SQLServerName\InstanceName. You can also browse for available SQL Server instances in your domain.

Description

Allows you to specify a description for this instance. The Management Console uses this description when you view SQL Server properties or report on audit data. Consider including information about the databases hosted on this instance, or the organization to which this instance belongs.

...

the target server and register it. These credentials will only be used during the server registration.

Specify Connection Credentials

The following options are available for the connection:

Windows Authentication

Allows you to set a domain\username format with Windows Username and Password credentials. This option is set as default for the connection credentials.

Image Added

SQL Server Authentication

Allows you to register your SQL Server Agent credentials for the connection of the registered SQL Server.

Image Added