• Contact
  • Cookie Policy
  • Helpdesk
Techspark Blogging about technical stuff

Category Archives: Microsoft

Microsoft Products

Microsoft Edge URI List – Open Office Apps without Prompt for SharePoint

September 5, 2022 2:02 PM / Leave a Comment / XeroX

By default Microsoft Edge always prompts when it opens external applications like Microsoft Word or Microsoft OneDrive. You may want this prompt to disappear for your trusted local SharePoint 2013/2016/2019/Subscription Farm.

The list of URI Schemes is published here: Office URI Schemes | Microsoft Docs
I found out these URI schemes are not complete and in some cases not valid anymore.

So how to configure this now? Add the Microsoft Edge Group Policies to your domain controller and search for the following settings: “Define a list of protocols that can launch an external application from listed origins without prompting the user”.

This has the be in json format and will look like the following:

[{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"ms-word"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"msoutlook"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"ms-excel"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"ms-powerpoint"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"ms-access"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"ms-project"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"ms-visio"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"onenote"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"viewinfileexplorer"},{"allowed_origins":["sharepoint.example.com","officeonline.example.com"],"protocol":"odopen"}]

The following URI Schemes are being used here:

URI SchemeDescriptipon
ms-wordMicrosoft Word
msoutlookMicrosoft Outlook
(not documented)
ms-excelMicrosoft Excel
ms-powerpointMicrosoft PowerPoint
ms-accessMicrosoft Access
ms-projectMicrosoft Project
ms-visioMicrosoft Visio
onenoteMicrosoft OneNote (Phat Client)
viewinfileexplorerExplorer View
(not documented)
odopenMicrosoft OneDrive
(not documented)
Posted in: Microsoft, OfficeWebApps, SharePoint / Tagged: Office, OfficeOnline, OfficeWebApps, SharePoint, URI, URI Scheme

Install EWSManagedAPI NuGet (GitHub) for SharePoint 2013/2016/2019

August 2, 2021 12:37 AM / Leave a Comment / XeroX

Recently I tried to enable SiteMailboxes for SharePoint 2019. The documentation (Configure site mailboxes in SharePoint Server – SharePoint Server | Microsoft Docs) claims to download EWSManagedAPI.msi but this results in a 404, as this project moved to GitHub (OfficeDev/ews-managed-api (github.com)). However on GitHub there is no executable or MSI to install.

You can install the NuGet Package (NuGet Gallery | Microsoft.Exchange.WebServices 2.2.0) on your SharePoint Server with the following command:

Install-Package Microsoft.Exchange.WebServices

Basically you are done and should find the NuGet Package at the following location:

C:\Program Files\PackageManagement\NuGet\Packages\Microsoft.Exchange.WebServices.2.2\lib\40\

However the Setup Scripts within the SharePoint Documentation will fail as the DLLs are not registered in GAC (Globaly Assembly Cache).

Verfiy with:

$assm = [System.Reflection.Assembly]::LoadFile("C:\Program Files\PackageManagement\NuGet\Packages\Microsoft.Exchange.WebServices.2.2\lib\40\Microsoft.Exchange.WebServices.dll")
$assm.GlobalAssemblyCache

This should return “False”. Claim gacutil.exe from a Visual Studio (Free Community Edition maybe fine, check Terms and License) Installation with for ex. Windows 10 SDK. Copy it over and run:

gacutil.exe -i  C:\Program Files\PackageManagement\NuGet\Packages\Microsoft.Exchange.WebServices.2.2\lib\40\Microsoft.Exchange.WebServices.dll 
gacutil.exe -i  C:\Program Files\PackageManagement\NuGet\Packages\Microsoft.Exchange.WebServices.2.2\lib\40\Microsoft.Exchange.WebServices.Auth.dll

Restart your powershell console and rerun the commands above. It will return “True” and the Setup Scripts run through without an issue.

Posted in: Microsoft, SharePoint

Error while trying to Access “Details” of a SharePoint App

November 6, 2015 1:22 PM / Leave a Comment / XeroX

Recently we added Access Services to our SharePoint 2013 environment. After the initial setup we started testing the new implementation and stumbled over an error while accessing the details page of an app. This has nothing to do with access itself, more with apps in general.

2015-11-06_13-03-54

After clicking on details you get an error message with the correlation id. So nothing easier to get the log regarding that error.

SqlError: ‘The EXECUTE permission was denied on the object ‘prc_CountAppInstanceData’, database ‘SharePoint_Logging’, schema ‘dbo’.’    Source: ‘.Net SqlClient Data Provider’ Number: 229 State: 5 Class: 14 Procedure: ‘prc_CountAppInstanceData’ LineNumber: 1 Server: ‘Database.fqdn.com’ f2ec3e9d-ac28-80f1-8d80-1d89f5d672a9
11/06/2015 12:50:34.93  w3wp.exe (Servername.fqdn.com:0x5DE4)            0x5D34 SharePoint Foundation          Database                       5214 Critical Insufficient SQL database permissions for user ‘Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation’ in database ‘SharePoint_Logging’ on SQL Server instance ‘Database.fqdn.com’. Additional error information from SQL Server is included below.  The EXECUTE permission was denied on the object ‘prc_CountAppInstanceData’, database ‘SharePoint_Logging’, schema ‘dbo’. f2ec3e9d-ac28-80f1-8d80-1d89f5d672a9

