Connection pool problem with Sun Java System Web Server 7

chezhiworld
chezhiworld used Ask the Experts™
on
I try to create a connection pool to mssql server running on a remote
machine.Using com.microsoft.sqlserver.jdbc.SQLServerDataSource
as data source class name but when I try to getConnections I am getting the
following exception,

The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

I have enabled tcp in the server, the firewall is down, but I cant connect ! this is driving me nuts.

Please help me to resolve this asap.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
did you check the other possibilities
-> make sure that the sql server service is running
-> if it is already running, ensure that the default sql connection port is 1433
James MurrellProduct Specialist

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial