tcp连接失败java,java – JDBC连接失败,错误：TCP/IP连接到主机失败

我想连接Java类文件与SQL Server 2012.我已使用SQL Server身份验证登录。但我收到连接错误。

错误：

到主机127.0.0.1，端口1433的TCP / IP连接失败。错误：“连接拒绝：连接。验证连接属性确保在主机上运行SQL Server的实例并在端口上接受TCP / IP连接确保与该端口的TCP连接未被防火墙阻止。“。

我的代码—

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //1. Register your driver

//2. get the connection object

//Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost;databaseName=aysha","sa","admin");

Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=aysha","user=sa","password=admin");

//"jdbc:sqlserver://127.0.0.1:1433; Instance=SQL2008;" + "databaseName=MB;user=sa;password=123;";

//Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=aysha","sa" , "password");

//3. Prepare a statement

Statement stmt = con.createStatement();

//4. Write the query`

String sql = "Select * from employee";

//5. Execute the statement and

ResultSet rs = stmt.executeQuery(sql);

//6. Process the result set

while (rs.next())

{

System.out.println(rs.getInt(1));

}