Configure SPDocKit Database

This article explains how to configure the database for SPDocKit.

SPDocKit uses the database for storing data gathered from your SharePoint farm. If you choose not to use a database, some of the features will not be available.

These are as it follows: Some of the Site Explorer reports, Permissions Explorer history records and Permissions reports, Content & Usage reports, report subscriptions and alerts, SPDocKit Insights feature, license management, Queries and Rules and custom made report views.

You can also document more than one SharePoint farm using the same SPDocKit database. When installing SPDocKit on desired farms, just provide the same database details for each installation and you will be able to explore multiple farm reports from each SPDocKit instance.

Please note! This should be a SPDocKit dedicated database, please do not provide SharePoint databases here.

  1. Select Configuration from the left navigation bar on the Backstage Screen and then click the Configure button.
  2. On the Database wizard page select whether to create a new database or use the existing one. Read more about the SPDocKit database requirements.
    If you wish to use a LocalDB see here for more information.

  3. On the Database Configuration wizard page specify the SQL Server, Database Name and authentication. It is possible to overwrite the existing database under the same name.

    • If you are using the default instance type "servername", or "servername.yourdomain.loc"
    • If you are using a named instance type "servername\instancename", or "servername.yourdomain.loc\instancename"
    • If your SQL Server is on a non-standard port (different from 1433), type "severname,port" or "servername\instance,port". (FQDN formats are also supported)

    After providing the information, click the Test Connection button to ensure that the settings are correct.

  4. Click Next, wait a few seconds and your SPDocKit database will be ready to use!