Connection to SQL Server Failed?
I am trying to connect to SQL Server... however, it fails. Here is the error I get (password replaced with xxx)
----------------------------------------------
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MS SQL JDBC Driver
Opening connection ...
Connection jdbc:jtds:sqlserver://127.0.0.1:1433/testdb;user=sa;password=xxx;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:141)
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)
----------------------------------------------
I am not sure what the hostname is supposed to be... When I enter SQL Server Management Studio... it says: USERPC\SQLEXPRESS (9.0.4035).
However, a guy on yahoo answers told me, it must be the default 127.0.0.1
And I assume that might be right as that goes to my Xampp page when I enter that in my browser?
I tried both IP addresses, as well as USERPC\SQLEXPRESS, but can't connect.
Subject
Written By
Posted
Connection to SQL Server Failed?
December 06, 2011 09:52AM
December 07, 2011 06:57AM
December 12, 2011 08:59PM
February 01, 2012 04:20AM
February 09, 2012 05:52AM
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.