Access denied by Business Data Connectivity - BCS - Resolved

Create an External Content type based on backend SQL Server Database and create an External list based on it.

Open the Site in SharePoint Designer 2010: http://portal.contoso.com

Provide username and password in the promotion for open the site

Opening the site http://portal.contoso.com by communicating with the Web service

Retrieving External Content type Report

Create new external content type: Define General Properties for External Content type

Content type name: Contact; Name Space: http://portal.contoso.com; Office Item Type: Contact; Enable offline Sync to External list 

External System: Click here to discover external data sources and define operations 

Add Connection 

Managing Connections to external data sources and the operations for this external content type

External Data Source Type Selection: SQL Server -> Open the SQL Server Connection

SQL Server Connection: Populate the Database Server and Database name in the box

 Navigate to the appropriate database (AdventureWorks) and scroll through the required table (Contact)  

Table: Verify the available operations for that table

Operations for External content type means action that can be performed on the data associated with the external system -> Click on Create all Operations

Specify the parameters for the Operation

Example: Get the “Last Name” parameter-> Office property: Last Name; Check the Show in Picker box.

Filter Parameter Configuration

Add Filter Parameter: Add a Limit filter to the Query Item List Operation

Add Filter Type: Limit (Strongly Recommended to add a filter of type ‘Limit’ for this operation type)  

Filter Filed: None; Default value given as “100” for the limit filter type

Save the Content type to the Business Data Connectivity Metadata Store

Create an External List for the External Content type

External List : Business Contacts ; System Instance : AdventureWorks

External List: Business Contacts Created

Set Business Connectivity Store Permissions

List and Libraries -> External List-> Business Contacts -> Open Preview in Browser

Access is being denied by Business Data Connectivity Service (Reason: There is no permission for viewing this list)

Set the permission: Open CA->App mgmt. ->Manage Service Applications-> Business Data Connectivity Service->Manage->Set Metadata Store Permissions 

 Add Contoso\Administrator and feed all the (Edit, Execute, Selectable in Clients, Set Permissions) permission to the user.

Propagate permissions to all BDC Models, External Systems and External Content types in the BDC Metadata Store.

Work with External Content type in the Browser: Navigate to the http://portal.contoso.com

List will display with the no permission error now

Edit Item: Edit any of the lists and include any data in the list.

Example: Data Included in one of the List

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product Applies To:
- SharePoint 2010
- SharePoint 2013

connect to office disabled in sharepoint 2010

Connect to office is a very vital feature if you are working with lots of libraries and lists. One of our users reported an issue that he is not able to use the ‘connect to office’ drop down menu.

Desktop entities:-

Windows 7 OS

IE 9 32-bit

Office 2010 32-bit

SharePoint Server 2010

Problem description was not clear so further probing, we came to know this option is disable/greyed out. Strange! No ideas as I have never used this functionality before the issue actually reported to my team.

I started my research by learning the default functionality:

http://office.microsoft.com/en-in/sharepoint-foundation-help/connect-to-office-HA102080653.aspx

Issue description:-

Connect to office disabled / Connect to office disabled is greyed out.

Error message:-

Connect to office, this control is disabled.

Note:-

Before you start troubleshooting on this issue, make sure that you have enough set of permission to perform this activity.

Troubleshooting done:-

1)   Cross-checked the office version is 32-bit or not. It should be 32 bit only and not a 64-bit.

2)   Cross-checked the IE version is 32-bit or not. It should be 32 bit only and not a 64-bit.

3)   Tried opening the SharePoint site in Mozilla Firefox as well as Google chrome but same results i.e. option is disabled.

4)   Repaired the office version but that didn’t resulted any success.

5)   Tried enabled-disabling add-ons in internet explorer but no success

6)   Tried adding the SharePoint site in trusted location by means of IE but still no results.

7)   Checked on different desktops who were using IE 7, 32-bit as well as Office 2013, 32 bit but no results

Resolution:-

After the exhaustive troubleshooting for hours then I got the following article and I wanted to convey my Million Thanks to Mr. Brian for sharing this valuable information with all of us: http://mywinsysadm.wordpress.com/2011/07/28/sharepoint-connect-to-office-for-new-document-creation

As per this article- MySites must be configured with the Use Personal Features permission turned on.  You can enable this by going into the Central Administration Console, click on Manage Service Applications, click the link for the User Profile Service Application, and select Manage User Permissions.

