After upgrading MsBuild to 17.12.6 and VS to Net9 SDK, MSBuild failing with MSB4244 "The SDK resolver assembly {path} could not be loaded"

I have an app that compiles the full suite of my projects using MSBuild and since updating to 17.12.6 and net9, any project referencing an SDK (custom or Microsoft.Net.Sdk) is failing with the error

The SDK resolver assembly "C:\Program Files\Microsoft Visual Studio\2022\Professional\MSBuild\Current\Bin\SdkResolvers\Microsoft.DotNet.MSBuildSdkResolver\Microsoft.DotNet.MSBuildSdkResolver.dll" could not be loaded

Here's a snippet of the code I'm trying to execute:

try
{
	var options = new ProjectOptions()
	{
    	GlobalProperties = new Dictionary<string, string>()
	    {
    	    { "SolutionPath", slnPath }, 
        	{ "SolutionName", slnName } 
	    }
	};

	var defaultProject = Project.FromFile(projectPath.Value, options);
}