Access Denied by Business Data Connectivity

Scenario:

Getting Error “Access Denied by Business Data Connectivity”, while loading the External List.

Solution:

Go to Central Administration -> Application Management -> Manage Service Applications -> Business Data Connectivity Service

Select the Store and Click on Set Metadata store permissions. […]

The Specified user is a local account

Scenario:

While running the SharePoint configuration as standalone server using local accounts, you will receive the error “The specified user is local account. Local accounts should only be used in stand alone mode”

Solution:

Use power shell to create configuration database.

Open PowerShell command prompt

[…]