That’s it. I got the direction, followed as per the mentioned instructions and the issue has been comes to an end. Happy SharePoint!

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

To export a list, you must have a Microsoft SharePoint Foundation-compatible application - SharePoint 2010 + SharePoint 2013

The export to Excel button is available but when I select the following error appears:
 
Error message: To export a list, you must have a Microsoft SharePoint Foundation-compatible application

 
Let me tell you guys that this section is very widespread and can be happen because of so many reasons. I don’t want to restrict this thread with only one solution as while debugging on this issue, I have explored so many options and would like to share all the options with you so that you can take a benefit of this and issue can be resolved in easy as well as proficient manner.

I am going to elaborate this information in step by step manner so in case of any queries/questions regarding any step then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Multiple Resolutions:

1)   Make sure the Office client should be installed on the machine.

2)   Make sure the web client service in started mode, How to check this: On your machine- Start-Run-services.msc-start the webclient service.

3)   Make sure the IE (Internet Explorer) Version should be 32-bit and not a 64-bit. How to check this: http://www.tracker-software.com/knowledgebase/280-How-do-I-tell-if-I-am-using-a-32-bit-or-64-bit-version-of-IE    

4)   Make sure the client integration is Enabled in Central Administration

How to check this: Central Administration-Manage web applications-Ribbon-Authentication Providers-Client Integration check box.

5)   Make sure the STSSYNC add-on should be enabled in IE. How to check this: Open IE-Tools-Manage Add-Ons-Look for the STSSYNC add-on and enable it.

6)   Make sure this option “Enable additional actions and Online Status for members” in Central Administration is set to Yes. How to check this: Open the Central Administration page-Click on Manage web applications-Select the web application you would like to configure-From the ribbon select General Settings-In the section titled Person Name Actions and Presence Settings change the setting Enable additional actions and Online Status for members to Yes-Click OK to apply changes.

7)   Make sure the ActiveX Control is enabled in Internet Explorer. How to check this- Open IE-Tools-Manage Add-Ons-Look for the STSUpld UploadCtl Class add-on and enable it.

8)   Make sure the Internet Explorer settings should not be too high. How to check this: http://windows.microsoft.com/en-in/windows-vista/change-internet-explorer-security-settings

9)   Make sure the protected mode should not be enabled in Internet Explorer. How to check this: Open internet explorer- Click on Tools menu and select Internet Options- Select Security Tab in the Internet options windows- Select Internet from the zone settings- Uncheck Enable Protected Mode option to disable the protection from Security for this zone- Hit Apply and Ok.

10)               Make sure the SharePoint site should be added inside trusted sites zone. How to do this: http://sharepointknowledgebase.blogspot.in/2010/07/site-prompts-for-credentials.html

Thank you once again!

I would like to request you if you have any different resolution apart from the above mentioned then please share here so that it would be beneficial for others as well.

Happy SharePoint to all of U...

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Manage access requests in SharePoint 2010

‘Manage access request’ is an old mechanism which was present in MOSS2007 and with no surprise Microsoft has continued the same feature in SharePoint 2010.

Let me tell you guys that this feature is very important from so many perspectives:

§  There might be so many site collections administrators are assigned but you can specify any user or you can call as POWER USER who has the responsibility to approve the access request.

§  You can specify anybody, but make sure that he has a thorough knowledge of the functionality as it might be a threat to your site security because your site might contains some confidential documents that you don’t want to explore any third party user.

§  You are maintaining a proper channel as well as record by which to whom you are approving or whom you are giving access denied.

§  This might be a part of your governance project model also

The access request feature allows people to request access to content that they do not currently have permission to see. As a site owner, you can configure the feature to send you mail when someone requests access to a site.

Where is the location of this functionality in SharePoint 2010?

How to enable ‘manage access request’ in SharePoint 2010?

Here are the detail steps:

1.   Open the site collection on which you are working.

2.   Site actions

3.   Site settings

4.   Under ‘users and permissions’ section

5.   Site permissions

6.   Please refer the Ribbon on the top

7.   Permission tools

8.   Manage access requests

9.   Select the checkbox ‘allow request for access’ and enter the appropriate email id as per your requirements and click OK

That’s it- We are done!

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

Change Regional settings in Central administration as well as at the site collection level- SP2010

Regional settings plays a very vital role as the SharePoint has been extensively used all over the world with different languages.

