ireport 4.7.0 can't connect to MS SQL 2008 R2 database

0

Hi!

I am trying to connect ireport 4.7.0 to an MSSQL db and I am getting the following error:

SQL problems: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

 

jdbc:sqlserver://localhost:1433;databaseName=mydb
 
On SQL side the server is named localhost\SAC, the db is named testdb and I created an user: biuser / 12345678.
 
 
 
 
 
 
Exception
 
 
Message:
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
Level:
    SEVERE
Stack Trace:
The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
    com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
    com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
    com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
    com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
    com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:447)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:723)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:682)
    java.awt.EventQueue$3.run(EventQueue.java:680)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:696)
    java.awt.EventQueue$4.run(EventQueue.java:694)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:693)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:244)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:163)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:155)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
    java.awt.Dialog.show(Dialog.java:1077)
    java.awt.Component.show(Component.java:1651)
    java.awt.Component.setVisible(Component.java:1603)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1003)
    com.jaspersoft.ireport.designer.welcome.QuickStartPanel.jButton1ActionPerformed(QuickStartPanel.java:295)
    com.jaspersoft.ireport.designer.welcome.QuickStartPanel.access$200(QuickStartPanel.java:50)
    com.jaspersoft.ireport.designer.welcome.QuickStartPanel$2.actionPerformed(QuickStartPanel.java:124)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.Component.processMouseEvent(Component.java:6505)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
    java.awt.Component.processEvent(Component.java:6270)
    java.awt.Container.processEvent(Container.java:2229)
    java.awt.Component.dispatchEventImpl(Component.java:4861)
    java.awt.Container.dispatchEventImpl(Container.java:2287)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    java.awt.Container.dispatchEventImpl(Container.java:2273)
    java.awt.Window.dispatchEventImpl(Window.java:2719)
    java.awt.Component.dispatchEvent(Component.java:4687)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:723)
    java.awt.EventQueue.access$200(EventQueue.java:103)
    java.awt.EventQueue$3.run(EventQueue.java:682)
    java.awt.EventQueue$3.run(EventQueue.java:680)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    java.awt.EventQueue$4.run(EventQueue.java:696)
    java.awt.EventQueue$4.run(EventQueue.java:694)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:693)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:244)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:163)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:147)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:139)
    java.awt.EventDispatchThread.run(EventDispatchThread.java:97)
 
I am running this on Widnows Server 2008 R2 Standard.
 
to ireport classpath.
 
I have added ireport to firewall and created a rule to allow TCP IP connections on firewall.
 
In SQL conf man I have enabled TCP/IP connections and started SQL Server Browser:
 
 
What else can I do?
 
Can anyone help me out?
 
Thanks in advance,
 
Cheers,
 
JC
 
joaopcabrita's picture
Joined: Sep 22 2012 - 5:13am
Last seen: 2 years 1 month ago

2 Answers:

0

I'am not sure but it seems like you are using 2005 connector for 2008 sql server. Otherwise there is no reson to get such an error. Because I'm using that system as well

 

ismails's picture
21
Joined: Sep 22 2012 - 7:27am
Last seen: 1 week 2 days ago
0

Steps

  • Open the Sql Server Configuration Manager (Start -> Programs ->   Microsoft SQL Server 2008 -> Configuration Tools)
  •  Expand SQL Server Network Configuration -> [Your Server Instance]
  • Double click TCP/IP
  •  Under Protocol:
  •   Ensure Enabled is Yes
  •   Under IP Addresses:
  •   Scroll to the bottom and set the TCP Port under IPAll, (1433 by    default)
  •  Find the IP address you want to connect to and set Enabled and Active    to Yes
rajeshkannan.smi's picture
Joined: Nov 28 2012 - 4:00am
Last seen: 1 year 11 months ago
Feedback