Advertisement
I am trying to open the Excel WorkBook(.xslx) in the browser
I am getting the error like this
So now I started to resolve this issue checked weather that
particular user having DB Permissions or not.
We have to give db_owner Permissions to that particular user
in SQL Server.
Login to DB->Security->Logins->
If user is already there check the Server roles and User
Mapping Permissions.
In User mapping we have to give access to SharePoint Content
DB as “db_owner”.
Once we give Permissions Check it will work.
We give Permissions using Power Shell Commands also
$p =Get-SPWebApplication –Identity<Url of the
Webappliction>
$p.GrantAccessToProcessIdentity(“Domainname/username”)
Even though if you are having the same issue
Configure diagnostic logging
Central Admin->Monitoring->Configure diagnostic
logging
Select the Check box for Excel Services and Check the Logs
Find with text “Error” you can find the correct error.
0 comments:
Post a Comment