SQL Server 2022 CU27: some Master Data Services features do not work as expected

Check script: am I affected? (PowerShell, read-only) iPowerShell script that applies the workaround documented by the vendor (or – clearly marked as a community workaround – one reported by several independent sources) – it first checks whether the system is affected, asks before changing, backs up first and offers to restore on the next run.

SQL Server 2022 CU27: some Master Data Services features do not work as expected

What it checks

The check reports whether SQL Server 2022 CU27 (KB5104824) is installed on this Windows device, which is the update named in the known issue. It changes nothing, writes no file and needs no internet.

What to do if affected

If the device runs SQL Server 2022 CU27 and uses Master Data Services, expect that creating entities or attributes and loading hierarchies in Explorer may not work. Microsoft is investigating a fix and no workaround is known, so wait for a later update that resolves the issue.

Result and exit code: AFFECTED = 5, NOT AFFECTED = 0, FIXED – solution installed = 0, UNCLEAR = 6, error = 1 (as an Intune detection script: 1 = affected, otherwise 0).

What exactly happens?

• Only reads – changes nothing, writes no file, needs no internet and asks no questions.
• Checks: update KB5104824 installed
• Reports the result with one line per condition and the next step.

What is checked

• Affected if: update KB5104824 installed

How to use the script – step by step

1. Download: on the entry page, read the terms and conditions (section "Free scripts") and the disclaimer, tick "I accept" and click "Download script". The file is saved in your "Downloads" folder.
2. Open PowerShell: press the Start key, type "PowerShell", press Enter. No administrator rights are needed – only if the result reports conditions as "not checkable", open PowerShell as administrator (right-click "Windows PowerShell" › "Run as administrator").
3. Change to the Downloads folder (type or paste the command, then press Enter):

   cd "$env:USERPROFILE\Downloads"

4. Compare the checksum: the command shows a long string. It must be exactly the same as "SHA-256" on the entry page (94748EB168FD64AC90DD75F850C8C6B22F0A9ED4A8B44C1A71CF6E689E5A4DA4). If it differs, delete the file and do not run it.

   (Get-FileHash .\ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1 -Algorithm SHA256).Hash

5. Unblock the file (Windows marks downloaded files). Alternatively in Explorer: right-click the file › Properties › tick "Unblock" at the bottom › OK.

   Unblock-File .\ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1

6. Allow scripts for this PowerShell window only. This only applies until you close the window – the computer's setting stays unchanged. If PowerShell asks, confirm with "Y".

   Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass

7. Run the script. It only checks: it changes nothing, writes no file and needs no internet.

   .\ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1

8. Read the result (at the bottom): "AFFECTED" – follow the steps under "what to do" (e.g. install the update or use the entry's fix script). "NOT AFFECTED" – nothing to do. "FIXED – solution installed" – nothing to do; you can undo a workaround you applied earlier. "UNCLEAR" – not everything could be checked: compare the details in the entry manually.
9. Download without a browser (RMM, software distribution): the address needs "&agb=1". This means the person deploying the script accepts the terms and conditions (section "Free scripts") and the disclaimer on behalf of their organisation.

   Invoke-WebRequest "https://www.it-sb.ch/ki-api/?a=dl&f=ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1&agb=1" -OutFile ".\ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1"

10. For many devices (RMM, scheduled task): command below, exit codes 0 = not affected or fixed, 5 = affected, 6 = unclear, 1 = error. Upload it as the detection script of an Intune remediation ("Run script in 64-bit PowerShell" = Yes): there it automatically reports 1 = affected, otherwise 0 (manually with -Intune).

    powershell.exe -NoProfile -ExecutionPolicy Bypass -File .\ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1

    powershell.exe -NoProfile -ExecutionPolicy Bypass -File .\ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1 -Intune

File

ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1 · no administrator rights needed

Version

1 · Date 1 Nov 2026 · 25 KB

SHA-256 iChecksum: compare it with Get-FileHash to make sure the file is unchanged.

94748EB168FD64AC90DD75F850C8C6B22F0A9ED4A8B44C1A71CF6E689E5A4DA4

Downloads

0

Source of the details

support.microsoft.com

Use at your own risk – no warranty, no liability if anything does not work or is wrong. Test before use and make a backup. Our terms and conditions (free scripts) apply. Generated automatically from the vendor’s statement and checked (rules, second AI review).

Download without a browser (RMM, software distribution): address with "&agb=1" – this means the person deploying the script accepts the terms on behalf of their organisation: https://www.it-sb.ch/ki-api/?a=dl&f=ITSB-Check-sql-server-2022-cu27-some-master-data-services-features-do-n-v1.ps1&agb=1