You are a SharePoint administrator at Litware, Inc. Excel Services is not currently able to load workbooks on the ShareP

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

You are a SharePoint administrator at Litware, Inc. Excel Services is not currently able to load workbooks on the ShareP

Post by answerhappygod »

You are a SharePoint administrator at Litware, Inc.
Excel Services is not currently able to load workbooks on the SharePoint site. The Unified Logging Service (ULS) log contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database "WSS_Content_Portal_Content_Database" requested by the login. The login failed. Login failed for user 'LITWARE\svcExcelService'.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that users can open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?

A. $sa = Get-SPServiceApplication | where {$_.TypeName -eq "Excel Services Application Web Service Application"} and $sa.GrantContentDatabasePermissions("WSS_Content_Portal_Content_Database")
B. Add SPShellAdmin -UserName LITWARE\svcExcelService
C. Add SPShellAdmin -UserName LITWARE\svcExcelService -database WSS_Content_Portal_Content_Database
D. $wa = Get-SPWebApplication https://portal.litware.com and $wa.GrantToProcessIdentity("LITWARE \svcExcelService")
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply