SSMA for MySQL - ODBC connector error

0

I have a 64-bit Windows 7. I have installed and configured both drivers (for 32-bit and for 64-bit architecture) using ODBC Data Source Administrator (System32, SysWOW64). However, when I try to install SSMA for MySQL, the following appears: "Setup is unable to find MySQL ODBC Driver v5.1 and above".

I tried to ignore this message by continuing the installation process, and it was successful.

Then, the second error appeared. When I tried to use SSMA (for migration from MySQL to SQL Server) and connect to SQL Server, the following appeared: "SQL Server Agent is stopped". I have tried to run it from services, but it didn't work: "SQL server agent has started but then stopped". I googled how to run this service, and found that it should work from "compmgmt.msc", but there are no "Local users and groups" section on my Windows (I am using Windows 7 Home edition). Why? When I run "lumgmt.msc", it gives an error: "local users and groups may be not available for Windows Home version". Also, when trying to run SQL Server Configuration Manage, in SQL Server services section, when tying to "request data from WMI provider", it gives an error: "the remote procedure call failed [0x800706be]".

Note that I am using SQL Server 2008 Express edition. If someone has encountered with similar problems, please explain if you resolved them.

If you know other ways to migrate from MySQL to SQL Server (and not by using SSMA), please explain.

I have read somewhere that SQL Server 2008 Express edition won't start SQL server Agent service. Is that correct? Which free version is working?

Also, WMI provider doesn't work on my computer. Why?

mysql
sql-server
sql-server-2008
migration
database-migration
asked on Stack Overflow May 6, 2018 by user9746514 • edited May 6, 2018 by user9746514

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0