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 /

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: , , , , ,

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

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

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 /

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: , ,

Reinstall WSUS and keep downloaded content

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

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: , , , , ,

Error during install of Microsoft Workflow Manager 1.0 Refresh

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

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: , ,

Change network profile of Windows Server 2012 R2

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

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: , , , ,

Windows 2012 R2 Data Deduplication and ISOs

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

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: , , , ,

<20 Watt Home Server for Hyper-V and ESXi

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

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: , , , , , , ,

SharePoint 2013 – Zero Byte ULS Logs

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

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: , , , ,

Operations Manager 2012 R2 – Data Warehouse can’t process performance data

February 4, 2014 4:26 PM / Leave a Comment /

We had the problem that our data warehouse can’t process all performance data being collected. To get rid of this problem you need to disable some performance collection rules in your opsmgr 2012r2 (preferable the ones you don’t need).

You may find out which one collect most data you can run the following queries against your dwh.

Performance insertions per day

SELECT CASE WHEN(GROUPING(CONVERT(VARCHAR(20), TimeSampled, 102)) = 1)
THEN ‘All Days’ ELSE CONVERT(VARCHAR(20), TimeSampled, 102)
END AS DaySampled, COUNT(*) AS PerfInsertPerDay
FROM PerformanceDataAllView with (NOLOCK)
GROUP BY CONVERT(VARCHAR(20), TimeSampled, 102) WITH ROLLUP
ORDER BY DaySampled DESC

To find the rules collecting the most Performance Signature data in the database

select managementpack.MPName, ruleview.DisplayName,
count(*) AS TotalPerfSig
from performancesignaturedata with (nolock)
inner join performancesignaturehistory with (nolock)
on performancesignaturedata.performancesignaturehistoryid = performancesignaturehistory.performancesignaturehistoryid
inner join performancesignature with (nolock)
on performancesignaturehistory.performancesignatureid = performancesignature.performancesignatureid
inner join ruleview with (nolock)
on ruleview.id = performancesignature.learningruleid
inner join managementpack with(nolock)
on ruleview.managementpackid = managementpack.managementpackid
group by managementpack.mpname, ruleview.Displayname
order by TotalPerfSig DESC, managementpack.mpname, ruleview.DisplayName

Good luck

Posted in: Microsoft, Operations Manager / Tagged: , , , , ,