Bonjour,
j'ai une base de donnée PROMOCR sous sqlserver 2005 et je voudrais effectuer une connexion via JDBC . Mais hélas j'ai une erreur
Voici ma classe de connexion

public class Test {
	
	public Test(){
		
		  String nomDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
		  //String url = "jdbc:sqlserver://localhost;" + "databaseName=PROMOCR;";
		  String url = "jdbc:sqlserver://localhost;databaseName=PROMOCR";
		  Connection connexion = null;
	      Statement instruction = null;
	      ResultSet executionRequete = null;
	      
		try {
			
			 // chargement du pilote JDBC
			Class.forName(nomDriver); 
			 // connexion
			 connexion = DriverManager.getConnection(url); 
			 // création d'une instruction
			 instruction = connexion.createStatement();
			 // requete SQL qui permet de lister les clé primaires
			 String requete = "EXEC sp_pkeys @table_name='CR'";
			 // execution de la requete
			 executionRequete = instruction.executeQuery(requete);
			while (executionRequete.next()) {
				System.out.println(executionRequete);
			}
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			
		}
		  catch (SQLException sqle){
			  sqle.printStackTrace();
		    
		  }
		  finally {
		         if (executionRequete != null) try { executionRequete.close(); } catch(Exception e) {}
		         if (instruction != null) try { instruction.close(); } catch(Exception e) {}
		         if (connexion != null) try { connexion.close(); } catch(Exception e) {}
		      }

		
	}

com.microsoft.sqlserver.jdbc.SQLServerException: Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused: connect
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at test_jdbc.Test.<init>(Test.java:22)
	at test_jdbc.Test.main(Test.java:52)

Configuration: Windows XP
Internet Explorer 7.0