Exception connecting to SQL Server

Bill Klish

Platform: Windows 2003 EE

I am still trying to get everything up and running. I created a brand new SQL Server 2000 SP3 database called INTERWOVEN on the same server as I planned on installing WorkSite MP 4.1 SP1. I got the Configuration Manager to show up. I added a server to the cluster with the current host's name. Then I went on to add a local library according to the installation guide with the following settings:

Library Name: INTERWOVEN
DB/Instance Name: INTERWOVEN
Driver: MS SQL Server
Owner: sa

Host: localhost
Port: 1433
Account: sa
Password: ********

I am able to log into the INTERWOVEN instance using the SA password and query the database. When I click test, this is what is getting thrown in the log file:

Tue Jul 05 11:53:36.843: INFO [AWT-EventQueue-0] Testing Library: INTERWOVEN
Tue Jul 05 11:53:50.015: INFO [PmClientMonitor] pm server on server 192.168.96.177 is available
Tue Jul 05 11:54:00.031: INFO [HeapSpaceMonitor] total=9m used=6m free=4m
Tue Jul 05 11:54:43.453: WARN [AWT-EventQueue-0] warn: exception=java.sql.SQLException: [WorkSite MP][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
at com.imanage.worksitemp.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.imanage.worksitemp.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.imanage.worksitemp.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.imanage.worksitemp.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.imanage.worksitemp.jdbc.base.BaseConnection.connect(Unknown Source)
at com.imanage.worksitemp.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.imanage.worksitemp.jdbc.base.BaseConnection.open(Unknown Source)
at com.imanage.worksitemp.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.imanage.cms.fc.sql.ImDriverManager.getConnection(ImDriverManager.java:35)
at com.imanage.cms.fc.config.DataSourceConfig.testURL(DataSourceConfig.java:351)
at com.imanage.cms.t1.gui.configmgr.controllers.LocalLibraryNode.testURL(LocalLibraryNode.java:272)
at com.imanage.cms.t1.gui.configmgr.views.LocalLibraryPanel$4.actionPerformed(LocalLibraryPanel.java:399)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.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 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.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog.show(Unknown Source)
at com.imanage.cms.t1.gui.configmgr.ConfigMgrFrame.showDialog(ConfigMgrFrame.java:1960)
at com.imanage.cms.t1.gui.configmgr.ConfigMgrFrame.addLocalLibrary(ConfigMgrFrame.java:1819)
at com.imanage.cms.t1.gui.configmgr.ConfigMgrFrame.access$700(ConfigMgrFrame.java:26)
at com.imanage.cms.t1.gui.configmgr.ConfigMgrFrame$6.actionPerformed(ConfigMgrFrame.java:561)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.Component.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.pumpOneEventForHierarchy(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)

Tue Jul 05 11:55:00.015: INFO [HeapSpaceMonitor] total=9m used=5m free=4m
Tue Jul 05 11:55:26.484: INFO [AWT-EventQueue-0] Local Library + INTERWOVEN test failed.

I hope I am missing something dumb.

Migrateduser

It looks like, for some reason, you can't get a JDBC connect:

Tue Jul 05 11:54:43.453: WARN [AWT-EventQueue-0] warn: exception=java.sql.SQLException: [WorkSite MP][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect

Not sure what the problem is, though. I'll forward to someone that might.

Kurt