This leads us to a permission issue. We tried granting the App Management Service Account “SPDataAccess” permission on our logging database, which did not help.

As you can see in the log there is an user specified IUSR SID: S-1-5-17. This leads to a permission issue from IIS WebServer. Makes sense as all SharePoint Applications are running within the IIS and their Application Pools. As our App Management Service Account wasn’t the issue we granted our Application Pool Account under which the Web Applications are running, the “SPDataAccess” permission on our logging database.

2015-11-06_13-04-42

Et voila, this fixed the issue.

Problem: App Details do not work.

Solution: Grant SPDataAccess Permisson to your Web Application Pool Account on your SharePoint Logging Database.

Posted in: Microsoft, SharePoint / Tagged: Logging Database, Permissions, SharePoint Database

Reinstall WSUS and keep downloaded content

June 3, 2015 8:37 PM / 1 Comment / XeroX

Our scenario was that we wanted to upgrade our WSUS running on Windows Server 2012 to Windows Server 2012 R2 and changing the database to WID. The database wasn’t that important for us, as all computers placed in one group where all patches are approved. But we wanted to keep the content of 800 Gigabyte without redownloading all that stuff.

A huge advantage is if you have the data on a seperate drive or partition. Before you start, shutdown the WSUS Service and rename the WsusContent folder or move it to a different location.

Then you’re good to go. Reinstall or setup a new machine and install WSUS. During the initial configuration wizard its important that you choose “synchronize manually” and do not trigger a sync before or at the end of the wizard. Then copy the previous saved WsusContent folder to the location you’ve chosen in the wizard and replace everything. After that you can manually start your synchronization and WSUS is reindexing the whole content without downloading a huge amount of data. It should take around 3-4 hours, depending on your hardware and disk. You can see the status on synchronization tab.

Good luck!

Posted in: Microsoft, Windows Server / Tagged: keep content, Reinstall, Reinstall WSUS, Setup, Setup WSUS, WSUS

Error during install of Microsoft Workflow Manager 1.0 Refresh

June 30, 2014 1:34 PM / Leave a Comment / XeroX

Installing the Workflow Manger 1.0 Refresh can be tricky.

During Installation process with the web platform installer 5.0 (only way to install it) the setup of Microsoft Windows Fabric V1 CU1 fails. When you open the log it says 1603.

So lets see what 1603 means. Open cmd prompt and type net helpmsg 1603.

C:\>net helpmsg 1603

Fatal error during Installation.

Not very expressive. But there is a simple solution, install Visual C++ Redistributable for Visual Studio 2012 Update 4.

 

Source: Social MSDN

Posted in: Microsoft, SharePoint / Tagged: Fabric V1, Web Platform Installer, Workflow Manager

Change network profile of Windows Server 2012 R2

June 6, 2014 11:51 PM / Leave a Comment / XeroX

After installing Windows Server 2012 R2 or Windows 8.1 you will be asked if this is a home/work network or not. Based on that windows will choose your network profile.

Network ProfileI was some kind distracted and accidently clicked in the middle of the desktop and the sidebar disappeared. Windows decided that this is a “No” and you will be on a public network. I’ve no idea why but you can not change it through the network and sharing center, all settings you’re trying to set will be set back to default of public networks. Like network discovery. So how to change it? Quite easy, just open the registry and navigate to the following path:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\Profiles

There will be at least one key in that list. Simply delete the one you want to reset and reboot your machine. After that you will be asked again. However I would only recommend that method if that happened to you right after the setup as I don’t know if some firewall rules will be reset or deleted.

Posted in: Microsoft / Tagged: Network Profiles, Windows 8.1, Windows Server, Windows Server 2012, Windows Server 2012 R2

Windows 2012 R2 Data Deduplication and ISOs

June 1, 2014 4:11 PM / Leave a Comment / XeroX

I’ve tried to install some machines on my Hyper-V. All ISOs were placed on the second drive where data deduplication is enabled. With deduplication enabled I ran into the problem that no serial/license number was accepted neither the AVMA Key nor the generic KMS Key or my own key. After hours of searching for solutions on the web and no solution in sight. I copied the iso to drive D again. Suprise it was working! One day later I tried to install a new machine and it wasn’t working again. No key accepted. After moving it to drive C where no deduplication happens its working again.

Conclusion: Never ever put windows installation media on a drive with data deduplication enabled.

Posted in: Microsoft / Tagged: data deduplicaiton, no key accepted, no license number accepted, no serial accepted, Windows Server 2012 R2

<20 Watt Home Server for Hyper-V and ESXi

June 1, 2014 3:58 PM / Leave a Comment / XeroX

I’ve rented a lot of linux vps around the world for testing and hosting teamspeak and other stuff. Not every application runs on linux so I decided to build a small home server with a low power consumption.

