SQL Server Settings 

Dockit SharePoint Manager uses SQL Server database for its data storage to generate SharePoint reports. A single SQL database can also be consumed by more than one Dockit SharePoint Manager at a time.

Once the application is launched for the very first time, Dockit SharePoint Manager will ask you to configure the application database as shown below:



Note: Dockit SharePoint Manager’s 1.1.6397 and its earlier versions database is not compatible with the latest version 1.2.x Unless delete the earlier versions databases, you are not able to work with Dockit SharePoint Manager latest version.

Manual Configuration:

Select Manual Configuration if you want to configure the application database by yourself. This option helps you create a dedicated application database based on SQL Server settings provided in the dialog as shown below:



Steps:

  • Enter SQL Server name.
  • Enter a database name that Dockit SharePoint Manager uses to create its application database for its storage.
  • Select the authentication mode (Windows or SQL) for the specified SQL server.
  • Depending on the selected authentication mode, enter SQL or Windows Username and Password.
  • Select suitable Database Truncation Settings.
  • Click to save the settings.

User Authentication

To connect to SQL Server, Dockit SharePoint Manager uses the relevant user accounts based on the authentication mode as listed below:

  1. Windows Authentication:
    In this method, Dockit SharePoint Manager uses the currently logged on user account while running the reports to authenticate the user in SQL Server.

  2. SQL Authentication:
    In this method, Dockit SharePoint Manager uses the specified SQL user account and password for running reports. It stores the SQL username and password as a user profile in 'Stored Usernames and Passwords' applet for its usage.

Note: Dockit SharePoint Manager expects the user account to have sufficient privileges to create, add to and delete database in the SQL server.

Database cleanup

Dockit SharePoint Manager can enable to truncate the application database for every scheduled intervals. If you want to truncate the application database automatically, you can simply check the Perform database truncation every [10] days option. You can specify the repeat intervals based on your requirements. The truncation will usually commence once you launch the application at the specified intervals.

Note:

Based on Microsoft TechNet article https://technet.microsoft.com/en-us/library/ms189493(v=sql.105).aspx , to truncate the database, switching recovery model from Full to Simple is the only way to shrink the database and log files to the least possible size and reclaim the used disk space. Once shrink completed again, switch to Full for production. Please consult with your DB administrator about changing the database recovery mode.

Import Configuration:

Select Import Configuration option if your organization is currently using Dockit SharePoint Manager and you want to quickly configure the application using the same application database and configuration. You can get the configuration information as a XML file from your SharePoint Administrator.



Import Configuration Dialog will appear as shown below:



Steps:

  • Select or enter a valid location, where the exported configuration file has been stored.
  • Click button to import the configuration.

Note:

If the application database is configured to use SQL Server authentication, Dockit SharePoint Manager will require the password for the SQL user specified in the configuration file.

The Password dialog will appear as shown below: