When attempting to insert the Confluence Federated Search Web Part in a Sharepoint Page, you receive an Unknown Error

The content on this page relates to platforms that are not supported for Confluence. Consequently, Communardo cannot guarantee to provide any support for the steps described on this page. Please be aware that this material is provided for your information only and that you use it at your own risk.

Problem

When attempting to insert the Confluence Federated Search Web Part, you receive an "Unknown Error" during the configuration of the Web Part and cannot insert it:

ERROR: Unexpected Error
Unable to perform the requested action. Please check your SharePoint and Confluence log for more details.

In newer versions of the Legacy Sharepoint Connector, you may also receive the following message as the details for the error:

The error message reported was: There was an exception in the Database. Please retry your operation and if the problem persists, contact an administrator.

Symptoms

The result sources in the configuration for the Web Part are empty, despite result sources being configured in Central Administration.

Diagnosis

You must examine your SharePoint Logs to look for the specific database error message. Typically, the account used by the search application (or by Sharepoint) doesn't have permission to log into the Sharepoint Search database. An example log:

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "<database-name>" requested by the login. The login failed. Login failed for user '<username>'.

Cause

The user account specified does not have permission to log into the database specified.

Resolution

Always back up your data before performing any modification to the database.

The user account listed in the error message must be granted access to the database that was specified. See this MSDN Article for more information.

There is no content with the specified labels