Excel Web Access "Workbook cannot be opened"

Whenever you encounter this error in your Excel Web Access, check your event viewer, you may find, that a particular account (configured to run your services, including Excel Services) has failed to gain login into the respective content database of the particular web application.

SQL Database 'WSS_Content_555' on SQL Server instance 'KARTHICKLAPTOP\SharePoint' not found. Additional error information from SQL Server is included below.

Cannot open database "WSS_Content_555" requested by the login. The login failed.

Login failed for user 'KarthickLaptop\spservices'.

Just give read permissions on the database for that login and your excel services, after that should work like a charm.

Comments

Post a Comment

Popular posts from this blog

Using External Content Types with Stored Procedures with Input Parameters

Windows 7 Blue Screen because of ConnectiFy

HTTPS Site InfoPath Issue : You do not have permissions to access a web service that provides data required for this form to function correctly