'SSMA hangs on connecting to microsoft access database
SQL Server Migration Assistant for access hangs after selecting MS Access database, it just shows 0% and nothing happens. Up to this point, everything worked fine, but after I configured encrypted connections on the server with a TLS certificate, for some reason starts to hang at 0%. At the same time, SQL Server Management Studio connects over an encrypted connection without issues and no other issues were[enter image description here noticed anymore.
Solution 1:[1]
Perhaps this information will help someone. I was able to solve my issue in the following way. I uninstall SSMA first, then uninstall Microsoft Access Database Engine 2016 Redistributable. Rebooted the machine, downloaded it again, and installed first SSMA then Microsoft Access Database Engine 2016 Redistributable.
Solution 2:[2]
BTW, what I reported earlier was on a Windows 10 machine. Just tried on a Windows Server box and did not run into any problem. That Windows Server box had the most recent defender patch, a slightly different version of course. Version 1.343.352.0
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | rukia_m |
| Solution 2 | Joel Lachance |