SPDocKit Consultant
Try it for FreeContact UsProduct Site
  • SPDocKit Consultant by Syskit
  • Product Updates
    • SPDocKit Consultant 12
    • SPDocKit Consultant 11.1.0
    • SPDocKit Consultant 11
    • SPDocKit Consultant 10
    • SPDocKit Consultant 9.1.0
    • SPDocKit Consultant 9
    • SPDocKit Consultant 8.0.3
    • SPDocKit Consultant 8
  • Requirements
    • SharePoint On-Premises User Permissions Requirements
    • Supported SharePoint Editions
    • System Requirements
    • Server Load Permission Requirements
    • Service Application Permission Requirements
  • Installation
    • Installation Guide
    • Upgrade to the Latest Version
    • Uninstallation Guide
    • PowerShell Guide
  • Activation
    • Activation Privacy Statement
    • Online Activation
    • Offline Activation
    • Manage License
    • Activation FAQ
    • Consultant License FAQ
  • Get To Know SPDocKit Consultant
    • Backstage Screen
      • Options Wizard
      • Compare Wizard
    • Farm Explorer Screen
      • Farm Dashboard
      • Farm Explorer Reports
      • Passwords and Product keys
    • Best Practices Screen
    • Snapshots Screen
    • PowerShell Commands
  • How To
    • Create Snapshot
    • Farm Documentation
      • Create Farm Documentation
      • Customize Documentation Template
    • Compare Wizard
      • Compare Farms
      • Compare Servers
      • Compare Web Applications
      • Compare Site Collections
      • Compare Web.Config Files
    • Best Practices
      • Available Best Practices Reports
      • Create Custom Best Practices Reports
      • Personalize Best Practices Reports
    • Generate an AutoSPInstaller XML Configuration File
  • FAQ
    • Miscellaneous
    • Security
    • Troubleshooting
      • RPC Server is Unavailable
      • Could not access content database
      • Error occurred while loading Web Application
      • Error occurred while trying to load ‘Problems and Solutions’ and ‘Rule Definitions’
      • Error while loading IIS Settings Information
      • Errors while trying to load the SharePoint farm
      • Errors while loading server information
      • Failed at retrieving SQL Accounts from the following servers
      • The service application 'UPA Name' does not have any proxies that are default in a proxy group
      • SQL Server is unavailable
  • Known Issues
    • CREATE TABLE permissions denied
    • Distributed Cache loading issue
    • Load crashes with NullReference exception
    • Available Windows updates
    • PowerPivot FileNotFoundException issue
    • Unaccounted differences in the UPA settings
Powered by GitBook
On this page
  • SharePoint Server Information
  • Problem
  • Solution
  • Affected reports
  • SQL Server Information
  • Problem
  • Solution
  • Problem
  • Solution
  • Affected reports
  • Project Server
  • Problem
  • Solution
  • Affected reports
  • Learn more

Was this helpful?

  1. FAQ
  2. Troubleshooting

Errors while loading server information

This article gives you an overview of possible issues that might occur while gathering information about farm servers.

PreviousErrors while trying to load the SharePoint farmNextFailed at retrieving SQL Accounts from the following servers

Last updated 2 years ago

Was this helpful?

SharePoint Server Information

Problem

While trying to load SharePoint farm settings with SPDocKit Consultant I received:

Error occurred while loading server ‘ServerName’.

Solution

In order to allow SPDocKit Consultant to successfully gather all the information about your SharePoint farm servers, the following permissions are necessary:

  • Local Administrator on the server

  • Windows Update service up and running

For more information on how to add the SPDocKit Consultant user to the Local Administrators group and how to start Windows Update service, read the .