I stumbled over the list of components in the hardwareluxx forums and build my system based on that components. ( Link )

Here is my list:

  • Intel Pentium G3420
  • ASRock Z87E-ITX
  • Crucial Ballistix Sport Kit 8GB ( DDR3-1600, CL9-9-9-24 )
  • EKL Alpenföhn Silvretta
  • be quiet! Pure Power L8 300W ATX 2.4
  • SanDisk SSD 128GB
  • Kingston SSDNow mS200 SSD 30 GB
  • Cooler Master Elite 130

First of all I removed the Mini PCIe Wifi card from the mainboard as its not needed and plugged in the mSATA at the bottom of it. The small SSD can be used for the OS (Server 2012 R2) or as Host Cache for ESXi.
After putting all components together I enabled all bios settings allowing power savings and switched of the soundcard etc. I also tried to undervolt the CPU with the VCore Offset and got it down to -0,235mV.

Here are the results (power measurement):

ESXi 5.5 U1 Windows Server 2012 R2
Idle 18.2 Watts 11.1 Watts
Load 39.6 Watts 35.8 Watts

Make sure all drivers are installed and no usb devices are plugged in. The usb devices may prevent reaching a package c-state of more than 80.

The network drivers are a little tricky. For ESXi 5.5 follow this guide  ESXi 6.0 includes drivers for Intel I217V and for Server 2012 follow this guide.

Good luck and post your results.

Posted in: ESXi, Hyper-V, Microsoft, VMWare / Tagged: ESXi, homeserver, hyper.v, Intel I217-V, Intel I217V, low consumption, low power, Power saving

Office Web Apps via HTTPS are slow and you can’t open documents without an error

March 22, 2014 1:28 AM / Leave a Comment / XeroX

You’ve installed an Office Web Apps Server with HTTPS and its slow? We really had slow office web apps and an enormous amount of documents that failed to open with the following error message “Sorry, something went wrong”.  Make sure your SharePoint Web Applications are using https and  “AllowOAuthoverHTTP” is not enabled. You should not use AllowOAuthoverHTTP when using HTTPS.

$config = (Get-SPSecurityTokenServiceConfig)
$config.AllowOAuthOverHttp = $false
$config.Update()

More solutions to resolve your problem on TechNet

 

Posted in: Microsoft, OfficeWebApps, SharePoint / Tagged: AllowOAuthoverHTTP, Exchange 2013, HTTPS, Lync 2013, OAuth, Office Web Apps, Sharepoint 2013

SharePoint 2013 – Zero Byte ULS Logs

February 26, 2014 1:42 PM / Leave a Comment / XeroX

Recently I stumbled over out ULS Logs on the Web Frontends. Suprisingly they were empty, 0 bytes. I checked the permissions for the account the tracing service is running with (Web Application Pool Account). Everything was fine, same permissions as on the other servers where it was working.

So I checked the local groups and found out the tracing account must be a member of the “Performance Log Users”. Add the account, restart the “SharePoint Tracing” Service and you will see the uls logs growing.

Posted in: Microsoft, SharePoint / Tagged: Empty, Logging, Sharepoint 2013, ULS Logs, ZeroByte

Post Navigation

1 2 Next »

Support This Site

If you like this content, you can buy me a coffee

Recent Posts

  • Super Famicom/Super Nintendo xBAND XBⱯND – Teardown
  • Gigabyte ITE IT5701/ 5702 Firmware Archive
  • Speed-Up/Tune Synology DSM with HDD & SSD
  • Dreamcast – Skies of Arcadia – PAL – 60Hz – VGA Patch
  • Running Sierra Wireless EM7455 on FreeBSD/OPNSense/pfSense

Recent Comments

  • Raoul on Running Sierra Wireless EM7455 on FreeBSD/OPNSense/pfSense
  • XeroX on Running Sierra Wireless EM7455 on FreeBSD/OPNSense/pfSense
  • Raoul on Running Sierra Wireless EM7455 on FreeBSD/OPNSense/pfSense
  • Raoul on Running Sierra Wireless EM7455 on FreeBSD/OPNSense/pfSense
  • XeroX on Running Sierra Wireless EM7455 on FreeBSD/OPNSense/pfSense

Archives

  • January 2025
  • July 2024
  • October 2023
  • February 2023
  • November 2022
  • September 2022
  • September 2021
  • August 2021
  • November 2020
  • November 2015
  • June 2015
  • February 2015
  • August 2014
  • June 2014
  • March 2014
  • February 2014
  • January 2014
  • November 2013
  • September 2013
  • August 2013

Categories

  • ESXi
  • FreeBSD
  • Hardware
  • Hyper-V
  • iOS
  • Microsoft
  • Nintendo
  • OfficeWebApps
  • Operations Manager
  • Retro
  • SharePoint
  • Synology
  • Teardown
  • vCenter
  • VMWare
  • Webserver
  • Windows Server
© Copyright 2025 - Techspark
Infinity Theme by DesignCoral / WordPress