Trusted File Locations | Step Bi Step

The workbook cannot be opened – Excel Services error on SharePoint 2010

Posted by Rajanihanth in Excel Services, SharePoint 2010, SQL Server on June 29, 2012

After enabling the Excel Web Services (Oh yes, I have added the document path into the Trusted File Locations in the Central Administration, you can see the post here) I tried to open the Excel file in the browser mode and I have got the following error message.

I have googled about the error message, most of the people suggest to check the event viewer. The event viewer is showing the following Critical error message. Here is the viewer:

The details of event 3760:

Text format of the event:

SQL Database '<Content Database Name>' on SQL Server instance '<Server Instance Name>' not found. Additional error information from SQL Server is included below.

Cannot open database "<Content Database Name>" requested by the login. The login failed.
Login failed for user '<DomainName\ServiceAccountName>'.

In this above error, we can obviously see the login failed for user ‘<DomainName\ServiceAccountName>’ to access the SharePoint content database. So the solution is grant the permission to this account in the SQL database. (Someone suggested to grant the read access is enough, but for me it didn’t work, so I have granted as db_owner, you might try and see..!). Here are the steps:

Step 1: Go to the content database (you can see in the event log ‘<Content Database Name>’) and click Security node.

Step 2: Click Users on the Security node, you will be getting the all user details on the Object Explorer pane.

Step 3: Just right click on the Users and select the New Users.., you will be getting the following screen.

Step 4: Just enter your service account name (you can see in the event log ‘<DomainName\ServiceAccountName>’) and click the db_owner check box on the Role Members and click ok.

Step 5: Go and check your excel file, wow.. It’s working huh? 🙂

If you don’t want to do the manual process of the above and you are good in PowerShell then you just follow this post and get the solution right away! 🙂

Happy Excel Servicing..! Thanks R./

References:

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/5ae78be2-c26a-4b7e-93ad-3e4ca4badf01/

http://blogs.msdn.com/b/jjameson/archive/2010/05/04/the-workbook-cannot-be-opened-error-with-sharepoint-server-2010-and-tfs-2010.aspx

db_owner, error message, Event 3760, Excel Web Services, The login failed, Trusted File Locations

12 Comments

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location – SharePoint 2010

Posted by Rajanihanth in Excel Services, SharePoint 2010 on June 28, 2012

One of my colleagues sent me an email saying that he is getting this error (see below) whenever he tried to open an excel workbook. I just clicked the same file in the same location and I am able to open it. 🙂

But when I click on the excel file drop down –> View in Browser then I also got the same error.

The text format of the error is:

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.

According to the error message, obviously we need to add the document library path to Trusted File Locations in the Central Administration. So we will see the steps here.

Step 1: Go to Central Administration –> Manage service applications under Application Management