So many requirements can arise such as:

-How can we set the default regional settings for the new site collections?

-How can we change the default regional settings once the site collection created?

-How can we change the default time zone?

-How can we change the default calendar?

-How can we set the alternate calendar?

-How can we change the time format? 12 hour/24 hour?

Primarily we are going to focus as how we can change the regional settings in central administration as well as at the site level.

Change Time Zone settings in Central Administration:

-Open the central administration

-Application management

-Manage web applications

-Select the appropriate web application on which you need to change the default regional settings

-General settings from the top dropdown

-Default time zone

-change it as per your requirement.

Change Regional settings at the site collection level:

-Open the site collection

-site actions

-site settings

-site administration

-Regional settings

-change any settings as per your requirements.

If you have any queries / questions regarding the above mentioned information then please let me know, I would be more than happy to help you as well as resolves your issues, Thank you.

How to create a subsite in SP2010

Subsite is an integral part of site collection. There are several uses of subsite for which you can deal with as well as manage almost the same set of operations that you can do from the top level site.

Many organisations have some security policies and they don’t permit complete leverage to the owners to manage the complete site collection but one thing is very good that at list they can create multiple subsites as per their requirements.

Today’s topic is based on the same and would like to share this basic information with all of you so that there would not be any confusion in creation the subsite.

Here are the details:

-Open the website on which you are dealing with

-site actions

-site settings

-site administration

-sites and workspaces

-Create

-Enter the title, URL, select the appropriate template and click OK.

By this way you can create a subsite in an easy without being dependent on others / without referring any article or document/ without asking for help from anybody/ without taking any training.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you. 

Access Services is unable to process the request.

Few days before I worked on one access issue but at that time the exception was different and this time we faced new error message.

Problem description:

While working on asset database site, trying to create new item and got the following exception.

Error message:

Access Services is unable to process the request. Click here to try again

Let me tell you access service application was already created and properly working without any issues.

Troubleshooting done:

-Checked the status of the access service application

-Checked the access SA proxy-whether it’s been properly associated with that web application or not.

-Checked the SharePoint logs as it is the most important location where we can find the cause behind it.

-Checked the event logs for any noticeable event id based on access.

-Try opening your SharePoint website in Firebug (Firefox utility) and check what exactly it’s blocking.  

IMP POINT:

Make sure that your foundation web application service and access services are running on the same box.

Please refer this for detail information: http://sharepointknowledgebase.blogspot.in/2013/08/unexpected-error-occurred-while-running.html

Resolution:

-Do IISRESET and check the results.

-If you check the logs and find any traces on security token service not working then you need to provision the security token service application.

Get-SPServiceApplication

$sts = Get-SPServiceApplication | ?{$_ -match "Security"}

$sts

$sts.Status

$sts.Provision()

If you have any different resolution apart from mentioned above then please share here so that it would be useful as well as beneficial to others as well.

If you have any queries/questions regarding the above mentioned information then please let me know, I would be more than happy to help you as well as resolves your issue, Thank you.

Security token service is not available- SP2010

Security token plays an important role with respect to authentication purpose, if this stops functioning then you will start getting so many tickets regarding access as well as critical tickets which are dependent on the same as few other services are also dependent on this service i.e. security token.

Here is the Microsoft link which talks about in details on security token:

http://technet.microsoft.com/en-us/library/ee806864(v=office.14).aspx

While doing the sanity check across all front ends, we have noticed the security token service exception in the event viewer logs with respect to one of the server.

Here are the details:

Error message: Security token service is not available.

Checked the IIS status and found all the application pools and websites were in stopped status.

Started all the SharePoint entities which were in stopped status.

Checked the rule again and it was not there in the HA (Health Analyzer) list anymore.

Issue resolved, we are good now. Thank you.

Few IMP points which are essential while troubleshooting this issue:

In our case, the security token service was working initially without any issues and the farm was already built properly. But in your case, if it’s a newly built farm then it might be a hotfix issue as per this Microsoft article:

http://support.microsoft.com/kb/2493524

http://technet.microsoft.com/en-us/library/hh564135(v=office.14).aspx

If you have any queries regarding the above mentioned information then please let me know, I would be more than happy to help you as well as resolves your issues.

Also-if you have a different resolution regarding the same issue then request you to share the same so that it would be useful to other as well. Thank you.