2.8 Configuring Security Manager Settings for the Supplemental Database

To measure the call quality of the Lync deployment, you need to store the call detail records (audio, video, and call sharing) in the supplemental database. To avoid getting an error message when running the Discovery_Lync script, with Setup supplemental database parameter selected, or when running the Lync_SetupSupplementalDB Knowledege Script, use AppManager Security Manager to store the SQL user name and password information for the SQL Server.

NOTE:

  • You can create the supplemental database only when you run the discovery or the Lync_SetupSupplementalDB Knowledge Script on a front-end pool server.

  • The following configuration is required only when you want to set up the supplemental database on a SQL server configured for SQL authentication.

On the Custom tab in Security Manager, complete the following fields for the SQL Server where you want to create the supplemental database:

Field

Description

Label

Specify the SQL Server name and the instance name of the SQL Server hosting the Lync supplemental database.

Use the following structure:

SQL$SQL Server Name\Instance Name

For example:

SQL$HOUSERVER2\DB1

Sub-Label

Specify the username. The user should have proper permissions to create the database on the SQL server.

Value1

Specify the password for the user specified in the Sub-Label field.

Extended application support

Select this option to encrypt the password in Security Manager. This option is required.