java与sql用windows身份连接,java连接到使用Windows身份验证的SQL Server

尝试将java连接到sql Server

package sd;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class test {

public static void main(String[] args) {

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=P_Cat_tweets;integratedSecurity=true");

System.out.println("test");

Statement sta = conn.createStatement();

String Sql = "select * from teewts";

ResultSet rs = sta.executeQuery(Sql);

System.out.println(rs.next());

} catch (Exception e){

e.printStackTrace();

}

}

}

错误： com.microsoft.sqlserver.jdbc.SQLServerException: 与主机localhost，端口1433的TCP / IP连接失败 . 错误："Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port." .