IBM Support

Trying to install PES 3.50 and install fails at Database details: [SPSSOEM][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect

Technote (troubleshooting)


Problem(Abstract)

Trying to install PES 3.50 and install fails at Database details

SQL Server 2005 / JBOSS - 4.2.0

URL = spss:jdbc:spssoem:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=SPSSPLAT
java.sql.SQLException: [SPSSOEM][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect
at spssoem.jdbc.base.BaseExceptions.createException(Unknown Source)
at spssoem.jdbc.base.BaseExceptions.getException(Unknown Source)
at spssoem.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at spssoem.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at spssoem.jdbc.base.BaseConnection.connect(Unknown Source)
at spssoem.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at spssoem.jdbc.base.BaseConnection.open(Unknown Source)
at spssoem.jdbc.base.BaseDriver.connect(Unknown Source)
at com.spss.datadirect.jdbc.SPSSDriver.connect(SPSSDriver.java:107)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.spss.setup.isat.db.DBConnection.getConnection(DBConnection.java:107)
at com.spss.setup.isat.ui.db.DBInfoPanel.testConnection(DBInfoPanel.java:147)
at com.spss.setup.isat.ui.db.DBInfoPanel.onNext(DBInfoPanel.java:131)
at com.spss.setup.isat.ui.WizardControl.selectNext(WizardControl.java:59)
at com.spss.setup.isat.ui.Wizard$NavNextAction.actionPerformed(Wizard.java:740)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231)
at java.awt.Component.processMouseEvent(Component.java:5501)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5266)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3968)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1778)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

Resolving the problem

Make sure that TCP/IP and NAMED PIPES are ENABLED for SQL Server 2005. Please Note: You will need to recycle the SQL Server after changes are made.

1. To verify that TCP/IP is ENABLED:
-> Go to START | PROGRAMS | MS SQL Server 2005 | Configurations Tools | SQL Server Configuration Manager | SQL Server 2005 Network Configuration

-> Click on Protocols for ....
-> on right side check to make sure TCP/IP says ENABLED
-> If NOt, right click and select ENABLED
->also Check to make sure NAMED PIPES are ENABLED
-> If NOT, right click and select ENABLED

2. Verify the IP Address and PORT #
->Then right click again on TCP/IP and select Properties
-> Select IP Adress Tab
-> Under first section you will see IP ADDRESS and PORT # to use for the install

Related information

Need more help? Our C&DS forum is Live!

Historical Number

76705

Document information

More support for: SPSS Collaboration and Deployment Services

Software version: Not Applicable

Operating system(s): IBM i, Windows

Reference #: 1481273

Modified date: 02 April 2011


Translate this page: