Wonder if you could shed some light on a variant of this situation I'm experiencing.
Typical Error when running Sharepoint Management Shell "the local farm is not accessible. CmdLets...."
Here's the scenario:
POC situation. 2 servers
web front-end (sharepoint 2010 fully updated installed here)
db / app server (sharepoint 2010 fully updated installed here, as well as sql 2012 fully updated)
Username Joe is local admin on both boxes, sysadmin on the sql server and has shell-admin role applied. Username Joe can on web front-end, but cannot use sharepoint management shell on db / app server.
Powershell version is 2.0 on both boxes - double-checked -version 2 is added in the short-cut
Tried import system modules (get the same error)
Tried Run-as-administrator (get the same error)
double-checked local administrators membership
double-checked UAC off
ExecutionPolicy is the same on both boxes.
db server role is "sysadmin".
db-shell-admin role has been applied and removed and applied and removed ... using Add/Remove-SPShellAdmin (incidentally - regardless of this setting, the web front-end has no issues with powershell administration - pressumably since user Joe is a sysadmin).
Anything I've missed?