SharePoint Events

 ProjectReady Applications for the AEC
 06/28/16 - Webcast: Compliant Legal Document Control & Collaboration in SharePoint
 06/30/16 - Webcast: AutoCAD & Document Management, Viewing, Markup & Mobility in SharePoint
 07/01/16 - Webcast: Best New Security Features of SharePoint 2016 and SharePoint Online
 07/26/16 - Webcast: Project & Program Management Made Easy in SharePoint & Office 365
 07/27/16 - Webcast: Matter Management Engine in SharePoint & Microsoft Outlook
 07/28/16 - Webcast: Project & Program Management for the AEC with SharePoint
 07/29/16 - Webcast: Why Office 365 and the Microsoft Cloud is Ready for the Financial Services Industry
(More Links...)

 SharePoint Videos

 Best New Features of SharePoint 2016
 The Value of the Microsoft Cloud: Understanding the Scalability, Affordable Storage & Security Advantages of Office 365
 Task, Resource & Utilization Management & Reporting for the AEC with SharePoint and Office 365
 Legal Matter Task Management and Reports in SharePoint and Office 365
 What’s Coming in Office 365 & SharePoint 2016
 Automating Contract Management with Workflow in the Cloud or On-Premise
 Manage Email in the Cloud or On-Premise with SharePoint & Office 365
 Governance Essentials for SharePoint 2013 and SharePoint Online
 Easily Move Email, Files and SharePoint to Office 365
 Enterprise Workflow in the cloud with SharePoint & Office 365
 Why SharePoint 2013
 SharePoint 2013 vs SharePoint Online and Office 365 Security, Compliance and eDiscovery
 Expanding the Use, Potential and Value of SharePoint and Office 365 through 3rd Party Applications
 Keys to Successful SharePoint Initiatives and User Adoption
 SharePoint 2013 vs. SharePoint Online: Workflow
 Ensure Auditability and Compliance with Advanced Workflows in SharePoint
 SharePoint 2013 vs. SharePoint Online and Office 365: Enterprise Content Management
 SharePoint 2013 vs. SharePoint Online and Office 365: Business Intelligence
 SharePoint 2013 vs. SharePoint Online: Search
 Power Business Intelligence for SharePoint Online and Office 365
(More Links...)

 Archives ‭[1]‬

Opening SharePoint Links in a new window
Mail Enabled Lists vs. The Missing Windows 2008 POP3/IMAP Server 
7 Tools for SharePoint Developers
Public Facing Masterpage Techniques
How to Quickly Deploy and Activate a Timer Service to Your Site Collection
Custom SharePoint Master Page Feature with WSP Builder
Date Math with InfoPath
Enterprise Search Tricks and Tips Part 1
Populating Word Documents With SharePoint Data. Try The DIP!
Programmatic Deep Dive into Blank SharePoint Lookup Columns
1 - 10Next
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

        

 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