Which Windows PowerShell cmdlet or cmdlets should you run?

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?

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”}
$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
$wa.GrantAccessToProcessIdentity(“LITWARE\\svcExcelService”)

Explanation:
Alex (21.07.2015): Correct
https://support.microsoft.com/en-us/kb/981293



Leave a Reply 0

Your email address will not be published. Required fields are marked *