SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 48%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Had this today, disabled Cloudflare WARP and it started working.
Unable to run SQL Server Migration Assistant for MySQL
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 28.000000000000004%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
John Wilson
15
Reputation points
I have installed SQL Server Migration Assistant for MySQL but it will 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 MySQL and SQL Server running on my computer. I've also installed the ODBC Driver for MySQL. This is the error: Cannot start because of an initialization error Try to restart the application. If this problem remains, contact support group (please provide a log file). Unexpected error. Details: 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()
SQL Server Migration Assistant
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
-
LiHongMSFT-4306 31,621 Reputation points2024-02-27T01:52:32.7466667+00:00 Hi @John Wilson Do you have both access to SQL Server and MySQL?
And what are the versions of your OS and ODBC?
-
John Wilson 15 Reputation points
2024-02-28T00:30:03.2166667+00:00 Running this on Windows 11 Enterprise Version 22H2. I have both SQL Server and MySQL installed locally and can access both systems.
Sign in to comment
2 answers
Sort by: Newest
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 87%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Juan Villicana 10 Reputation points2025-04-17T15:50:45.35+00:00 I found multiple posts with the same issue and no-one had the correct answer or an answer at all. This error is due to a unique scenario where you have multiple network adapters and the one on the top of the list either does not have a MACAddress or IPEnabled =false.
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