Error occurred while trying to load ‘Problems and Solutions’ and ‘Rule Definitions’

This article describes the issue with SPDocKit Consultant not being able to load Problems and Solutions and Rule Definitions.

Problem

While trying to load the SharePoint farm the following errors occurred:

• Error occurred while loading Problems and Solutions.

• Error occurred while loading Rule Definitions.

There is an error message in the event log:

System.Data.SqlClient.SqlException: Cannot open database “SharePoint_AdminContent_bfe62573-2067-4090-a95a-39a13ba51086” requested by the login. The login failed. Login failed for user ‘CONTOSO\bob’.

Solution

The user running SPDocKit Snapshot Wizard or SPDocKit PowerShell module needs to have the proper privileges to retrieve information from the SharePoint farm. To fix this issue make sure the user has Shell access to the given content database, using the following PowerShell code to grant access:

$spcdb = Get-SPContentDatabase SharePoint_AdminContent_bfe62573-2067-4090-a95a-39a13ba51086
Add-SPShellAdmin -UserName CONTOSO\Bob -Database $spcdb