Excel Services is not currently able to load workbooks

If you find that Excel Services is not able to load workbooks in your SharePoint site then this may be due to insufficient permissions.  You may also see the following error in your logs:

System.Data.SqlClient.SqlException: Cannot open database
“SP2013_Content_Portal” required by the login.¬† The login failed for user ‘LAB\SP_Excel’

This can be fixed by granting the appropriate permissions using the Get-SPWebApplication PowerShell cmdlet:

$wa = Get-SPWebApplication https://portal.lab.local
$wa.GrantAccessToProcessIdentity("LAB\SP_Excel")
[BlogBookmark] [Blogsvine] [del.icio.us] [Digg] [Facebook] [Furl] [Google] [LinkedIn] [MySpace] [Reddit] [Slashdot] [StumbleUpon] [Twitter] [Windows Live] [Yahoo!] [Email]