Connection to SQL Server Failed?
Posted by: Cloe Stuart
Date: December 06, 2011 09:52AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Connection to SQL Server Failed?
December 06, 2011 09: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.