Database Migration Error: My database is stored in MSSQL Server 2000 in a standalone system in windows authentication mode means without any username and password. I am writing my whole process & problem if you people could solve my problem.
In Source Connection Parameter Stored Connection : myLibrary Hostname : Localhost Port : 1433 username : . Password : Database : Library (I am explicitly specifing, It is not fetching by mySQL migration Tool) Next>>>>>>>>>>>>> Target Connection Parameter Stored Connection : Library Hostname : Localhost Port : 3306 Username : root password : ******** next >>>>>>>>>>>>>>>>> Connecting to source database system (failed) Retrieve schema information from source database system (failed) Test connection to target database system (not completed) from Advanced button in below I found following error message
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/Library;user=.;password=;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:95) 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)
Please send me solution immediately. Then I will try MySQL with these tools in Network architecture. Thank you Kishore K Barik Kolkata, India