Connecting to MS SQL Server 2003 with JDBC.
843859Sep 10 2005 — edited Dec 10 2005I have a problem connecting to the MS SQL Server 2003.
When i execute my sample example coded in JDBC it gives me the error :
TCP/IP Connection failed . Connection Refused.
The authentication used in MS SQL Server 2003 is the SQL authentication. The port number used is 1433. But when i telnet the remote machine on which the SQL Server is installed on port number 1433 it gives me the error : Connection to the host lost.
Is this the problem with MS SQL Server 2003 ?
I changed the port number to 1400 but still the problem persists .
Are the settings of the SQL Server a problem . Because i have not used it much & it is been set by others.
The JDBC code is surely not a problem as i have checked that code on different machine with the databases.
I have tried other drivers but the error remains the same. ?