SharePoint 2013 People Picker Error: Sorry, we’re having trouble reaching the server

Problem: While trying to add a new user to SharePoint group, SharePoint 2013 People Picker displayed the error: “Sorry, we’re having trouble reaching the server” Troubleshooting: The server may not have enough resources such as Memory to process the function without timing out. Try adding more memory to your SharePoint 2013 web…

Read more

Approval Workflow Missing in SharePoint 2013?

Problem: SharePoint approval workflow not available! This happened after migrating from SharePoint 2013 to SharePoint 2016! Solution: This is due to a workflow feature not activated for the site collection. To resolve this issue, Just Activate the “Workflows” feature for the site collection. Steps in detail: Login to your the target site…

Read more

“Object reference not set to an instance of an object” Error on Creating Site Collection

Problem: On creating a new Site collection in SharePoint 2016, got this error message “Object reference not set to an instance of an object”! On Checking the ULS logs, it revealed detailed error as: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SharePoint.Administration.SPContentDatabaseCollection.FindBestContentDatabaseForSiteCreation(IEnumerable`1 contentDatabases, Guid siteIdToAvoid, Guid webIdToAvoid, SPContentDatabase…

Read more

Add Alternate Access Mapping in SharePoint using PowerShell

Alternate Access Mappings helps to expose a SharePoint web application into different URLs in scenarios such as publishing, load balancing, reverse proxy, etc. Each web application can have up to five different URLs through alternate access mapping, with “Default” zone as mandatory and other optional zones. How to Configure Alternate Access Mapping…

Read more

How to Redirect in SharePoint using Alternate Access Mapping (AAM)?

Internal URL in SharePoint Alternate Access Mapping is used to redirect from one URL to another. Say for E.g. If you want to redirect or transform from “http://portal.crescent.com” into “http://intranet.crescent.com” use this feature! So, you enter “http://portal.crescent.com” in the address bar of your browser, and it takes you to “http://intranet.crescent.com”! How to…

Read more

How to Configure Secure Store Service Application in SharePoint 2016 – Step by Step

Secure Store Service Application in SharePoint Secure store service enables you to securely store credentials required for connecting to external systems and associating those credentials to a specific identity or group of identities.  Secure Store Service solves the problem of having to sign into many applications and entering different usernames and passwords….

Read more

How to Get SharePoint Farm ID using PowerShell?

Requirement: Get SharePoint Farm ID to apply a third party product license to our SharePoint 2016 environment. How to Get SharePoint Farm ID? SharePoint farm id is a GUID which is uniquely identifies each farm. To get the Farm ID in SharePoint, use this handy PowerShell code. Just open SharePoint 2016 Management Shell…

Read more

How to Disable SharePoint Designer 2013 using PowerShell?

SharePoint Designer 2013 is a great free tool from Microsoft to customize SharePoint sites and create workflows. Why should we disable SharePoint designer? Well, In some cases site owners and designers may damage SharePoint with this Powerful utility, and I’ve seen SharePoint designers become SharePoint destroyers! So, to prevent irreversible damages to…

Read more

Add-Remove Permissions to SharePoint Group or User with PowerShell

Updating the permission level of a SharePoint group or user is fairly straightforward. To add or remove permissions levels of the SharePoint group, navigate to: Site Settings >> Site permissions Select the person or group you want to change >> Click on the “Edit User Permissions” ribbon button Select or deselect any…

Read more

Export SharePoint List Data to SQL Server Table using PowerShell

Requirement: Export SharePoint list data to SQL Server table. For an in-house built business intelligence tool, We had a requirement to export SharePoint list data into an SQL Server table. As directly querying SharePoint content databases is not supported by Microsoft, and it also could cause performance issues to your SharePoint farm…

Read more