{"id":248,"date":"2014-01-26T13:42:05","date_gmt":"2014-01-26T13:42:05","guid":{"rendered":"https:\/\/www.sharepoint13.org\/?p=248"},"modified":"2014-01-26T13:45:16","modified_gmt":"2014-01-26T13:45:16","slug":"ppt-from-sharepoint-saturday-stockholm","status":"publish","type":"post","link":"https:\/\/www.sharepoint13.org\/?p=248","title":{"rendered":"PPT from SharePoint Saturday Stockholm"},"content":{"rendered":"<p>Here are my <a href=\"http:\/\/sdrv.ms\/1jS5gie\">SLIDEDECK<\/a> from <a href=\"http:\/\/www.spsstockholm.com\/2014\/\">SharePoint Saturday<\/a> Stockholm 25.01.2014. Topic Deploy Office WebApps in Azure. What a great Event at WTC! Thanks to organizers Matthias, Hanna and Erwin \u2013hope you enjoyed the Norwegian Chocolate <img decoding=\"async\" class=\"wlEmoticon wlEmoticon-smile\" style=\"border-top-style: none; border-bottom-style: none; border-right-style: none; border-left-style: none\" alt=\"Smilefjes\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/wlEmoticon-smile1.png\" \/>&#160; continue reading for all powershell scripts and pictures,<\/p>\n<p>My demo was a full deployment of OWA for Internal and External use. All VM\u2019s in Azure http:\\\\ Endpoints opened in Azure. SharePoint Foundation 13 w.SQL Express and off course AD was allready there. <\/p>\n<p>I deployed and configured the farm using PowerShell. OWA server OS Win 2012 R2.   <br \/>Here the infrastructure.<\/p>\n<p><a href=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/image2.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/image_thumb2.png\" width=\"505\" height=\"303\" \/><\/a><\/p>\n<p>Here the PowerShell scripts:<\/p>\n<p>#Install on SP WFE -one server   <br \/>#1. PREREQS     <br \/>Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices,NET-Framework-Features,NET-Framework-Core<\/p>\n<p>#2. New Farm    <br \/>New-OfficeWebAppsFarm \u2013InternalURL &quot;<a href=\"http:\/\/owa2&quot;\">http:\/\/owa2&quot;<\/a> \u2013ExternalURL &quot;<a href=\"http:\/\/owa.vaerpn.com&quot;\">http:\/\/owa.vaerpn.com&quot;<\/a> \u2013AllowHttp -EditingEnabled    <br \/>Get-officewebappsfarm     <br \/># Additional Office WebApps Machines can join the farm:    <br \/>New-OfficeWebAppsMachine<\/p>\n<p>#3. TEST   <br \/><a href=\"http:\/\/owa2\/hosting\/discovery\">http:\/\/owa2\/hosting\/discovery<\/a><\/p>\n<p>#4. open from url   <br \/>Set-OfficeWebAppsFarm -OpenFromUrlEnabled:$True    <br \/># Generate link to docs on file share url    <br \/><a href=\"http:\/\/owa2\/op\/generate.aspx#\">http:\/\/owa2\/op\/generate.aspx#<\/a><\/p>\n<p># Remove OWA Machine for updates like Language Packs PU\/CU:   <br \/>Remove-OfficeWebAppsMachine<\/p>\n<p>## \u2013&gt;On SharePoint ServerFarm WFE (only one server)    <br \/># 1. Add PSSnapin Microsoft    <br \/>Add-PSSnapin Microsoft.SharePoint.PowerShell<\/p>\n<p># 2. Bind server on http   <br \/>New-SPWOPIBinding -ServerName owa.vaerpn.com -AllowHTTP    <br \/>Get-SPWOPIZone<\/p>\n<p># 3. Set the Zone &#8211; either, internal-http, internal-https, external-https, external-http   <br \/>Set-SPWOPIZone \u2013zone \u201cinternal-http\u201d    <br \/>Get-SPWOPIZone<\/p>\n<p># 4. AllowOpenAuthOverhttp set to -true (not valid on external sone)   <br \/>(Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp    <br \/>&#8216; returns False, continue    <br \/>$config = (Get-SPSecurityTokenServiceConfig)    <br \/>$config.AllowOAuthOverHttp = $true    <br \/>$config.Update()    <br \/>(Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp<\/p>\n<p># if applicable REMOVE&#160; OAuth over Http   <br \/>$config = (Get-SPSecurityTokenServiceConfig)    <br \/>$config.AllowOAuthOverHttp = $false    <br \/>$config.Update()    <br \/>(Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp<\/p>\n<p># 5. Remove binding to OWA Farm   <br \/>Remove-SPWOPIBinding \u2013All:$true<\/p>\n<p># 6. PDF preview in search results:   <br \/># Navigate to Site settings &#8211; Search Result type &#8211; Copy PDF rename&#160; to PDF&#160; Preview, Actions result change to Word Item.<\/p>\n<p># 7.PDF on Cell Phones   <br \/># &gt;&gt;Adjust the binding so that smartphones won\u2019t try to view PDFs in Word Web App (but other devices will continue to work)    <br \/>Get-SPWopiBinding -Action &quot;MobileView&quot; -Application &quot;WordPDF&quot; | Remove-SPWopiBinding -Confirm:$false<\/p>\n<p># Remove the binding altogether so that PDFs open in the default PDF viewer on all devices, use the following:   <br \/>Get-SPWOPIBinding \u2013Application &quot;WordPDF&quot; | Remove-SPWOPIBinding -Confirm:$false<\/p>\n<p># Going back   <br \/>Get-SPWOPIBinding \u2013Application &quot;WordPDF&quot; | Remove-SPWOPIBinding -Confirm:$false    <br \/>New-SPWOPIBinding \u2013ServerName &quot;Server.corp.Contoso.com&quot; \u2013Application &quot;WordPDF&quot; -AllowHTTP    <\/p>\n<p>#The Get-OfficeWebAppsFarm cmdlet displays all farm settings, notice that OpenFromUrlsEnabled is set to True \u2013this is not default setting.<a href=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/2.-Create-OfficeWebAppsFarm.png\"><img loading=\"lazy\" decoding=\"async\" title=\"2. Create OfficeWebAppsFarm\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"2. Create OfficeWebAppsFarm\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/2.-Create-OfficeWebAppsFarm_thumb.png\" width=\"516\" height=\"379\" \/><\/a><\/p>\n<p># type Http.\/\/\u201dyourowafarm\u201d\/op\/generate.aspx and you can create link to open or embed office files from url or unc shares.<a href=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/4.-BGenerate-a-link-to-open-files.png\"><img loading=\"lazy\" decoding=\"async\" title=\"4. BGenerate a link to open files\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"4. BGenerate a link to open files\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/4.-BGenerate-a-link-to-open-files_thumb.png\" width=\"516\" height=\"339\" \/><\/a><\/p>\n<p>&#160;<\/p>\n<p># On the SharePoint Farm WFE server bind the server on the external address <a href=\"http:\/\/owa.vaerpn.com\">http:\/\/owa.vaerpn.com<\/a> <a href=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/1.-SP-WFE-WopiBinding.png\"><img loading=\"lazy\" decoding=\"async\" title=\"1. SP WFE WopiBinding\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"1. SP WFE WopiBinding\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/1.-SP-WFE-WopiBinding_thumb.png\" width=\"516\" height=\"424\" \/><\/a><\/p>\n<p># In WindowsAzure subscription on the OWA and SPWFE dashboard open http: Endpoint and note the Public VIP Address.<\/p>\n<p><a href=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/5.Azure-VIP-address.png\"><img loading=\"lazy\" decoding=\"async\" title=\"5.Azure VIP address\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"5.Azure VIP address\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/5.Azure-VIP-address_thumb.png\" width=\"516\" height=\"266\" \/><\/a><\/p>\n<p># Finally Update your external DNS sone accordingly.   <br \/><a href=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/6.DNS-change.png\"><img loading=\"lazy\" decoding=\"async\" title=\"6.DNS change\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"6.DNS change\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/6.DNS-change_thumb.png\" width=\"516\" height=\"292\" \/><\/a><\/p>\n<p>YEAH IT WORKS    <br \/>-&gt; Internally and Externally <\/p>\n<p><a href=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/image3.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/www.sharepoint13.org\/wp-content\/uploads\/2014\/01\/image_thumb3.png\" width=\"516\" height=\"309\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here are my SLIDEDECK from SharePoint Saturday Stockholm 25.01.2014. Topic Deploy Office WebApps in Azure. What a great Event at WTC! Thanks to organizers Matthias, Hanna and Erwin \u2013hope you enjoyed the Norwegian Chocolate &#160;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,41],"tags":[18],"class_list":["post-248","post","type-post","status-publish","format-standard","hentry","category-events","category-office-web-apps","tag-office-web-apps"],"_links":{"self":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=248"}],"version-history":[{"count":2,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/248\/revisions"}],"predecessor-version":[{"id":250,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/248\/revisions\/250"}],"wp:attachment":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}