MySQL Bugs: #26205: Not Conecting so MS SQL Server 2000

Bug #26205	Not Conecting so MS SQL Server 2000
Submitted:	9 Feb 2007 0:38	Modified:	9 Feb 2007 16:35
Reporter:	Alejandro Tobon	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S1 (Critical)
Version:	1.1.9	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any

Description:
firt, excuse me if my english is not very good, i'm from Colombia.

My problem is that MySQL Migration ToolKit is not conecting to MS SQL Server 2000, what can I Do.

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ... 
Driver class MS SQL JDBC Driver
Opening connection ... 
Connection jdbc:jtds:sqlserver://LocalHost:1433/DB_Orange;user=sa;password=c1d1;charset=utf-8;domain=
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMssql.getSchemata :Network error IOException: Connection refused: connect
Details: 
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:96)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(ReverseEngineeringMssql.java:99)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

How to repeat:
My problem is that MySQL Migration ToolKit is not conecting to MS SQL Server 2000, what can I Do.

Thank you for the bug report. I was not able to repeat when connecting
against SQL Server 2005. Notice you need to be sure that MS SQL Server
has enabled the TCP/IP protocol with 2005 version can be verified using
the Xp_readerrorlog (read the documentation of your version) and which
port is listening (in your error message you pasted the default one
which MySQL Migration Toolkit offers and on my side most of time isn't
the listening port). Also you need to setup the server to accept mixed
authentication.

Thanks in advance.

Hello Miguel, thanks for the help.

I have look for the advices you tell me and I see that the protocol TCP/IP is enabled at port 1433 and the mixed authentication is enabled to, I search for a posible solution, one of them was to change the port to 0, I have change to 0 on SQl Server 2000 and in the Migration ToolKit but it still doesn't work, when I did more research about the problem it looks like it's a problem with SQL Server 2000, the problem is produced when other aplication tries to connect to a port in SQL Server 2000, so I Install the latest service pack, the number 4, but it still doesn't work.

Please forgive me for all the problem, but I realy need to solve it, Thanks for your time I realy apreciate it

I get it work using "named pipes" :

Add the option ";namedPipes=true" in your connection string

Ex:
"jdbc:jtds:sqlserver://server1/db;namedPipes=true"

Read the faq at http://jtds.sourceforge.net/faq.html#connectionRefused