Affected reports

  • Adding SPDocKit Consultant user account to the Local Administrator group on the server is needed for WMI remote access and to get information about Windows updates. In case you can’t give that kind of permissions due to security requirements, see lower for what you can grant instead this. The following reports will not be available:

    • Farm Explorer -> Servers in Farm -> Processors Info

    • Farm Explorer -> Servers in Farm -> Programs List

    • Farm Explorer -> Servers in Farm -> Available Windows Updates

    • Farm Explorer -> Servers in Farm -> Disks List

    • Farm Explorer -> Servers in Farm -> Local Admins

    • Best Practices -> Hardware Requirements -> Free Disk Space

    • Best Practices -> Hardware Requirements -> RAM

    • Best Practices -> Servers -> Hotfixes per Server Role -> all reports

  • To retrieve a list of available Windows updates please make sure that the Windows Update service is up and running. If the service is disabled or not running the following reports will not be available:

    • Farm Explorer -> Servers in Farm -> Available Windows Updates

    • Best Practices -> Updates -> Servers -> Windows Updates

SQL Server Information

Problem

While trying to create a SPDocKit Consultant snapshot, I received the following warning:

Loaded Server ‘ServerName’.

Solution

In order to allow SPDocKit Consultant to successfully gather all the information about your SQL servers the following permissions are necessary:

  • Sysadmin server role

Problem

While trying to create a SPDocKit Consultant snapshot, I received the following warning:

Unable to load database permissions for ‘DatabaseName’.

Solution

In order to allow SPDocKit Snapshot Wizard or SPDocKit PowerShell to successfully gather all the database permissions the following permissions are necessary:

  • db_owner database role on each of the affected databases.

To eliminate this warning, you either have to grant the necessary permissions to the account running SPDocKit Snapshot Wizard or SPDocKit PowerShell or turn off the load Database Permissions option.

If you wish to turn off the load Database Permissions option, do the following:

  1. Select Configuration from the left navigation bar on the Backstage Screen and then click the Options button.

  2. On the SPDocKit Consultant Options dialog select Snapshot Options.

  3. Under the Security section uncheck Database Permissions.

Affected reports

Sysadmin database role is needed to run system extended stored procedures on the Master system database. Without the Sysadmin role, the following reports will not be available:

  • Farm Explorer -> SQL -> Always On reports

The Public server role is needed to fetch the real SQL server name. This permission is necessary to connect to the SQL server and perform some basic T-SQL queries. Also when you add an account to the SQL server, public role is automatically granted. If you are not granted this role, the following reports will not be available:

  • Farm Explorer -> SQL -> SQL Aliases

  • Best Practices -> Databases -> SQL Aliases

Dbcreator role and VIEW SERVER STATE permission is necessary in order to load SQL server configuration data. Following reports will not be available:

  • Farm Explorer -> SQL -> all reports

  • Best Practices -> Databases -> Database Files

  • Best Practices -> Databases -> Max Degree of Parallelism

  • Best Practices -> Databases -> SharePoint Database Autogrowth

  • Best Practices -> Databases -> TempDB -> all reports

Dbaccess permission is necessary in order to load information about the model database. In case this permission is not granted, the following reports will not be available:

  • Best Practices -> Databases -> ModelDB -> ModelDB Files Autogrowth

  • Best Practices -> Databases -> ModelDB -> ModelDB Files Initial Size

  • Best Practices -> Databases -> ModelDB -> ModelDB Recovery Model

Db_owner database role on each of the affected databases is necessary to allow the account running SPDocKit Snapshot Wizard or SPDocKit PowerShell to gather all the database permissions successfully. In case this permission is not granted, the following report will not be available:

  • Farm Explorer -> SQL -> Database Permissions

Project Server

Problem

While trying to load Project server site settings with SPDocKit Consultant I received:

The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was 'NTLM'.

Solution

In order to allow SPDocKit Consultant to successfully gather all the information about your Project server sites the following permissions are necessary:

  • SPDocKit Consultant account needs to be a member of the Project Server Administrators group on each of the Project server sites

Affected reports

The mentioned permissions on your Project server sites are optional, but depending on them some or all information about your Project server sites configuration reports will not be available in SPDocKit Consultant. Without the above-mentioned permissions, the following reports will not be available:

  • Farm Explorer -> Project Server -> all reports

Learn more

In case that you can’t give those permissions due to security requirements, there are some alternatives available. More information on how to grant the required permissions is available .

If you wish to grant the necessary permissions to the account running SPDocKit Snapshot Wizard or SPDocKit PowerShell, follow this .

Take the steps described in the to grant the required permissions.

RPC Server is Unavailable
following article
here
link
following article