Use this dialog to create a Spotlight Statistics Repository.

How to open this dialog

This dialog is opened from Configure the Spotlight Statistics Repository on request to Create a Spotlight Statistics Repository.

How to fill in this dialog

Authentication

This authentication is used to create the Spotlight Statistics Repository. Ensure this authentication has permission to create databases on the SQL Server instance.

Select Windows authentication (Client) to create the Spotlight Statistics Repository using the Windows credentials of the logged in user on the Spotlight Client.

Alternatively, select SQL Server authentication and fill in the User and Password fields. This SQL Server user must have permission to create databases on the SQL Server instance.

Configure repository data and log files…

Click Configure repository data and log files to change the default name of the Spotlight Statistics Repository or the location of the corresponding data and log files. By default, the repository and data log files are created in the same location as those of the model database.

Database

The name of the database.

Data File

The name and location of the corresponding data file. The file name is automatically updated when you change the name of the Spotlight Statistics Repository. Update the file name and location, if required.

Click the …button to locate the data file.

Log File

The name and location of the corresponding log file. The file name is automatically updated when you change the name of the Spotlight Statistics Repository. Update the file name and location, if required.

Click the …button to locate the log file.