trying to connect sql server 2000 - not connected

[Anand Sivathanu]

hi,

I am trying to connect sql server.

i have installed the driver(jtds)

but unable to connect

unable to connection2
java.sql.SQLException: Network error IOException: Connection refused: connect

please help.

[Steve Fahlbusch]

As a start i would suggest.

Post your code (use code tags)

Post the exact and total error message

[Rob Spoor]

The machine is refusing the connection. Make sure that you are connecting to the right machine, it has the SQL Server running, no firewall is blocking access and SQL Server allows remote connections.

[Anand Sivathanu]

 
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class simpleServlet extends HttpServlet
{
    	public void doGet(HttpServletRequest req,HttpServletResponse res)throws IOException
	{
		PrintWriter out = res.getWriter();
		try
		{
                        Class.forName("net.sourceforge.jtds.jdbc.Driver");
			out.println("driver loaded");
		}
		catch (Exception e)
		{
			out.println("try again to load the driver");
			out.println(e.toString());
		}    
                
               	try
		{
                     Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa","admin");   
                      out.println("ready to access db");
                }
		catch (Exception e)
		{
			out.println("try again to connect");
			out.println(e.toString());
		} 
        }
       
}

I have ms sql server 2000 running in my machine port -1433(default)
username=sa
password=admin

this is the error(compile time)

java.sql.SQLException: Network error IOException: Connection refused: connect

[Campbell Ritchie]

This thread would sit better on our databases forum. Moving.

[Rahul Nair]

Do you have any Anti-virus software installed on you machine with firewall enabled ?, Because it may be block the request.
If you have, then disable its all operation and then check it...

[Paul Sturrock]

this is the error(compile time)

java.sql.SQLException: Network error IOException: Connection refused: connect

Compile time? Do you mean runtime?

I'm a little surprised you are getting as far as this SQLException, you are using jTDS but your JDBC URL is for Microsoft's own driver. Which are you using?

Connections are refused by SQL Server 2000 for the following reasons:

Using the wrong usernane or password

The server instance is not configured to accept TCP/IP connections (in SQL Server 2000 it is by default I think, later versions this is not true)

The server instance is configured to only use Windows Integrated authentication (which is t he default for SQL server)

The server OS doesn't have any service packs applied (out the box with no SPs SQL Server 2000 just doesn't seem to work).