[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
jTDS Exception Connection Refused

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

jTDS Exception - Connection Refused.


Applies to: ManageEngine Applications Manager 9, Hyper-V, SQL Server 2008 SP1 CU4.

 

Problem Description.
 

We installed a SQL Server 2008 64-bit instance on a Hyper-V virtual machine,
and then tried to install ManageEngine Applications Manager 9 on another
Hyper-V virtual machine that will access the SQL Server instance.

We were unable to install ManageEngine Applications Manager 9 (AppManager 9)
and found the following errors on the logs generated by the setup program:

java.sql.SQLException: Network error IOException: Connection refused:
connect
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at jdbc.CreateSchema.createDataBaseAMDB_MSSQL(CreateSchema.java:154)
at jdbc.CreateSchema.instantiateConnection(CreateSchema.java:197)
at jdbc.CreateSchema.init(CreateSchema.java:84)
at jdbc.CreateSchema.main(CreateSchema.java:93)
at
com.adventnet.appmanager.server.startup.StartServer.startmysql(StartServer.j
ava:1268)
at
com.adventnet.appmanager.server.startup.StartServer.main(StartServer.java:86
9)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:136)
at java.lang.Thread.run(Unknown Source)

 

Cause.

In this case, this was an exception thrown by jTDS when it couldn't connect
to the remote instance of SQL Server over TCP/IP port 1433. TCP/IP was not enabled on the SQL Server instance.

 

Solution.

Perform the following steps to enable TCP/IP on the SQL Server instance:

1. Go to Start -> All Programs -> Microsoft SQL Server 2008 -> SQL Server
Configuration Manager

2. In SQL Server Configuration Manager, expand SQL Server Network
Configuration.

3. Click Protocols for MSSQLSERVER.

4. In the details pane, right-click the TCP/IP protocol, and then click
Enable.



5. Back in the console pane, click SQL Server Services.

6. In the details pane, right-click SQL Server (MSSQLSERVER), and then click
Restart, to stop and restart the SQL Server service.



 

If the problem continue after enabling TCP/IP, then verify your firewall is not blocking TCP/IP port 1433.



 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.