Import-Module: The specified module ‘Microsoft.Online.SharePoint.Powershell’ was not loaded because no valid module file was found in any module directory.

Problem: When trying to add the PowerShell module for SharePoint Online, using “Import-Module Microsoft.Online.SharePoint.PowerShell”, it resulted in the below error in both PowerShell console and in PowerShell ISE. “Import-Module : The specified module ‘Microsoft.Online.SharePoint.Powershell’ was not loaded because no valid module file was found in any module directory.” Solution: 

Read more

Fix for “Cannot Connect to Database Master at SQL Server at Server Name. The Database might not exist, or the current user does not have permission to connect to it” SharePoint Error!

Problem:When trying to create a new SharePoint farm using PowerShell, the SharePoint 2016 management Shell gave an error message:New-SPConfigurationDatabase : Cannot connect to database master at SQL server at <SQL-Server-Alias>. The database might not exist, or the current user does not have permission to connect to it. I also tried using SharePoint…

Read more

An error occurred while getting information about the user “Farm Admin” at server “Domain Name”: The RPC server is unavailable

Problem: After installing SharePoint 2016 to set up a new farm, I tried running the SharePoint 2016 products configuration wizard, and the wizard failed at step 3, saying: Failed to create the configuration database. An Exception of type System.InvalidOperationException was thrown. An error occurred while getting information about the user <Farm-Admin> at…

Read more

How to Test Outgoing Emails in SharePoint using PowerShell?

While troubleshooting SharePoint Email issues, as a first step, we have to check outgoing Email settings applied on the SharePoint Central Administration site are valid. So, how to test SharePoint outgoing email quickly? Here are my PowerShell scripts to test outgoing emails in SharePoint 2013 or 2016. Method 1: Send Email using…

Read more

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

Problem: While trying to add a new user to a 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…

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, I got this error message “Object reference not set to an instance of an object”! On Checking the ULS logs, it revealed detailed errors 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,…

Read more

Fix “Unable to render the data. If the problem persists, contact your web server administrator.” Issue in SharePoint BCS

Problem: Tried created an external list SharePoint 2016 using business data connectivity services, configured secure store target application, and created an external list in SharePoint. All went well; however, the external list displayed this error message with a correlation ID. Unable to render the data. If the problem persists, contact your web…

Read more

Site Owners with Full Control Could Not Access or Edit SharePoint Group

Problem: Site Owners with full control couldn’t access or edit members of a group. Root cause: By default, only SharePoint group owners can add/remove group members, even though you have full control access rights to the site – This is by design! Solution: Change the group owner! You can either add a…

Read more

SharePoint Group Owner Cannot Add User. Gets Access Denied!

Problem:  SharePoint group owner cannot add user! group owner gets access denied. Root cause: It’s a common misconception that group owners get access automatically, as you are made the owner of the group! Just because you made someone “Group Owner” doesn’t mean they get access to the site! They can’t access the…

Read more

Fix “Drives are running out of free space” Error in SharePoint Health Analyzer

Problem: SharePoint Health Analyzer in Central Admin site gave the alert banner, “The SharePoint Health Analyzer has detected some critical issues that require your attention. View these issues”. On checking, I found “Drives are running out of free space” and “Drivers are at risk of running out of disk space” errors logged! Also,…

Read more