SharePoint Events

  9/03 - Webcast: SharePoint 2013 vs. SharePoint Online: Workflow
  9/04 - Webcast: Power Business Intelligence for SharePoint Online and Office 365
  9/05 - Webcast: SharePoint 2013 vs. SharePoint Online: Search
  9/30 - Webcast: Project Management Workflow in SharePoint
  10/01 - Webcast: SharePoint 2013 vs. SharePoint Online: Enterprise Content Management
  10/02 - Webcast: SharePoint 2013 vs. SharePoint Online: Business Intelligence

 SharePoint Videos

  Why SharePoint 2013
  Keys to Successful SharePoint Initiatives and User Adoption
  Out of the Box Business Intelligence and Reporting in SharePoint 2013
  Driving the Business Case and User Adoption for SharePoint
  Automate Business Processes with SharePoint 2013 and Business Connectivity Services
  SharePoint and Office 365 Migration Made Easy
  Full Lifecycle Content Management with SharePoint 2013
  Compliant Document Generation and Assembly in SharePoint
  Application of Content Security and Corporate Risk Protection in SharePoint
  How to Redline, Markup, Collaborate and Review Content in SharePoint
  Advanced Content Lifecycle and Records Management in SharePoint
  Advanced Workflow Made Easy with SharePoint 2013 and Nintex
  Full Lifecycle Content Management with SharePoint 2013
  SharePoint 2013 Solutions for the Financial Services Industry
  ProjectReady 2013: SharePoint Solutions built for the AEC
  SharePoint 2013 Solutions for the Legal Industry
  Driving the Business Case and User Adoption for SharePoint
  Investment Considerations for SharePoint 2010 and SharePoint 2013
  SharePoint 2013 and Enterprise Content Management
  SharePoint 2013 Launch
(More Links...)

 Archives

Opening SharePoint Links in a new windowUse SHIFT+ENTER to open the menu (new window).
Mail Enabled Lists vs. The Missing Windows 2008 POP3/IMAP Server Use SHIFT+ENTER to open the menu (new window).
7 Tools for SharePoint DevelopersUse SHIFT+ENTER to open the menu (new window).
Public Facing Masterpage TechniquesUse SHIFT+ENTER to open the menu (new window).
How to Quickly Deploy and Activate a Timer Service to Your Site CollectionUse SHIFT+ENTER to open the menu (new window).
Custom SharePoint Master Page Feature with WSP BuilderUse SHIFT+ENTER to open the menu (new window).
Date Math with InfoPathUse SHIFT+ENTER to open the menu (new window).
Enterprise Search Tricks and Tips Part 1Use SHIFT+ENTER to open the menu (new window).
Populating Word Documents With SharePoint Data. Try The DIP!Use SHIFT+ENTER to open the menu (new window).
Programmatic Deep Dive into Blank SharePoint Lookup ColumnsUse SHIFT+ENTER to open the menu (new window).
1 - 10 Next
Business Data Connectivity Service Application (BDCS, BCS), Secure Store Service Application (SSS), and Permission Errors

By: Arjun Chakraborty

 

If you are reading this article, I bet it’s because you ran into an error while viewing a SharePoint External List.  Here are the 3 errors I most commonly run into, and their fixes:

 

1. User does not have permissions in the BCS content type:

 

BDCS_BCS_SSS_and_Permission_Errors

 

If you see this error in the External List, associated with the external content type, then that means you have to give the current user permission in the BCS service application.

 

Go to Central Administration -> Application Management -> Manage Service Applications.  Find the Service Application for BCS, and click on Manage.

 

BDCS_BCS_SSS_and_Permission_Errors

 

Select the BCS content type, and then press Set Object Permissions.  Then, add that user (or better yet, an AD group which has all the necessary users), and give it the ‘Execute’ permission.

 

BDCS_BCS_SSS_and_Permission_Errors

 

 ========== OR ===========

 

Instead of selecting the Content Type, simply press Set Metadata Store Permissions.  Then, add the user (or group), and make sure to check Propagate permissions to all BCS Models, …  If you have multiple content types, all with the same target audience, then this is the best idea.  However, only do this if you know the other BCS content types will not have their own unique permission settings.  Going forward, all new external content types will also use this user-permission configuration.

 

2. The End User or BCS User does not have permissions on the SQL Server/database:

 

BDCS_BCS_SSS_and_Permission_Errors

 

BDCS_BCS_SSS_and_Permission_Errors

 

BDCS_BCS_SSS_and_Permission_Errors

 

If you are seeing these errors in the External List, then there are permissions missing on the SQL server.  If the external content type is set to use the user’s credentials, then the user does not have read/write access to the database (write is not necessary if only Read List and Read Item operations are used in the content type).  If the external content type is set to use a secure store service account (more typical), then the account stored in secure store service does not have permission on the SQL database.

 

To fix this, simply give the mentioned user (in this case, “Dev\test02”) the necessary permissions on the database, or re-enter the credentials used by the SSS account.

 

3. The user does not have permission to use the Secure Store Service account:

 

BDCS_BCS_SSS_and_Permission_Errors

 

This is similar to (1), but instead of the BCS, the user needs permissions on the Secure Store Service account entry.

 

Go to Central Administration -> Application Management -> Manage Service Applications.  Select the Secure Store Service, and press manage:

 

BDCS_BCS_SSS_and_Permission_Errors

 

Select the secure store account you are using with the BCS connection, and press edit:

 

BDCS_BCS_SSS_and_Permission_Errors

 

Keep pressing next until you reach this screen:

 

BDCS_BCS_SSS_and_Permission_Errors

 

You need to add the end user to the Members section (bottom).  Better yet, add an AD group that has all the users who need to see the external list:

 

Press OK to finish.

 

You can also see who has rights to use this SSS account by selecting the account and pressing the Set Credentials button.

 

BDCS_BCS_SSS_and_Permission_Errors

 

BDCS_BCS_SSS_and_Permission_Errors

 

Hope that helps.

 

By: Arjun Chakraborty

        

Comments

nobname

goob job
at 4/22/2012 7:05 AM

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Your Name *


e-mail address *


Website (optional)


Comment *


Attachments

 Subscribe

  GigWerks RSS  Gig Werks Mailing List 

 Contact Us

 Connect

 Resources

  On Demand SharePoint Webcast Recordings
  Upcoming Webinars
  SharePoint Resources
  Business Intelligence Resources
  Gig Werks Website



©2009 Gig Werks. All rights reserved. Privacy Policy