Use the New-OfficeWebAppsHost cmdlet to add as a domain. These steps were taken after the above to troubleshoot the OWA server. The GUIDS to use are given, but you must still specify the name of each server. Must be run twice, once for SQL and once for SharePoint.On the SharePoint Server, specify the S2S certificate for Office Online Server with PowerShell ( Link)Ĭonfigure SharePoint Server to use the certificate for server-to-server authentication ( Link) Still on OOS, Use the Microsoft Management Console (MMC) to grant the network service permissions to use the private key. Import the Certificate into the "Trusted Root Certification Authorities", as well as the "Personal" directoriesĮxport the Certificate to somewhere accessible from DEV-WEB (the SharePoint Web Front-End Server) CONTOSO-CA-01-CA) through Microsoft Management Console On OOS, get a self-signed certificate from the Certificate Authority (e.g. Open a document library in SharePoint and create or edit a Word, Excel, or PowerPoint document to confirm.įollow instructions on the following page to establish trust between the OOS Server and SharePoint.Ĭonfigure server-to-server authentication between Office Online Server and SharePoint Server 2016 $Farm = Get-SPFarm $ ("WopiLegacySoapSupport", "/x/_vti_bin/ExcelServiceInternal.asmx" ) $Farm.Update ( ) įinally the OOS should be working. Use the Set-OfficeWebAppsFarm cmdlet to configure the Secure Store over HTTP settings:" When Office Online Server attempts to refresh data in a workbook or ODC file that is stored in an HTTP path, that data refresh will fail if you have not configured Office Online Server to allow Secure Store connections over HTTP. (If you're not planning to use Secure Store in SharePoint Server with Excel Online, you can skip this step.) "If you're planning to use the Secure Store service in SharePoint Server in an HTTP environment, there's a parameter that you need to set to enable this. RenderingLocalCacheLocation : D:\OfficeOnlineServer\waccacheĮxcelEnableCrossForestKerberosAuthentication : FalseĮxcelAutomaticVolatileFunctionCacheLifeTime : 300ĮxcelConcurrentDataRequestsPerSessionMax : 5Ĭonfirm that the Farm was created successfully by visiting "If Office Online Server is working as expected, you should see a Web Application Open Platform Interface Protocol (WOPI)-discovery XML file in your web browser." LogLocation : C:\ProgramData\Microsoft\OfficeWebApps\Data\Logs\ULS
New-OfficeWebAppsFarm -InternalUrl "http: //" -AllowHttp -EditingEnabled