The TCP/IP connection to the host has failed. java.net.ConnectException: Connection r

[Mohit_Java]

While creating connection with database I am getting error as

I'm getting problem asOperation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: Connection could not be allocated because: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: no further information

please help me by giving the solution.

I am using SQ Server 2000, J2EE Server 1.4, Window Vista.
Sun Microsystems Application Server PE 8 and Microsoft SQL Server 2000 as database

server.log
[#|2010-03-02T00:40:15.814+0000|WARNING|sun-appserver-pe8.2|javax.enterprise.resource.resourceadapter|_ThreadID=13;|Connection could not be allocated because: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: no further information|#]


Thanks for help!

[Khalid Ali]

Connection refused could mean
1.that you are trying to connect on a port where there is no listener.
2.Make sure sql server is running and has the correct port configured
3.Machine where you are trying to connect to is turned on etc.