How to troubleshoot remote PowerShell with SharePoint 2013

Question

I am trying to use PowerShell ISE on my local client to access my SharePoint Farm. I am getting the error: "Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again."

I have given my account admin permissions in the: WSS_Admin_WPG on the SP Servers SharePoint_Shell_Access role on database Security_Admin role on the SQL instance db_owner role on the database (in fact I gave myself db_owner and SP_Data_Access on all of them at one point) I am also local admin on all the SharePoint servers

What am I missing?

Answer 1

When running PowerShell ISE, you need to Add-PSSnapin to Microsoft.SharePoint.PowerShell

if ($ver.Version.Major -gt 1) {$host.Runspace.ThreadOptions = "ReuseThread"} 
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) 
{
     Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

Run this script and try again.

And as always, you have to be on the server when running scripts!

Answer 2

You can't use the server object model from your client. You need to use the client object model. You can only load the snap-in on the server itself.

Download the client SDK from here: https://www.microsoft.com/en-gb/download/details.aspx?id=35585

Answer 3

Go to Start >> Type “PowerShell ISE”. Right, Click and Open PowerShell ISE with “Run as Administrator” if you have UAC enabled. Now, You can start writing your PowerShell script or copy-paste the script and then click on the “Run Script” button from the toolbar.

Hope You Find This Useful, Peter