Not able to connect to local database

[P User]

Hi

we are trying to connect to local database in SQL server 2008. I am giving my system IP address in "Host Name" field and 1433 in the "Port Number" field.
But while creating a connection we are getting following error:

Error connecting to database [local DB] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
Network error IOException: Connection refused: connect

org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
Network error IOException: Connection refused: connect
org.pentaho.di.core.database.Database.normalConnect(Database.java:370)
org.pentaho.di.core.database.Database.connect(Database.java:319)
org.pentaho.di.core.database.Database.connect(Database.java:281)
org.pentaho.di.core.database.Database.connect(Database.java:271)
org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2443)
org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:510)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:135)
org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
org.eclipse.jface.window.Window.open(Window.java:796)
org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:104)
org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
org.pentaho.di.ui.trans.step.BaseStepDialog$3.widgetSelected(BaseStepDialog.java:480)
org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.open(TableInputDialog.java:389)
org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7530)
org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2727)
org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:691)
org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1174)
org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6742)
org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:558)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)



Could any one help us to find the solution?

Thanks