Problem adding a JDBC datasource

[zubair]

I am trying to add a datasrource via Jrun admin and i keep getting the
following errors

Failed to connect to pubs [No such binding: pubs]. Please check to see if the
database is accessible and examine the JRun server log to determine why the
data source failed to start.

I am trying to connect to the pubs database on SQL server 2000. In sql server
i have a login for sa and a password which i am using to connect to the
dataource, but these don't seem to work. I have had a look at the log file and
this is the error pasted below.

Can anyone please help me? Thanks


03/10 21:46:22 error Encountered the following error while initializing
JDBCPool: {0}
java.sql.SQLException: SQLException while attempting to connect:
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect
at jrun.sql.pool.JDBCPool.createPhysicalConnection(JD BCPool.java:644)
at jrun.sql.pool.JDBCPool.create(JDBCPool.java:560)
at jrun.sql.pool.JDBCPool.create(JDBCPool.java:551)
at jrunx.pool.ObjectPool.checkOut(ObjectPool.java:242 )
at jrunx.pool.ObjectPool.init(ObjectPool.java:73)
at jrun.sql.pool.JDBCPool.init(JDBCPool.java:166)
at jrun.sql.pool.JDBCPool.<init>(JDBCPool.java:89)
at jrun.sql.pool.JDBCManager.createPool(JDBCManager.j ava:53)
at jrun.sql.management.DataSourceService.start(DataSo urceService.java:75)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unkno wn Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.jav
a:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1523)
at
jrun.deployment.resource.ResourceDeployer.startDat aSources(ResourceDeployer.java
:225)
at jrun.deployment.resource.ResourceDeployer.start(Re sourceDeployer.java:84)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unkno wn Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.jav
a:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1523)
at jrunx.kernel.ServiceAdapter.invokeMethod(ServiceAd apter.java:705)
at
jrunx.kernel.JRunServiceDeployer.invokeOnServices( JRunServiceDeployer.java:460)
at
jrunx.kernel.JRunServiceDeployer.startServices(JRu nServiceDeployer.java:312)
at
jrunx.kernel.JRunServiceDeployer.startLifecycle(JR unServiceDeployer.java:260)
at
jrunx.kernel.JRunServiceDeployer.deployServices(JR unServiceDeployer.java:87)
at jrunx.kernel.DeploymentService.loadServices(Deploy mentService.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.jav
a:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1523)
at jrunx.kernel.JRun.startServer(JRun.java:575)
at jrunx.kernel.JRun.<init>(JRun.java:493)
at jrunx.kernel.JRun$1.run(JRun.java:346)
at java.security.AccessController.doPrivileged(Native Method)
at jrunx.kernel.JRun.start(JRun.java:343)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.jav
a:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at jrunx.kernel.JRun.invoke(JRun.java:180)
at jrunx.kernel.JRun.main(JRun.java:168)

[mxstu]

"Connection refused:" error can often be caused by firewall(s) are blocking access to the database. Make sure your firewall(s) allow access to the database/port.