When opening an excel file I get the following error "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

If you are working on Office Web apps in SharePoint 2010 then you may come across this error…

“This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

To create an Excel Services Application trusted location, contact your system administrator.”

its very simple to resolve this error and start working on excel again :-)

there are 2 methods to resolve this issue:

Option 1: Configure to open in Client Application

At the site collection level activate the "Open Documents in Client Applications by default Feature"

Option2: At the Document Library set the "Opening Documents in the Browser" setting to "Open in client application"

OR

1. open central admin 
2. go to Manage service applications
3. Click on Excel services Application.
4. Then click on “Trusted file locations”
5. You can see that http:// is already there, so you could just add https:// or put in a url to a specific location
6. Fill in the boxes, I also ticked the trust children box.
7. Once you have done this go back to your Excel document and it will open up in the browser. 

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

System error 5 has occurred. Access is denied.

This issue occurs if you use a connection method that uses Windows shell components or Explorer View. For example, you may experience one or more of the following symptoms:

1-if you try to map a drive to a document library by using the net use command, you are prompted to type your user name and password. After you type your user name and password, you receive the following error message:

System error 5 has occurred.
Access is denied.

2-If you try to view a document library by using Explorer View, you are prompted several times to type your user name and password. If you click Cancel, Explorer View displays Web folders. 

To have us enable Basic authentication on the client computer for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.

Fix it for me

To fix this problem automatically, click the Fix it button or link. In the File Download dialog box, click Run, and then follow the steps in the Fix it Wizard.

Fix this problem
Microsoft Fix it 50623

How to check-Forms Server is installed on a server or not ?

Problem Description:
Forms Server was installed on a server and you need to verify its installation.

What excatly we need to check for this?
Check whether the Microsoft.Office.InfoPath.Server.dll is installed on the server.

Resolution:To verify the installation of Forms Server you need to check whether the DLL is properly installed on the server and whether the ASP.NET page is present. You can do this as follows:
1.Go to C:\Program Files\Microsoft Office Servers\12.0\Bin\ and check whether Microsoft.Office.InfoPath.Server.dll is present in this folder.
2.Go to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\ and check whether FormServer.aspx is present in this folder.
3.Open the .NET Framework 2.0 Configuration tool by going to Start > Settings > Control Panel, opening the Administrative Tools and then the Microsoft .NET Framework 2.0 Configuration.
4.Click on Manage the Assembly Cache listed under Tasks in the right panel of the .NET Framework 2.0 Configuration dialog box.
5.Click on View List of Assemblies in the Assembly Cache under Tasks in the right panel of the .NET Framework 2.0 Configuration dialog box.
6.Look whether Microsoft.Office.InfoPath.Server is listed among the DLLs that are registered in the Global Assembly Cache (GAC).

Please let me know in case of any queries/questions. I would be more than happy to help you as well as resolves your issues, Thank you

 

Security token service is not available

After installing SharePoint Foundation 2010 I noticed a warning in the Central Admin > Review problems and solutions report that the Security Token Service is not available.

The Security Token Service is not available.

The Security Token Service is not issuing tokens. The service could be malfunctioning or in a bad state.

SP Security Token Service (Security Token Service)

This issue happends becuase of the following symptons:

-The following error appears in the SharePoint server’s event log every hour:

“An error occurred while receiving the HTTP response to http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.”

-Users are unable to log in to SharePoint sites protected by claims authentication.

Probable causes:

1.A required WCF hotfix has not been installed on the SharePoint server

2.Authentication for the SecureTokenServiceApplication is not configured properly in IIS.

3.The web.config file of the SecureTokenServiceApplication contains invalid data

4.The SecureTokenServiceApplication is not provisioned properly.

Resolution:

We have followed the microsoft suggested guidelines and the issue has been resolved:

1.Missing WCF Hotfix: If the server is running Windows Server 2008 SP2, please ensure that the hotfix mentioned at http://support.microsoft.com/kb/971831 is installed. If the server is running Windows Server 2008 R2, the hotfix mentioned at http://support.microsoft.com/kb/976462 must be installed.

2.Incorrect Authentication Settings: Please ensure that the authentication settings for the SecureTokenServiceApplication are correctly configured by completing the following steps:

a) Open IIS Manager

b) Expand “Sites”

c) Expand “SharePoint Web Services”

d) Select “SecurityTokenServiceApplication”

e) From the “Features” pane, double click on “Authentication” under “IIS”

f) Right click “Forms Authentication” and select “Disable”

g) The authentication settings page should only have Windows and Anonymous access enable for the security token service to issue tokens properly (and for claims authentication to work properly)

3.Incorrect data in the configuration file: Please review the web.config file of the secure token service application and compare it to a web.config file from a "working" secure token service application.

4.SecureTokenServiceApplication not provisioned: Use the following power shell commands to provision the secure token service application

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

$sts.Status

$sts.Provision()​

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.