Having odd issues with the task bar/random task bar freezing on Windows Server 2022 RDS? Or explorer.exe using around 10% of the CPU for every user that is logged in? This might save your day. This issue occurs if you have MS Teams installed on the RDS.
First of all, export the registry path HKLM\SYSTEM\Software\Microsoft\TIP\TestResults\27641370 and look at the file size. If it is around 40MB in size, then you have the same issue.
To resolve the issue, delete the key and disable the TabletInputService service (Touch Keyboard and Handwriting Panel Service). Afterwards, take ownership of C:\Program Files (x86)\Common Files\Microsoft Shared\ink\TabTip32.exe and C:\Program Files\Common Files\microsoft shared\ink\TabTip.exe and rename both executables into TabTip32.exe.orig/TabTip.exe.orig.
If you need to renew the Always On VPN IKEv2 server certificate, here are three lines that will help you. Assuming you have the right certificate and the thumbprint, execute the following commands on the VPN server:
If your users use a published application, you might have noticed that OneDrive does not automatically start after starting the app. This is by design, as it will only start in the full desktop, when Explorer.exe is running.
To ensure that Onedrive is starting with the Citrix Published Application, you can create a user logon script. This is one solution I have implemented, there are many others though.
C:\Program Files\Microsoft OneDrive\OneDrive.exe
/background
The other challenge: If the published application is closed, the session will still be open because Onedrive is still running, and the user will not be logged off. To change that behaviour, add Onedrive.exe and Microsoft.Sharepoint.exe as a value of this key:
Microsoft SQL Server administration is a big topic, but this short installation and configuration guide might help you get started with that.
First of all, download Microsoft SQL Server 2019 Express. You might get other versions (like MS SQL Standard) from your organization’s Licensing Portal (VLSC). The installation and configuration steps are the same. SQL Express can only have a maximum database size of 10GB and some other limitations.
Run the downloaded installer and export it somewhere. The setup will launch. We need a new SQL Server instance:
We are performing a brand new installation (I already had installed an instance on this server)
We need the database engine services:
Give the instance a name. You might name the instance after your application.
Leave all this to default
The User Database and log directory should be changed. Normally you have one disk for the database and another disk for the log database, like this:
In some cases, you might limit the amount of RAM the instance can use:
Hit next and let the installation finalize.
Open SQL Server Configuration Manager. Here you should activate the TCP/IP protocol, so that your instance is reachable from a server in the network.
The service has to be restarted:
By default, the instance will have a high port assigned. This can be changed to a lower port like 1433,1434, etc.
Do not forget to restart the instance service after the changes.
Next, configure Windows Firewall. You will need these ports: UDP 1434 for SQL Server Browser and the instance port (the high port TCP 64891 or the manually configured port TCP 1434).
To verify the connection, install Microsoft SQL Server Management Studio on another server in the same domain.
On the left side, you should see something if the login was successful:
In some cases you might need to enable mixed mode authentication, which allows you to authenticate with SQL users (for example the SA user) while also maintaining Windows Authentication.
After this change, the instance service has to be restarted.
Exchange Zero days are very common these days and there is a freshly baked one today (30th September 2022 as of writing). If you want to know what how the vulnerabilities work, take a look at the reference at the bottom. As a sysadmin I care about securing my systems.
Here are a few steps to mitigate this zero day vulnerability:
In IIS Manager on the Exchange Server, select the Autodiscover virtual directory and open URL Rewrite and add a new rule.