Profile Manager

SharePoint Farm Reporter creates a user profile in Windows Stored User Names and Passwords applet, in order to store the SQL and Directory Server user context for report generation using Quick Reports and Power Reports feature.

The stored user profile will be useful for generating reports using SharePoint Farm Reporter under the following scenarios:

  • Using an SQL Server having a dedicated SQL user account for report generation using SharePoint Farm Reporter (highly recommended)
  • Using an SQL Server where SQL authentication mode is enabled
  • Using an SQL Server that is not part of the SharePoint domain
  • Using an alternate user account (other than currently logged on user) to connect to the Directory Server to retrieve AD information

The stored user profile persists for all subsequent logon sessions on the same computer where SharePoint Farm Reporter is installed. The stored user profiles are visible to the application under other logon sessions on the same computer.

The stored user profile created by SharePoint Farm Reporter is restricted to the Windows User Profile context. If the Windows User Profile is maintained locally, SharePoint Farm Reporter stored user profile is accessible only by the same user in the same computer. If the user who creates SharePoint Farm Reporter stored user profile, has a Roaming user account in the enterprise, the SharePoint Farm Reporter stored user profile can be accessed by the same user in any computer in the Windows enterprise.

The stored user profile is a generic credential of Windows Stored User Names and Passwords applet and can be used by SharePoint Farm Reporter application only. The credential information is stored securely in an 256 bit encrypted format in Windows Stored User Names and Passwords applet.

The stored user profile corresponding to the SQL user account will be used by SharePoint Farm Reporter application in order to connect to the SQL Server, if SQL authentication is enabled in SharePoint Farm Reporter SQL settings.

The stored user profile corresponding to the Directory Server user account will be used by SharePoint Farm Reporter application in order to connect to the Directory Server, if connect using option is enabled in SharePoint Farm Reporter Directory Server settings.

Using the Profile Manager dialog show below, new profile can be created and available profiles can be removed from the profiles list.


 

Click New button to add a new profile and a dialog will appear as shown below:

Click Remove button in the Profile Manager dialog to remove available profiles. 

Also refer SharePoint Farm Reporter Settings section.