Unable to start Microsoft SQL Server Migration Assistant for Access

Question

Unable to start Microsoft SQL Server Migration Assistant for Access

Alister Oram 15

I have installed SQL Server Migration Assistant for Access, but it will not start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How can I resolve this? I have uninstalled and reinstalled the program a few times. I have AccessL and SQL Server running on my computer. I've also installed the Microsoft ODBC Driver 18 for SQL Server.

This is the error:

Exception: One or more errors occurred.

site:

source:

InnerException #1: The type initializer for 'Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData' threw an exception.

site: Void .ctor(Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Enums.TelemetryOperationType, System.Guid)

source: Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider

at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData..ctor(TelemetryOperationType operationType, Guid activityId)

at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Recorders.Abstraction.TelemetryEventRecorder.AddEvent(TelemetryOperationType eventType)

at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Recorders.TelemetryApplicationEventRecorder.WriteSetup(String osName, String productName, Boolean isInternal)

at System.Threading.Tasks.Task.Execute()

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

at Microsoft.SSMA.GUI.Product.SourceToTarget.Startup.GuiBootstrap`1.<InitializeAsync>d__11.MoveNext()

InnerException #2: Object reference not set to an instance of an object.

site: System.String GetMachineId()

source: Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider

at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData.GetMachineId()

at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData..cctor()

End Error.

1 answer

Your answer

Answer 1

Juan Villicana 10

I ran into this issue and ended up patching the GetMachineID() function in the Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.dll to return a dummy value when it could not find a network adapter with a valid MAC or IP. My specific issue was my Tailscale tunnel adapter that had IPEnabled = true but has a blank MAC address, and this is what was causing this to crash. You can either patch your DLL like i did or you can fix your network adapter order so the first one it pulls up has a MAC and IPEnabled = Tue. use this command to verify: Get-WmiObject Win32_NetworkAdapterConfiguration | Where-Object { $_.IPEnabled -eq $true } | Select Description, MACAddress, IPEnabled

Adil Kocaosmanlar 0 Reputation points

2025-04-19T12:47:41.97+00:00

Hi, thanks to Juan because of the answer which was very helpful for me to find another workaround for my issue. Because neither I could patch the DLL nor manipulate the MAC address of my Appgate Tunnel connection. It's clear that if you have connection with empty MAC address you get crash during SSMA load.

This is an interesting edge case where the Appgate Tunnel connection's MAC address being empty might have an unintended impact on other software. This might occur because Appgate Tunnel often requires a device's network identity, and having an empty MAC address might cause unexpected behavior or a conflict with how other software tries to interact with the network.

By disabling the Appgate Tunnel connection before opening SSMA and then enabling it afterward, I essentially avoided the issue caused by the empty MAC address field in the Appgate Tunnel connection.

This workaround bypasses the conflict between Appgate Tunnel and SSMA while still allowing you to use both. The fact that SSMA opens properly without the tunnel enabled and works fine once the tunnel is active is a great find!

Share via

Unable to start Microsoft SQL Server Migration Assistant for Access

1 answer

Your answer