The Index Database Wizard assists you in creating or selecting an index database.

In the first step, select the database connection: SQLite as the single-user database or Microsoft SQL Server as the multi-user database.

In the second step, enter the required connection settings for write access to the index database. Click on Test connection to test the selected settings. This only checks whether the index server can be accessed using the connection settings and whether the ODBC driver version is compatible with the Microsoft SQL Server version.

In the third step, the wizard checks if the pre-selected index database is available. If not, you can create the database. Otherwise, the database can be deleted and recreated. You need to have administrator rights to do this (member of the sysadmin role). When creating the index database, the user role db_index_reader is created, which are assigned to the user for reading the database. The db_owner role is required in order to write to the database.

In the fourth and final step, the wizard checks whether write-access is available to the index database using the selected connection settings. The user name and password can be changed if necessary.

See Also

Data Explorer Option

Setting Up File Indexing

Setting Up File Indexing in Client/Server Mode

Data Explorer Window