Configuring Bamboo SP Analyzer

Now that we have successfully installed and activated the Bamboo SP Analyzer solution, it’s time to configure the account that Bamboo SP Analyzer will use. The reports generated the Web Part Auditor are produced a crawl performed on the Content databases. As a result, Bamboo SP Analyzer requires at least Read access to all SharePoint Content Databases.

To begin, open Central Administration and click on Configure Analyzer within the Bamboo SP Analyzer section.  In SharePoint 2007, this can be found under the Operations tab; for SharePoint 2010, it is conveniently located on the home page of the Central Administration Web Application.

Select the type of authentication you want to perform when connecting to the Content Databases.  You can choose from:

  • Impersonate Windows Account
  • Windows Authentication (Trusted Connection)
  • SQL Server Authentication

 

Impersonate Windows Account

This authentication mode is supported for both single server deployments and multi-server farms.

When you select this option, the user name and password textbox will appear for your input. All textboxes have validations to make sure the expected strings are entered. The user name will be formatted <domainusername>. The account expected is an Active Directory account granted permission to read the database content (with at least is “db_datareader” permission).

 

Windows Authentication (Trusted Connection)

If you are running a single server (also known as standalone) deployment, this option will work for you.

If this option is selected, the logged-in account running the audit tool must match the following criteria:

  • A member of Farm Admin Group in Central Administration Web application.
  • Permission to read in content database ( at least is “db_datareader” permission).

 

SQL Server Authentication 

This authentication mode is supported for both single server deployments and multi-server farms.

When you select this option, the SQL Login Account and SQL Login Account Password user textbox will appear for your input. Enter an account created in SQL Server with permission to read the database content (with at least is “db_datareader” permission).

 

Further details on Bamboo SP Analyzer are available in the Bamboo Team Blog:


All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials Suite


Essentials Plus Suite


Bamboo Premier Suite


Project Management Suite


Knowledge Management Suite


External User Manager


 

For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!