1433 - not open, trying to use MySQL Migration toolkit (MSSQL to MySQL)

hello,

i'm trying to migrate a MSSQL to MySQL. I'm using the MySQL Migration tool kits but i'm falling at the first hurdle.

as you can see from the screen shot its saying connection refused.

first of all i tried telnet 127.0.0.1 1433 and i got: "couldnt not open connection to host etc etc etc "

so then i tried netstat -an and i got loads of ports  but not 1433.

so...

i went to my firewall and completly opened all connections to 1433 then i tried the above again but got the same results.

am i barking up the wrong tree, is this whats stopping me from migrating or is it somehting else. what else should i try?

thanks
zac



MYSQL-MIGRATION.jpg
LVL 1
bede123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BitsqueezerCommented:
Hi,

maybe you have a named instance in the SQL Server, in this case you need to supply this, too - alternatively you could search for a port to the SQL Server which don't need to be 1433. Then you should look into the SQL Server Configuration Tool to look for the network configuration. And then you should look into the Windows Services list if the SQL Server Browser service is started which lists the instances for network accesses. SQL Server starts without that service and don't need it to run so it is not started in all cases.
Another way would be to use the SQL Server export module (only available in the full version of SQL Server Management Studio, not in the Express edition) which is really good. There is also a menu item to generate scripts from the database which can be used to adapt to MySQL.

Cheers,

Christian
0
bede123Author Commented:
thanks,

so here is what i have tried:

1, checked for instances via services
2, looked under SQL server configuration properties and its says is listening on port 1433
3, unfortunatly i only have sql management express.


port.jpg
0
bede123Author Commented:
image
sql.jpg
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

BitsqueezerCommented:
Hi,

so I guess it is SQL Server Express,too?
Where do you running the migration tool, on the SQL Server machine or from anywhere in the network? If it is your local machine you can simply use "localhost" as name or "127.0.0.1", with this you should have no problem with any firewall as there will be no network transfer.
But by default TCP/IP for example is disabled in SQL Server Express, you must enable it with the Configuration Manager and you should also enable named pipes.

Additionally this blog post can also help you:
http://blog.nolanbailey.com/2008/06/28/migrate-from-sql-server-2005-to-mysql/281

Cheers,

Christian
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
From your Snapshot port.jpg, it seems like you have configured it wrongly.
Disable Via protocol and then enable TCP/IP protocol and configure it like this
Make sure Dynamic ports are set to blank and TCP /IP ports set to 1433 or any other port.
And make sure that you have excluded the ports configured through Windows firewall.

Also check whether you have configured remote connections properly in SQL Server as per this:

http://support.microsoft.com/kb/914277
TCP-IP.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bede123Author Commented:
you got it! thanks so much. i followed your screen shot and it worked perfectly. i have an error now connecting to the MySQL db but i'm sure i can handle that.

thanks again.

0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Welcome..
And revert if you face any issues.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.