SharePoint 2019 - Office Online Server Error

%3CLINGO-SUB%20id%3D%22lingo-sub-3091865%22%20slang%3D%22en-US%22%3ESharePoint%202019%20-%20Office%20Online%20Server%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3091865%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20deployed%20SharePoint%202019%20and%20configured%20Office%20Online%20Server%20to%20allow%20SharePoint%20files%20to%20open%20in%20Browser.%20Here's%20the%20HA%20architecture%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1-%20Front%20End%20%2B%20Distributed%20Cache%20Roles%20x3%20Servers%20(Load%20Balancer)%3C%2FP%3E%3CP%3E2-%20Application%20%2B%20Search%20Role%20x3%20Servers%3C%2FP%3E%3CP%3E3-%20MS%20SQL%20ALWAYS%20ON%20Database%20x3%20Servers%3C%2FP%3E%3CP%3E4-%20Office%20Online%20Server%20x3%20(Load%20Balancer)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20I'm%20facing%20is%20with%20opening%20SharePoint%2FOneDrive%20Files%20in%20Browser.%20Sometime%2C%20it%20works%20well%20but%20most%20of%20the%20time%2C%20following%20errors%20show%20up%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E'We're%20sorry.%20We%20couldn't%20open%20your%20workbook.%20You%20can%20try%20to%20open%20this%20file%20again%2C%20sometimes%20that%20helps.%3CBR%20%2F%3E'%3C%2FSPAN%3E%3CSPAN%3E'You%20do%20not%20have%20permissions%20to%20open%20this%20file%20in%20the%20browser.'%3CBR%20%2F%3E%3CBR%20%2F%3ETried%20all%20workarounds%2C%20used%20single%20tier%20approach%20but%20none%20worked.%3CBR%20%2F%3E%3CBR%20%2F%3EPS%3A%20All%20Servers%20are%20in%20same%20Subnet%20with%20full%20access.%20No%20Firewall%20in%20between%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SP%20Permission.png%22%20style%3D%22width%3A%20405px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343867i131B265353CA4928%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22SP%20Permission.png%22%20alt%3D%22SP%20Permission.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SP%20Error.png%22%20style%3D%22width%3A%20399px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343868iA4CACDA620D75D33%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22SP%20Error.png%22%20alt%3D%22SP%20Error.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3091865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi Guys

 

I have deployed SharePoint 2019 and configured Office Online Server to allow SharePoint files to open in Browser. Here's the HA architecture

 

1- Front End + Distributed Cache Roles x3 Servers (Load Balancer)

2- Application + Search Role x3 Servers

3- MS SQL ALWAYS ON Database x3 Servers

4- Office Online Server x3 (Load Balancer)

 

The issue I'm facing is with opening SharePoint/OneDrive Files in Browser. Sometime, it works well but most of the time, following errors show up

 

'We're sorry. We couldn't open your workbook. You can try to open this file again, sometimes that helps.
'
'You do not have permissions to open this file in the browser.'

Tried all workarounds, used single tier approach but none worked.

PS: All Servers are in same Subnet with full access. No Firewall in betweenSP Permission.pngSP Error.png

0 Replies