SPDocKit
Try it for FreeContact UsProduct Site
  • SPDocKit by Syskit
  • Release Notes
    • SPDocKit 12
    • SPDocKit 11.1.0
    • SPDocKit 11
    • SPDocKit 10
    • SPDocKit 9.1.0
    • SPDocKit 9
    • SPDocKit 8.0.3
    • SPDocKit 8
  • Requirements
    • SharePoint On-Premises User Permissions Requirements
    • Supported SharePoint Editions
    • System Requirements
    • Server Load Permission Requirements
    • Service Application Permission Requirements
  • Installation
    • Install SPDocKit
    • Upgrade to the Latest Version
    • Uninstall SPDocKit
  • Activation
    • Activate SPDocKit
    • Manage License
    • Activation Privacy Statement
  • Configuration
    • Configure SPDocKit
    • Configure SPDocKit Database
    • Import and Export SPDocKit Settings
  • Create SharePoint Farm Snapshots
    • Snapshots Screen
    • Manual Snapshots
    • Automatic Snapshots
  • Explore Reports & Create Documentation
    • Farm Explorer
      • Farm Explorer Screen
      • Farm Dashboard
      • Farm Explorer Reports
      • Farm Documentation
      • Passwords and Product keys
      • Generate an AutoSPInstaller XML Configuration File
      • Change the Limit on Site Topology Report
    • Site Explorer
      • Site Explorer Screen
    • Permission Reports
      • Permissions Reports screen
    • Analytics and Usage Reports
      • Analytics and Usage Reports Screen
      • Analytics Dashboard
      • Site Collection Analytics
      • Document Extensions Reports
    • Audit Reports
      • Audit Reports Screen
      • Audit Dashboard
      • Audit Log Details
      • Administrative Actions
      • Audit Settings
    • Best Practices
      • Best Practices Screen
      • Best Practices Reports
    • Subscriptions and Alerts
      • Subscriptions and Alerts
      • Create New Subscription
      • Create New Alert
    • Customizing Reports
      • Customize View
      • Add Comments
  • Compare SharePoint Configurations
    • Compare Wizard
    • Compare SharePoint Farms
    • Compare Servers
    • Compare Web Applications
    • Compare Site Collections
    • Compare SharePoint Permissions
    • Compare Web.Config Files
  • Manage SharePoint Permissions
    • Permissions Explorer Screen
    • Manage Permissions Ribbon Actions
    • Users and Groups Actions
      • Manage Groups Wizard
      • Group Memberships Wizard
      • Copy Permissions Wizard
      • Move Permissions Wizard
      • Manage Permissions Wizard
      • Remove Permissions Wizard
    • Securable Objects Actions
      • Break/Restore Permission Inheritance Wizard
      • Restore Permissions
      • Copy Object Permissions Wizard
    • Site Collection Actions
      • Site Collection Administrators Wizard
      • Permission Levels Wizard
      • Clean Site Collections Wizard
    • Add Tags
    • SPDocKit Permission Management Event Log
  • Configure & Extend SPDocKit
    • Backstage Screen
    • Options Wizard
    • License Management
    • Role Based Security
    • Extend SPDocKit
      • Install SPDocKit Extensions
      • Download SPDocKit Extensions
      • Activate SPCAF Extension
  • Query & Change SharePoint Settings
    • Queries and Rules Screen
    • Create SharePoint Governance Policy Rule
    • Create SPDocKit Query
    • Change SPDocKit Query Results Limit
    • Create Audit Queries and Rules
  • FAQ
    • Requirements
    • Installation
    • Activation
    • Configuration
    • Features
    • Security
    • Miscellaneous
    • SPDocKit Insights Removed
    • SPDocKit Insights Migration
  • Known Issues
    • CREATE TABLE permissions denied
    • Custom features missing in reports
    • Data retention not working properly
    • Distributed Cache loading issue
    • Load crashes with NullReference exception
    • Available Windows updates
    • Permissions Wizard issue
    • PowerPivot FileNotFoundException issue
    • SQL Clusters support
    • Storage Metrics report subscription
    • Unaccounted differences in the UPA settings
    • Custom Query issue with URL export
    • Recursive groups issue with export
  • Troubleshooting
    • SharePoint
      • Could not access content database
      • The service application ‘UPA Name’ does not have any proxies that are default in a proxy group
    • Server Load & User Permissions
      • RPC Server is Unavailable
      • 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
      • My permissions loading status is reported as ”Failed”
      • Service was unable to read Active Directory properties
      • SQL Server is unavailable
      • Error adding service account to "spdockit_service_role" database role
    • SQL Server Connection
      • SPDocKit won’t connect to a provided server and database
      • Configure SQL server to listen on a specific port
      • Is SQL Server configured to use a named instance
      • Inbound traffic on TCP Port 1433 needs to be allowed on the SQL
      • Service user does not have rights to connect to the SQL server
      • TCP/IP network traffic not enabled on the SQL Server
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. Troubleshooting
  2. Server Load & User Permissions

Errors while loading server information

This article explains how to handle the issues with server load.

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 I received:

Error occurred while loading server ‘ServerName’.

Solution

In order to allow SPDocKit 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 user to the Local Administrators group and how to start Windows Update service, read the .

Affected reports

  • Adding SPDocKit user accounts 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 snapshot, I received the following warning:

Loaded Server ‘ServerName’.

Solution

In order to allow SPDocKit 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 snapshot, I received the following warning:

Unable to load database permissions for ‘DatabaseName’.

Solution

In order to allow SPDocKit 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 SPDocKit accounts 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 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 in order to allow SPDocKit to successfully gather all the database permissions. 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 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 to successfully gather all the information about your Project server sites the following permissions are necessary:

  • SPDocKit 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. 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 SPDocKit accounts, follow this .

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

RPC Server is Unavailable
following article
here
link
following article