[tanvirtonu]

I m using SQL server 2005 express. My default logon mode setting is set to-SQL server authentication and I can logon to using SQL server management studio express always. I enabled TCP/IP from SQL server configuration manager. The sqljdbc.jar (JDBC driver) is set correctly in classpath and 1433 port is allowed in windows firewall. YET, I can’t connect to sql server using the following code-

Code:

import java.sql.*;
public class testconn {
Statement stmt;
Connection con = null;
       		String driver = "jdbc:sqlserver://";
		String server = "localhost:1433;";
		String db = "database=IDLC-Customer;";
		String user = "userName=Tanvir;";
		String pwd = "password=abcd;";
		
		String connectName = driver + server + db + user + pwd;     	
	testconn()
{	 try {
      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
      con= DriverManager.getConnection(connectName);
      stmt=con.createStatement();
       if(!con.isClosed())
        System.out.println("Successfully connected to " +
          "SQL server using TCP/IP...");
     } catch(Exception e) {
      System.err.println("Exception: " + e);    } 
     
 finally {     try {
        if(con != null)
          con.close();
        } catch(SQLException e) {}    			}         	
	} 
  public static void main(String args[]) {
  	
    testconn tc=new testconn();
  }
}

My host name is- Tanvir. So, in management studio express the server name is shown- TANVIR\SQLEXPRESS
When I run the code it says-The TCP/IP connection to the host has failed.
Java.net.connectException:Connection Refused: Connect
One more thing, though 1433 port is allowed in windows firewall, I can’t connect to that port using telnet (e.g. telnet <server_host> 1433).I even disabled firewall and tried but in vain. PLEASE help me any brother.