SQL Power Software Forum

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.UnknownHostException:
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at ca.sqlpower.sql.SPDataSource.createConnection(SPDataSource.java:457)
at ca.sqlpower.swingui.SPDataSourcePanel$1.actionPerformed(SPDataSourcePanel.java:157)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Hi Adam,

From the stack trace it looks like you were trying to add a connection to your workspace but could not connect to the database. When a connection is being added to the project we try to connect to the data source to make sure you can use the connection. If we cannot connect to the data source then you won't be able to make queries or reports on the data source.

If you could provide more information we might be able to help you further. Some information that would help would be the data source's information, the version of Wabit you are using, steps that you took to cause this error, and anything else you think might be helpful.

Thomas

Hi, many thanks for the response. Database platform is SQL 2005. I tried adding a dabase connection by linling the JDBC driver from the default wabit install folder. Then I tried adding a new connection, with database typr selcted as SQL server 2005, connect options being the databse name and default port 1433. Username and password being the database username and password. The demo connection works perfect. i am somehow doinfg something wrong with the connection setup.

Hi Adam,

The error message says

The TCP/IP connection to the host has failed. java.net.UnknownHostException

This suggests to me that your machine cannot even connect the machine that's running the SQL Server instance you're trying to connect to.

You may want to make sure that you're specifying the correct hostname/IP address for the SQL Server machine.