JDBC connection to MS SQL server 2005 error.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

JDBC connection to MS SQL server 2005 error.

Author

Topic

akalehzan
Starting Member

21 Posts

Posted - 2007-10-12 : 12:19:09

Dear All,

Using JDBC trying to connect MS SQL server 2005. Getting the following error:


org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Network error IOException: Connection refused: connect
java.sql.SQLException: Network error IOException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Network error IOException: Connection refused: connect
java.sql.SQLException: Network error IOException: Connection refused: connect
java.net.ConnectException: Connection refused: connect

Here is the TCP/IP setting in our SQL server 2005:
I disable the Windows 2003 R2 firewall, but that didn’t help.
In SQL server 2005 for Remote connections:
Enabled “Local and Remote connections: Using both TCP/IP and Named Pipes
In TCP/IP Prosperities:

IP Addresses:
IP1: Active: Yes
Enabled: Yes
IP address: the server IP address Example 192.168.0.1
TCP Dynamic port: 0
TCP Port: 1433
///
IP2: Active: Yes
Enabled: Yes
IP address: the server IP address Example 192.168.0.1
TCP Dynamic port: 0
TCP Port: 1433
////
IP3: Active: Yes
Enabled: Yes
IP address: the server IP address Example 192.168.0.1
TCP Dynamic port: 0
TCP Port:
///
IP4: Active: Yes
TCP Dynamic ports: 1053
TCP Port:

For Protocols:
Under general:
Enable: Yes
Keep Alive: 30000
Listen ALL: Yes
No Delay: No

I think that should be enough info to start with.

Please advice.

Thanks for any help.

Abrahim

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-12 : 23:15:31

Change port number under ip4 to 1433 then restart sql. What's your connection string? Can you ping sql server from that machine?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources