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.