Step Bi Step
Posts Tagged The login failed
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./
db_owner, error message, Event 3760, Excel Web Services, The login failed, Trusted File Locations
- TF255507: The security identifier (SID) for the following SQL Server login conflicts with a specified domain or workgroup account
- Installing Visual Studio Team Foundation Server 2010-Basic Configuration Step By Step
- The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request.
- 2012 in Review!
- Getting started with Windows 8 Metro Style Application using C# – Visual Studio 2012
- .Net (23)
- Active Directory (4)
- ASP.Net (1)
- BDC (5)
- C# (5)
- Client Object model (3)
- Crystal Reports (1)
- DirectoryServices (3)
- Excel Services (3)
- GAC (1)
- InfoPath 2007 (5)
- InfoPath 2010 (4)
- MetaData (1)
- SharePoint 2007 (19)
- SharePoint 2010 (10)
- Silverlight (2)
- SQL Server (9)
- SSRS (3)
- STSADM (2)
- Tech Tips-.Net (4)
- Tech Tips-SharePoint (1)
- Tech Tips-SQL (2)
- TFS (3)
- TFS 2010 (3)
- TFS 2012 (1)
- Uncategorized (1)
- VB.Net (1)
- Versus (vs) (2)
- Visual Studio 2012 (3)
- VSTA (3)
- Webpart (8)
- Windows 8 (3)
- WSP Builder (4)
- XAML (1)
Labels.Net Active Directory BDC C# Client Object model Crystal Reports DirectoryServices Excel Services GAC InfoPath 2007 InfoPath 2010 MetaData SharePoint 2007 SharePoint 2010 Silverlight SQL Server SSRS STSADM Tech Tips-.Net Tech Tips-SharePoint Tech Tips-SQL TFS TFS 2010 Uncategorized Versus (vs) Visual Studio 2012 VSTA Webpart Windows 8 WSP Builder
April 2023 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30