Re: Network error IOException: Connection Refused: connect in MS SQL Server 2008
You need to set up your SQL Server 2008 instance to accept TCP/IP connections, which is how the Migration Toool communicates with SQL Server. On a default 2008 installation, this option is turned off.
1) Find your main SQL Server 2008 folder (usually "Microsoft SQL Server 2008"), go to "Configuration Tools" and launch "SQL Server Configuration Manager".
2) If everything is at the default location, the second item in your list should be "SQL Server Network Configuration". As a sub-item under that entry, there should be a listing for "Protocols for MSSQLSERVER". Click on that.
3) In the right hand pane, you should see four items (Shared Memory, Named Pipes, TCP/IP, and VIA). The value next to TCP/IP is probably "Disabled". Double click on the TCP/IP item.
4) Change the value of the "Enabled" item in the TCP/IP Properies window from "No" to "Yes". Hit the OK button.
5) Now click on the "SQL Server Services" item back in the main SQL Server Configuration Manager window. One of the items in the right hand pane should be "SQL Server (MSSQLSERVER)". Select that item.
6) Now click on the blue right hand facing arrow in the tool bar, the "Restart Service" button, to allow the new TCP/IP setting to take.
7) Try reconnecting with the MySQL Migration Tool again. It should now work.
Subject
Written By
Posted
Re: Network error IOException: Connection Refused: connect in MS SQL Server 2008
April 22, 2009 03:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.