• 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

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

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

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

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: Data Warehouse, OpsMgr, Performance, SCOM, SCOM 2012R2, SCOM2012

Post Navigation

1 2 Next »

Recent Posts

  • Recover ESXi 7.x Bootbank
  • Microsoft Edge URI List – Open Office Apps without Prompt for SharePoint
  • Boot Batocera from HDD
  • Synology iSCSI/LUN SSD Cache with DSM 7.0
  • Install EWSManagedAPI NuGet (GitHub) for SharePoint 2013/2016/2019

Recent Comments

  • XeroX on Boot Batocera from HDD
  • Dom on Boot Batocera from HDD
  • XeroX on Boot Batocera from HDD
  • mhmuc on Boot Batocera from HDD
  • mhmuc on Boot Batocera from HDD

Archives

  • November 2022
  • September 2022
  • September 2021
  • August 2021
  • November 2020
  • November 2015
  • June 2015
  • February 2015
  • August 2014
  • June 2014
  • February 2014
  • January 2014
  • November 2013
  • September 2013
  • August 2013

Categories

  • ESXi
  • FreeBSD
  • Hardware
  • Hyper-V
  • iOS
  • Microsoft
  • OfficeWebApps
  • Operations Manager
  • SharePoint
  • Synology
  • vCenter
  • VMWare
  • Webserver
  • Windows Server
© Copyright 2023 - Techspark
Infinity Theme by DesignCoral / WordPress
This website uses Cookies and Matomo to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Reject Opt-Out
Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
CookieDurationDescription
_pk_id.1.03ee1 year 27 daysMatamo set this cookie to store a unique user ID.
_pk_ses.1.03ee30 minutesThis cookie is used to store a unique session ID for gathering information on how the users use the website.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT
Powered by CookieYes Logo