title: JDBC connection to MSSQL server in windows authentication mode
body: <p>In my following programme I am trying to connect MSSQL Server using jdbc in windows authentication. But getting following error</p>
  
  <pre><code>import java.io.*;
  import java.sql.*;
  import java.util.GregorianCalendar;
  import java.util.Date;
  import java.text.DateFormat;
  import java.text.SimpleDateFormat;
  import java.util.Calendar;
  
  class  Cms_truncate
  {
      public static void main(String[] args) 
      {
           Calendar cal = new GregorianCalendar();
  
           //String name="cmscim";
           //String filename = "D:\\programs\\Tomcat 6.0\\webapps\\timescape\\canteen_scheduller\\CMS_CSV\\cms_cim\\"+ name+"-"+cal.get(Calendar.YEAR) +"-" +(cal.get(Calendar.MONTH)+1) + "-"+cal.get(Calendar.DATE)+".csv";
           Connection conn = null;
           String url = "jdbc:sqlserver://localhost:1433;databasename=CMS_TIMES_MAIN;integratedSecurity=true";
           String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
           String userName = ""; 
           String password = "";
           Statement stmt;
           try
           {
  
           Class.forName(driver);//.newInstance();
           conn = DriverManager.getConnection(url,userName,password);
           String query = "select * from cim where sapId=10025331";
           stmt = conn.createStatement();
           int flag = stmt.executeUpdate(query);
           System.out.println("flag = "+flag); 
           conn.close();
          System.out.println("");
           } catch (Exception e) {
           e.printStackTrace();
           }
  
      }
  }
  </code></pre>
  
  <p>I am using SQL Server in windows authentication mode.
  Do I need to do set up other things to connect MSSQL using jdbc in windows authentication.</p>
  
  <p>ERROR:</p>
  
  <pre><code>com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
      at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
      at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
      at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at Cms_truncate.main(Cms_truncate.java:28)
  </code></pre>